Configuring HP Serviceguard Toolkit for Oracle Data Guard

24
b. Configure listeners for the primary and standby databases. On both the primary and standby
sites, use Oracle Net Manager to configure a listener for the respective databases.
To restart the listeners (to pick up the new definitions), enter the following LSNRCTL utility
commands on both the primary and standby systems:
% lsnrctl stop
% lsnrctl start
Ensure that the tnsnames.ora of a node contains the entries of all those nodes that it wants to
communicate with.
c. Enable broken-connection detection on the standby system.
Enable broken-connection detection by setting theSQLNET.EXPIRE_TIME parameter to two
minutes in the SQLNET.ORA parameter file on the standby system. For example:
SQLNET.EXPIRE_TIME=2
d. Create Oracle Net service names.
On both the primary and standby systems, use Oracle Net Manager to create a network
service name for the primary and standby databases that will be used by log transport
services.
The Oracle Net service name must resolve to a connect descriptor that uses the same protocol,
host address, port, and SID that you specified when you configured the listeners for the primary
and standby databases. The connect descriptor must also specify that a dedicated server be
used.
e. Create a server parameter file for the standby database.
On an idle standby database, use the SQL CREATE statement to create a server parameter file
for the standby database from the text initialization parameter file
SQL> CREATE SPFILE FROM PFILE=“initstandby.ora”;
6. Start the physical standby database:
Perform the following steps to start the physical standby database and Redo Apply.
a. Start the physical standby database.
On the standby database, issue the following SQL statements to start and mount the database
in read-only mode:
SQL> STARTUP OPEN READ ONLY;
b. Create a new temporary file for the physical standby database.
Creating a new temporary file on the physical standby database at this point rather than later
is beneficial. Temporary files enable disk sorting when the database is open in read-only mode
and prepare the database for future role transitions.
To add temporary files to the physical standby database, perform the following tasks:
1. Identify the table spaces that should contain temporary files. Do this by entering the
following command on the standby database:
SQL> SELECT TABLESPACE_NAME FROM DBA_TABLESPACES
2> WHERE CONTENTS = “TEMPORARY”;
TABLESPACE_NAME
--------------------------------
TEMP1
TEMP2
Add new temporary files to the standby database.