Opening Physical Standby Databases in Read-Only Mode
To make the physical standby database open for read operations, you should first cancel any log
apply operations in the database:
alter database recover managed standby database cancel;
Next, open the database:
alter database open;
492 Oracle Database 11g DBA Handbook
Managing Datafiles in Data Guard Environments
As noted earlier in this chapter, you should set the STANDBY_FILE_MANAGEMENT initialization
parameter to AUTO. Setting this parameter simplifies the administration of the Data Guard
environment, because files added to the primary environment can be automatically propagated
to the physical standby databases. When this parameter is set to AUTO, any new datafiles created
in the primary database are automatically created in the standby databases; when the parameter
is set to MANUAL, you must manually create the new datafiles in the standby databases.
When STANDBY_FILE_MANAGEMENT is set to MANUAL, follow these steps to add a
datafile to a tablespace:
1. Add the new datafile in the primary database.
2. Alter the datafile??™s tablespace so that it is offline.
3. Copy the datafile to the standby location.
4. Alter the datafile??™s tablespace so that it is once again online.
To add a new tablespace using manual file management, follow the same steps??”create the
tablespace, take the tablespace offline, copy its datafiles to the standby location, and then alter
the tablespace so it is online.
Pages:
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748