Lastly, create a server parameter file via the create spfile from pfile command, passing the
name and location of the standby parameter file as input to that command.
Step 6: Start the Standby Database
From within SQL*Plus, start the standby database in mount mode, as shown in the following
example:
startup mount;
NOTE
You can add new temporary files to the temporary tablespaces in
the standby database. Adding temporary files will support sorting
operations required for reporting activity within the standby database.
Although optional, Oracle recommends that you create an online redo log on each standby
database to reduce the amount of time it will take to transition the standby database to the
primary role.
Start the redo application process within the standby database via the following alter database
command:
alter database recover managed standby database
using current logfile disconnect from session;
Step 7: Verify the Configuration
To test the configuration, go to the primary database and force a log switch to occur via the alter
system command, as shown here:
alter system switch logfile;
484 Oracle Database 11g DBA Handbook
The primary database??™s redo log data should then be copied to the standby location.
On the standby database, you can query the V$ARCHIVED_LOG view or use the archive
log list command to see which archived logs have been applied to the database. As new logs are
received from the primary database and applied to the standby, new rows will be added to the
listing in V$ARCHIVED_LOG.
Pages:
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734