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

Default image

Error: ORA-16765: Redo Apply is running

Default image

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

Default image

check the FRA usage and troubleshoot the issue in oracle DB