cancel
Showing results for 
Search instead for 
Did you mean: 

BR0017E Offline redo log file not found

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Check Note 490976 - BR013W No offline redo log files found for processing

regards,

kaushal

Former Member
0 Kudos

Hello,

I got the same problem. When Online+Log scheduled backup was getting failed and if we schedule redolog backup seperately it is giving meesage " No redologs found for processing" even though few files are there at destination.

Got this error due to a parameter

log_archive_dest=' ' (It is blank)

Removed this parameter as already we had another parameter log_archive_dest_1='LOCATION=/oracle/<DBSID>/oraarch/<DBSID>arch MANDATORY

Problem has been solved after removing this parameter from initSID.ora

Edited by: ramesh on May 5, 2009 4:05 AM