At this point, you should shut down the primary database and mount it:
shutdown immediate;
startup mount;
The primary database is prepared for the switchover; you should now go to the physical standby
database that will serve as the new primary database.
In the physical standby database, check the switchover status in the V$DATABASE view; its
status should be TO PRIMARY (see Table 13-2). You can now switch the physical standby database
to the primary via the following command:
alter database commit to switchover to primary;
Switchover_Status Value
NOT ALLOWED The current database is not a primary database with standby
databases.
PREPARING DICTIONARY This logical standby database is sending its redo data to a
primary database and other standby databases to prepare for
the switchover.
PREPARING SWITCHOVER Used by logical standby configurations while redo data is
being accepted for the switchover.
RECOVERY NEEDED This standby database has not received the switchover request.
SESSIONS ACTIVE There are active SQL sessions in the primary database; they
must be disconnected before continuing.
SWITCHOVER PENDING Valid for standby databases in which the primary database
switchover request has been received but not processed.
SWITCHOVER LATENT The switchover did not complete and went back to the
primary database.
TO LOGICAL STANDBY This primary database has received a complete dictionary
from a logical standby database.
Pages:
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742