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
  1. Convert to standby database
$SQL> startup mount
$SQL> Alter database convert to physical standby;
  1. 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;

Related posts

Khắc phục lỗi recovery khi OPEN RESETLOGS lỗi SYSTEM trong Oracle Database?

check the FRA usage and troubleshoot the issue in oracle DB

ORA-16086: Redo data cannot be written to the standby redo log