on 08-27-2008 5:15 AM
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
Hi,
Check Note 490976 - BR013W No offline redo log files found for processing
regards,
kaushal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.