Testing for Availability - Expert Oracle RAC Performance Diagnostics and Tuning - page 79

Shutdown all instances except one instance and verify the status
INST INSTN FFS FFCT FFT FFOP OM DUN DBR
---- ------ ------------- ------- --- ----- ---------- ------ ---------
1 SSKY1 SYNCHRONIZED SSKYDG 60 YES READ WRITE SSKYDB PRIMARY
Using the same query above, verify the standby database has the SYNCHRONIZED status also and once
confirmed start the SWITCHOVER operation using DGMGRL utility.
INST INSTN FFS FFCT FFT FFOP OM DUN DBR
---- ------ ------------- ------- --- ------ -------- ------ ----------------
1 SSKYDG SYNCHRONIZED SSKYDG 60 YES MOUNTED SSKYDG PHYSICAL STANDBY
DGMGRL> connect sys/oracle
Connected.
DGMGRL> switchover to 'SSKYDG';
Performing switchover NOW, please wait...
The above operation will start the shutdown of the only remaining RAC instance.
Operation requires shutdown of instance "SSKY1" on database "SSKYDB"
Shutting down instance "SSKY1"...
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
The next steps in the SWITCHOVER operation is for the DGB to shutdown the standby database and change the
state from STANDBY to PRIMARY .
Operation requires shutdown of instance "SSKYDG" on database "SSKYDG"
Shutting down instance "SSKYDG"...
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
The DGB attempts to start the new primary and new standby instances. Unfortunately, because the listeners
are not aware of these shutdown instances, Oracle returns an ORA-12514 error. At this time a manual intervention is
required to start up the databases.
Operation requires startup of instance “SSKY1” on database “SSKYDB”:
Starting instance "SSKY1"...
Unable to connect to database
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Failed.
You are no longer connected to ORACLE
Please connect again.
Unable to start instance "SSKY1"
You must start instance "SSKY1" manually
Operation requires startup of instance "SSKYDG" on database "SSKYDG"
You must start instance "SSKYDG" manually
Switchover succeeded, new primary is "SSKYDG"