ORA-01665 control file is not a standby control file

 

• Recently while working on a standby node we encountered ORA-01665 control file is not a standby control file when we tried to start mrp process. 

SQL> alter database recover managed standby database using current logfile disconnect from session;
alter database recover managed standby database using current logfile disconnect from session
*
ERROR at line 1:
ORA-01665: control file is not a standby control file

• When checked database role noticed it's set to primary.

SQL> select database_role from V$database;
DATABASE_ROLE
-------------
PRIMARY

• Converted it to physical standby

SQL> alter database convert to physical standby;
Database altered.

• Stop the database

SQL> shut immediate

ORA-01507: database not mounted
ORACLE instance shut down.

• Start it in mount state

SQL> startup mount;
ORACLE instance started.

Total System Global Area 3221225472 bytes
Fixed Size 2212856 bytes
Variable Size 2348813320 bytes
Database Buffers 2483027968 bytes
Redo Buffers 43012096 bytes
Database mounted.

•  Verify database status

SQL> select database_role from V$database;
DATABASE_ROLE
----------------
PHYSICAL STANDBY

• Start mrp now 

SQL> alter database recover managed standby database using current logfile disconnect from session;
Database altered.