Skip to Content
0
Former Member
Aug 27, 2008 at 04:15 AM

BR0017E Offline redo log file not found

1154 Views

Dear all,

We have ECc 5.0 system on Oracle 10G platform and we have been taking daily online+redo log backup , our log_archive_format is set to ARC%S_%R.%T

Since monday our database online backup gives error before it triggers Redo log backup,

but Redo log backup finishes successfully. If we take online database and Redo log backup

seperately then both finishes without any error. But online+Redo log backup gives error as below.

BR0280I BRBACKUP time stamp: 2008-08-26 05.47.21

#FILE..... F:\ORACLE\PRD\SAPDATA1\PROTD_1\PROTD.DATA1

#SAVED.... 1219742470

BR0280I BRBACKUP time stamp: 2008-08-26 05.47.21

#FILE..... F:\ORACLE\PRD\SAPDATA6\DOCUI_2\DOCUI.DATA2

#SAVED.... 1219742470

BR0280I BRBACKUP time stamp: 2008-08-26 05.47.25

BR0232I 167 of 167 files saved by backup utility

BR0230I Backup utility called successfully

BR0280I BRBACKUP time stamp: 2008-08-26 05.47.29

BR0340I Switching to next online redo log file for database instance PRD ...

BR0321I Switch to next online redo log file for database instance PRD successful

BR0117I ARCHIVE LOG LIST after backup for database instance PRD

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination E:\oracle\PRD\saparch\PRDarch

Archive format ARC%S_%R.%T

Oldest online log sequence 103241

Next log sequence to archive 103244

Current log sequence 103244 SCN: 1254271607

Database block size 8192 Thread: 1

Current system change number 1254271609

BR0018I Waiting for the next offline redo log file...

BR0017E Offline redo log file E:\oracle\PRD\saparch\PRDarchARC103243_0493824548.001 not found

BR0056I End of database backup: bdyrdzmp.anf 2008-08-26 05.47.34

BR0280I BRBACKUP time stamp: 2008-08-26 05.47.34

BR0054I BRBACKUP terminated with errors

BR0280I BRBACKUP time stamp: 2008-08-26 05.47.34

BR0291I BRARCHIVE will be started with options '-U -d util_file -c -c force -u system/manager'

BR0280I BRBACKUP time stamp: 2008-08-26 07.45.55

BR0292I Execution of BRARCHIVE finished with return code 0

After deep analysis we found that there was change in number of digits for

Redo Number from 99998 , 99999 , 100000 , 100001..... and so on

Since these number of digit bacme 6 this error started appearing.

Could anybody let me know how could we avoid this error. becuase

in archivelog destination database is still creating Redo files as below

99998 PRDarchARC99998_0493824548.001

99999 PRDarchARC99999_0493824548.001

100000 PRDARCHARC00000_0493824548.001

100001 PRDARCHARC00001_0493824548.001

from 100000 series one digit is missing at OS level , and same has been reflected in backup

Regards,

RR