Hướng dẫn active database về chế độ standby sau khi đã chuyển sang primary

💡 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

2. Convert to standby database

$SQL> startup mount
$SQL> Alter database convert to physical standby;

3. 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;