Skip to main content

Posts

Showing posts from April, 2015

Solution to Problem: "ORA-01665: control file is not a standby control file"

Solution to Problem:   "ORA-01665: control file is not a standby control file" The Solution is to put the command to tell dataguard that this is physical standby. ALTER DATABASE CONVERT TO PHYSICAL STANDBY; Steps: SQL>  STARTUP MOUNT SQL>   SELECT database_role FROM v$database; DATABASE_ROLE —————- PRIMARY 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; So, now the control file is for Physical Standby database.