Database Reference
In-Depth Information
As you can see from the above output the database is ready for switchover, so let's try:
DGMGRL> switchover to "CDBFSDCB"
Performing switchover NOW, please wait...
New primary database "CDBFSDCB" is opening...
Operation requires startup of instance "CDBFSDCA" on database "CDBFSDCA"
Starting instance "CDBFSDCA"...
ORACLE instance started.
Database mounted.
Switchover succeeded, new primary is "CDBFSDCB"
DGMGRL>
Congratulations, you have successfully switched over to the standby database. Many DBAs worry what could
happen during a switchover procedure, and the good news is: not too much. The worst case is a network problem
right at the time the switchover has been initiated. As part of the switchover Oracle will send a special token over the
network, indicating the last redo to be sent. This can be seen in the new primary database's alert.log.
2013-09-16 11:08:47.856000 +01:00
Media Recovery Log
/u01/fast_recovery_area/CDBFSDCB/archivelog/2013_09_16/o1_mf_1_14_93fp5h61_.arc
Resetting standby activation ID 2052880791 (0x7a5c7997)
Media Recovery End-Of-Redo indicator encountered
Media Recovery Continuing
Media Recovery Waiting for thread 1 sequence 15
SWITCHOVER: received request 'ALTER DTABASE COMMIT TO SWITCHOVER TO PRIMARY'
from primary database.
ALTER DATABASE SWITCHOVER TO PRIMARY (CDBFSDCB)
[...]
SwitchOver after complete recovery through change 1842430
[...]
Standby became primary SCN: 1842428
2013-09-16 11:08:54.953000 +01:00
Switchover: Complete - Database mounted as primary
SWITCHOVER: completed request from primary database.
Only if all the redo information has been received the switchover will occur. Therefore you cannot incur data loss.
As part of the switchover all databases in the Data Guard configuration will become standby databases (again, just a
flag in the control file). If the switchover failed for any reason, the database can be converted back to a primary and
resume normal operations.
If you made a mistake in statically configuring the DGMGRL services with the listeners you will get a message
that in order to complete the switchover you have to manually start the old primary. This is not a problem, and
once completed the Broker should return success when you check the status of the configuration. Verify that your
configuration is what you expect it to be:
DGMGRL> show configuration
Configuration - fsconfig
Protection Mode: MaxPerformance
Databases:
CDBFSDCB - Primary database
CDBFSDCA - Physical standby database
Search WWH ::
Custom Search