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 file
SOLUTION:
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;