ORA-00205 error during the startup of physical standby database

dataguardoracleoracle-12c

Steps I have followed:-

  1. Created a physical standby database by using DUPLICATE TARGET DATABASE.

  2. Then checked the log gap between these two databases which was fine and in sync.

  3. After that standby database closed using the shutdown abort command.

  4. Then when tried to open the standby in mount mode it was showing this error.

ORA-00205: error in identifying control file, check alert log for more info)

  1. Checked the alert log where in the mentioned path there is no control file but in initSID.ora file, controlfile path mentioned correctly and which was different from what is showing in the alert log.

Best Answer

This problem occurs when your auxiliary (the clone target) database instance is started using a static init file. Smarter is to use the more dynamic spfile so the control_files parameter can be changed by the cloning procedure to where it is restored on the target.

I guess the question was: why this happened? ;-)

Related Question