RECOVER STANDBY DATABASE

How to Resolve ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

by Ed Chen
November 19, 2021April 5, 2022

ORA-01610 Tried to perform RECOVER DATABASE on a mounted database by SQL statement, but it failed with ORA-01610. SQL> recover database until cancel; ORA-00283: recovery… Read More »

How to Resolve ORA-01153 an incompatible media recovery is active

by Ed Chen
May 8, 2016March 27, 2022

ORA-01153 Got an error ORA-01153 like this: SQL> recover standby database until cancel; ORA-01153: an incompatible media recovery is active Let's see the content of… Read More »

How to Interrupt "Recover Standby Database" with AUTO Enabled

by Ed Chen
May 2, 2015March 26, 2018

RECOVER STANDBY DATABASE is also call manual recovery of standby database, it has the same effect with RECOVER STANDBY DATABASE UNTIL CANCEL. You can set AUTO to… Read More »

How to Resolve ORA-00600 [3020] Stuck Recovery

by Ed Chen
July 9, 2013July 12, 2021

When recovering standby database 8i, I met the following errors: SQL> recover standby database; ... ORA-00279: change 439587243345 generated at 11/24/2010 02:23:39 needed for thread… Read More »