The database account used by the database link must have the SELECT_
CATALOG_ROLE role:
alter session disable guard;
create database link salesofc
connect to username identified by password using 'salesofc';
alter session enable guard;
You should verify the link by selecting from the DBA_LOGSTDBY_PARAMETERS view in the
remote database (the new primary database).
In each logical standby database, you can now start the redo apply process based on the new
primary database:
alter database start logical standby apply new primary salesofc;
Administering the Databases
In the following sections, you will see the steps required to perform standard maintenance actions
on the databases that are part of the Data Guard configuration, including startup and shutdown
operations.
Startup and Shutdown of Physical Standby Databases
When you start up a physical standby database, you should start the redo apply process. First,
mount the database:
startup mount;
Next, start the redo apply process:
alter database recover managed standby database
disconnect from session;
Use the using current logfile clause in place of the disconnect from session clause to start realtime
apply.
To shut down the standby database, you should first stop the Log Apply Services. Query the
V$MANAGED_STANDBY view; if Log Apply Services are listed there, cancel them using the
following command:
alter database recover managed standby database cancel;
You can then shut down the database.
Pages:
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747