Thursday, January 13, 2011

ORA-01666 When Trying to Activate Standby Database

When Trying to Activate Standby Database , and you use startup or startup mount you will get ORA-01666: controlfile is for a standby database

You must not forget that since this is the standby you must do :

sqlplus / as sysdba
startup nomount
alter database mount standby database;

Then you can perform any operation you want
e.g
start the automatic recovery session
fix a gap on log sequences
etc

No comments:

Post a Comment