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

Buğra PARLAYAN

2 years ago

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;