1234567
ORA-01665: Control File Is Not A Standby Control File
PROBLEM:
After restoring standby database from RMAN backup, got below error, while mounting standby database , getting below error.
ORA-01665: control file is not a standby control file1234567891011121314151617181920212223242526272829
Check the database_role of STANDBY
sql> SELECT database_role FROM v$database;
DATABASE_ROLE
—————-
PRIMARY
Convert to standby database.
sql> Alter database convert to physical standby;
Now mount again:
sql> startup mount;
sql> SELECT database_role FROM v$database;
DATABASE_ROLE
—————-
PHYSICAL STANDBY
Start recovery
sql> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE disconnect from session;