Redo log backup to disk is failed

[Former Member]

Hi,

My Archive log backup to disk is failed

BR0002I BRARCHIVE 7.00 (13)

BR0006I Start of offline redo log processing: aeamsbyx.svd 2009-05-04 15.15.07

BR0477I Oracle pfile E:\oracle\DV1\102\database\initDV1.ora created from spfile E:\oracle\DV1\102\database\spfileDV1.ora

BR0101I Parameters

Name Value

oracle_sid DV1

oracle_home E:\oracle\DV1\102

oracle_profile E:\oracle\DV1\102\database\initDV1.ora

sapdata_home E:\oracle\DV1

sap_profile E:\oracle\DV1\102\database\initDV1.sap

backup_dev_type disk

archive_copy_dir W:\oracle\DV1\sapbackup

compress no

disk_copy_cmd copy

cpio_disk_flags -pdcu

archive_dupl_del only

system_info SAPServiceDV1 SAP2DQSRV Windows 5.2 Build 3790 Service Pack 1 Intel

oracle_info DV1 10.2.0.2.0 8192 21092 71120290

sap_info 46C SAPR3 DV1 W1372789206 R3_ORA 0020109603

make_info NTintel OCI_10103_SHARE Apr 5 2006

command_line brarchive -u / -c force -p initDV1.sap -sd

BR0013W No offline redo log files found for processing

BR0007I End of offline redo log processing: aeamsbyx.svd 2009-05-04 15.15.11

BR0280I BRARCHIVE time stamp: 2009-05-04 15.15.11

BR0004I BRARCHIVE completed successfully with warnings

I have checked the target directory nothing is backed up and gone through few SAP notes 10170, 17163, 132551, 490976 and 646681 but nothing is helped.

And anohter question is in DB13 Calander --> Schedule an action pattern maximum I can backup only 1 month redo logs. But I have 3 months redo log files are there. How can I back up those files.

Our environment is SAP R/3 4.6C, windows 2003 and Oracle 10.2.0.2.0

Please some one help me on this.

Thanks and Regards

Satya

[markus_doehr2]

> BR0002I BRARCHIVE 7.00 (13)

Your BR*tools are really old - consider updating them to the latest patchlevel (40 or 41).

> BR0013W No offline redo log files found for processing

and that is your "problem" - there simply no redo logs or they were already all backed up.

Markus

[Former Member]

Hi Markus,

The redo log files are there, I have checked. Past 3 months there was no back up. I need to back up past 3 months redo logs.

As I already mention that using DB13, I can back up only 1 month redo files but I want 3 months. Can you help me on regard also?

Thanks and Regards

Satya

[Former Member]

I would suggest you to take consistent offline backup once and then keep backing up the online/offline redo logs frequently. Remember there is impact on recovery time if you had to restore them.

[Former Member]

way 1

- run a offline backup

- after that you can skip the old archives... you've a consistent backup

way 2

- run a online backup and directly after that a archive log backup... you've a consistent backup

- run a cleanup

backup your db daily!

[Former Member]

Hi Thomas,

way2.....

How am I supposed to take online archive log backup (3 months files)? It is failing very time with "BR0013W No offline redo log files found for processing "

Thanks and Regards

Satya

[Former Member]

Did you try to delete or rename your arch<SID>.log file, as suggested in SAP note 490976 ?

[Former Member]

Hi Joe,

No.

Thanks and Regards

Satya

[Former Member]

Update your BRTools. They are very old.

Check that your DB is in archive-log-mode. If no enable it.

testing backup

- run a online backup

- run "sqlplus / as sysdba"

- SQL> alter system switch logfile; ... this switches the current online log... a new log will written to oraarch.

- run a archivelog backup

... now you should have complete db-backup with minimum 1!!! archive log.

Now you can delete old redologs from oraarch.

If this doesn't work and your database is in archive-log-mode:

- shutdown sap and oracle

- MOVE all redologs from oraarch to a other location manually... no more files should be on oraarch

- run a offline backup

If the offline backup was running successfully you can delete the prior moved redologs. The backup is consistent and the redologs will no more required.

- start oracle and sap

Oracle should now write new redologs to oraarch. Test online backup!

Edited by: Thomas Rudolph on May 6, 2009 10:16 PM

Edited by: Thomas Rudolph on May 6, 2009 10:17 PM

[Former Member]

No.

I'd urgently recommend you try.

Been there, done that, it helped.