The redo data from the
logical standby database is sent but is not applied at this point.
In the primary database, you must now verify that the dictionary data was received from the
logical standby database. The SWITCHOVER_STATUS column value in V$DATABASE must read
TO LOGICAL STANDBY in the primary database before you can continue to the next step. When
that status value is shown in the primary database, switch the primary database to the logical
standby role:
alter database commit to switchover to logical standby;
You do not need to shut down and restart the old primary database. You should now go
back to the original logical standby database and verify its SWITCHOVER_STATUS value in
V$DATABASE (it should be TO PRIMARY). You can then complete the switchover; in the original
logical standby database, issue the following command:
alter database commit to switchover to primary;
The original logical standby database is now the primary database. In the new logical standby
database (the old primary database), start the redo apply process:
alter database start logical standby apply immediate;
The switchover is now complete.
490 Oracle Database 11g DBA Handbook
Failovers to Physical Standby Databases
Failovers occur when the primary database can no longer be part of the primary database
configuration. In this section, you will see the steps required to fail over a physical standby
database to the role of the primary database in a Data Guard configuration.
Pages:
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744