ORA-01665: Control File Is Not A Standby Control File

In today’s article, I will share with you the solution to the error I got after restoring the backup database from the RMAN backup.

ORA-01665: Control File Is Not A Standby Control File

First we check the database_role of STANDBY.

sql> SELECT database_role FROM v$database;
 
DATABASE_ROLE
—————-
PRIMARY

sql> SELECT database_role FROM v$database;

DATABASE_ROLE

—————-

PRIMARY

After, we convert Primary database to Standby database.

sql> Alter database convert to physical standby;

sql> startup mount;
sql> SELECT database_role FROM v$database;
DATABASE_ROLE
—————
PHYSICAL STANDBY

sql> Alter database convert to physical standby;

sql> startup mount;

sql> SELECT database_role FROM v$database;

DATABASE_ROLE

—————

PHYSICAL STANDBY

sql> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE disconnect from session;

1	sql> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE disconnect from session;

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux