Problem:
On a 19.5 standby DB, I wanted to quickly recover it due to long lag using RECOVER STANBDY DATABASE FROM SERVICE command without the need to wait for the archivelogs to be transferred, but I was getting the following error whenever I restart the DB:
RMAN> RECOVER STANDBY DATABASE FROM SERVICE PRC;
Excerpt from the DB alert log:
ORA-00314: log 22 of thread 1, expected sequence# 83127 doesn't match 0
Solution:
Clear the REDO LOG files that appear in the above error message:
SQL> recover managed standby database cancel;
SQL> alter database clear logfile group 22;
SQL> alter database clear unarchived logfile group 22;
SQL> recover managed standby database using current logfile nodelay disconnect;
Reference:
ORA-00314: LOG 404 OF THREAD 4, EXPECTED SEQUENCE# 33808 DOESN'T MATCH 33543 (Doc ID 1077564.1)
No comments:
Post a Comment