online production backup fails, error says redo log file "**" not found

[Former Member]

Hi all my online production backup is failing from the last two days. Looked at db12 detailed log and this is what it says.

"Archive destination h:\oracle\RFP\saparch

Archive format ARC%S_%R.%T

Oldest online log sequence 34

Next log sequence to archive 37

Current log sequence 37 SCN: 263035976

Database block size 8192 Thread: 1

Current system change number 263035978 ResetId: 694634757

BR0017E Offline redo log file 'K:\oracle\RFP\saparch\ARC00036_0694634757.001' not found

BR0056I End of database backup: bebftuwp.and 2009-08-13 17.51.51

BR0284I BRBACKUP time stamp: 2009-08-13 17.51.51, elapsed time: 0:03

BR0054I BRBACKUP terminated with errors"

Kindly help me,

Regards,

Sebastian

[anindya_bose]

Hi

Probably this is the problem with your archive format. My reply on this that guess that this is the problem with Arvhice log format. You can better check the notes and in your system and then decide.

Th solution is to change the value of the Oracle parameter LOG_ARCHIVE_FORMAT in initSID.ora from ARC%S_%R.%T to ARC%s_%R.%T, ie. change '%S' to '%s'.

Please check SAP Notes 132551 (Overflow log sequence numbers on NT) and 490976 (BR013W No offline redo log files found for processing) which reinstates this fact.

The procedure to archive the previously written redo logs with abbreviated log numbers is also mentioned in the SAP Note 490976.

This will require an Oracle restart as this patameter LOG_ARCHIVE_FORMAT is a static parameter.

Rename all redo logs <name><5digits><rest> to <name>1<5digits><rest> ..ie padding with '1'.

[Former Member]

thanks all, i copied the achive file 36 and ran the backup, it worked fine.

[Former Member]

Hi,

Check archive file Seq 36 available on path K:\oracle\RFP\saparch.

if not available to then first take full offline backup.

Thn try archive backup -cds

If u 'h define multiple archive destination mention it

[Former Member]

Hi Sebastain,

Your backup failed when it tries to take backup of archive log sequence number 37, it is looking for reference in previous archive log file 36. Tried to keep the file in the same location. Start the backup again. This will work

Regards

KT