171
💡 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
1. Check the database_role of STANDBY.
sql> SELECT database_role FROM v$database;
DATABASE_ROLE
—————-
PRIMARY
- Convert to standby database
$SQL> startup mount
$SQL> Alter database convert to physical standby;
- Now mount again:
sql> startup mount;
sql> SELECT database_role FROM v$database;
DATABASE_ROLE
—————-
PHYSICAL STANDBY
4 Bật lại recovery
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE disconnect from session;