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

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarANKUSH THAVALI
  • 14 Dec, 2023
  • 0 Comments
  • 1 Min Read

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

PROBLEM:

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

SOLUTION: Check the database_role of STANDBY
sql> SELECT database_role FROM v$database;

DATABASE_ROLE
—————-
PRIMARY

Convert to standby database.
 sql> Alter database convert to physical standby; 
Now mount again:
 
sql> startup mount;

sql> SELECT database_role FROM v$database;

DATABASE_ROLE
—————-
PHYSICAL STANDBY
Start recovery
 sql> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE disconnect from session;