Today I faced below issue with one of our DR database when script was trying to recover the DR database using backup control file.
SQL> Connected.
SQL> ORA-00279: change 5969061003709 generated at 03/05/2016 20:44:59 needed for
thread 1
ORA-00289: suggestion : /u01/archive/STDB/STDB_1_129932_777534547.arc
ORA-00280: change 4969061003109 for thread 1 is in sequence #129942
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00317: file type 0 in header is not log file
ORA-00334: archived log: '/u01/archive/STDB/STDB_1_129932_777534547.arc'
Solutions : I found that archive log seq# 129942 was corrupted at DR host that was copied from Primary hence it was not applying to DR so a fresh copy of this archive log copied to DR manually and re-ran the DR sync script it got resolved.
Hope it would help someone...!!
SQL> Connected.
SQL> ORA-00279: change 5969061003709 generated at 03/05/2016 20:44:59 needed for
thread 1
ORA-00289: suggestion : /u01/archive/STDB/STDB_1_129932_777534547.arc
ORA-00280: change 4969061003109 for thread 1 is in sequence #129942
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00317: file type 0 in header is not log file
ORA-00334: archived log: '/u01/archive/STDB/STDB_1_129932_777534547.arc'
Solutions : I found that archive log seq# 129942 was corrupted at DR host that was copied from Primary hence it was not applying to DR so a fresh copy of this archive log copied to DR manually and re-ran the DR sync script it got resolved.
Hope it would help someone...!!
No comments:
Post a Comment