ANKUSH THAVALI14 Dec, 20230 Comments1 Min ReadORA-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; Oracle DBAShare: ORA-1495 :Specified Chained Row Table Not FoundORA-02396: Exceeded Maximum Idle Time, Please Connect Again