I am trying to do switch over and switch back process in one of our environments. We are not using data guard broker and performing it manually.
Oracle release version: 11.2.0.4
Server OS : Aix 7.1.
Step Primary:
SELECT MAX(SEQUENCE#) FROM V$ARCHIVED_LOG;
select switchover_status from v$database ;
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY ; -- This is failing with ora-01665 control file is not a standby controlfile.
shutdown immediate;
startup nomount;
alter database mount standby database;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Standby:
Alter Database Recover Managed Standby Database Cancel;
Alter Database commit to switchover to primary with session shutdown;
Shutdown Immediate;
Startup;
SELECT MAX(SEQUENCE#) FROM V$ARCHIVED_LOG;
Can someone please let me know what's wrong?