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.
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.