ORA-01665 control file is not a standby control file
Posted by Mir Sayeed Hassan on January 4th, 2022
ORA 01665 control file is not a standby control file
This error occour while starting the recovery process on standby database.
Check the status of database
SQL> select instance_name,open_mode,status from V$instance, v$database; INSTANCE_NAME OPEN_MODE STATUS ---------------- -------------------- ------------ testdb-std1 MOUNTED MOUNTED
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
SQL> select database_role from V$database; DATABASE_ROLE ------------- PRIMARY
SQL> alter database convert to physical standby;
Database altered.
Shutdown database
SQL> shu immediate ORA-01507: database not mounted ORACLE instance shut down.
Startup database in mount mode
SQL> startup mount; ORACLE instance started. Total System Global Area 4877066240 bytes Fixed Size 2212856 bytes Variable Size 2348813320 bytes Database Buffers 2483027968 bytes Redo Buffers 43012096 bytes Database mounted.
Verify the status of the database
SQL> select database_role from V$database; DATABASE_ROLE ---------------- PHYSICAL STANDBY
SQL> alter database recover managed standby database using current logfile disconnect from session; Database altered.
SQL> select process, status, thread#, sequence#, block#, blocks from v$managed_standby ; PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS --------- ------------ ---------- ---------- ---------- ------- ARCH CLOSING 1 53202 49152 164 ARCH CLOSING 1 53203 1 1980 ARCH CLOSING 1 53204 1 5 ARCH CONNECTED 0 0 0 0 ARCH CLOSING 1 53205 2049 1469 ARCH CLOSING 1 53208 1 27 RFS IDLE 0 0 0 0 MRP0 APPLYING_LOG 1 53210 674 204800