Alternatively, use an RMAN backup of the primary database to create the standby database files.
Step 5: Configure the Standby Database Environment
At this point, the files are in place. You need to create the proper environment variables and
services to allow an instance to access the files. For example, in a Windows environment you
should use the oradim utility to create a new service, as shown in this example:
ORADIM ??“NEW ??“SID salesofc ??“INTPWD oracle ??“STARTMODE manual
Next, create a password file for the standby database via the ORAPWD utility (see Chapter 2
for details on creating a new password file).
Next, create the Oracle Net parameters and services needed to access the standby database.
In the standby environment, create an Oracle Net listener service for the standby database. In the
standby server??™s sqlnet.ora file, set the SQLNET.EXPIRE_TIME parameter to 1 to activate brokenconnection
detection after one minute. See Chapter 15 for further details on Oracle Net connections.
Next, create a service name entry for the standby database in the tnsnames.ora file and then
distribute that update to both the standby and primary database servers.
If the primary database has an encryption wallet, copy the wallet to the standby database
system and configure the standby database to use this wallet; the wallet must be re-copied from
the primary to all standby databases whenever the master encryption key is updated.
Pages:
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733