Tuesday, October 11, 2022

ORA-00314, After Recovering the Standby DB from Service

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