Data Guard Installation (Step 4)

PART 4
Step 8:
Convert the control file created from step 6 to the name and location
of control file parameter in the new standby init.ora.
C:\oracle\product\10.2.0\oradata\teststby\teststby.ctl
to
C:\oracle\product\10.2.0\oradata\teststby\control01.ctl
Step 9:
Configure the Listener.ora file. Since the example is on the same node I
have both the standby and primary in the listener.ora. If this was a production
environment you would create the listener for primary and standby separate.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = RLLAPTOP01)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = C:\oracle\product\10.2.0)
(SID_NAME = test)
)
(SID_DESC =
(GLOBAL_DBNAME = teststby)
(ORACLE_HOME = C:\oracle\product\10.2.0)
(SID_NAME = teststby)
)
(SID_DESC =
(GLOBAL_DBNAME = teststby_DGMGRL)
(ORACLE_HOME = C:\oracle\product\10.2.0)
(SID_NAME = teststby)
)
(SID_DESC =
(GLOBAL_DBNAME = test_DGMGRL)
(ORACLE_HOME = C:\oracle\product\10.2.0)
(SID_NAME = test)
)
)
Note: The DGMGRL entries are for the Data Guard Broker to be able
to start and stop the databases on switchovers.

Data Guard Installation (Step 3)

PART 3
Standby Database:

Create a standby init.ora from a copy of the primary one and make
the necessary changes below.

background_dump_dest=’C:\oracle\product\10.2.0/admin/
teststby/bdump’
*.control_files=’C:\oracle\product\10.2.0/oradata/teststby/
\control01.ctl’
*.core_dump_dest=’C:\oracle\product\10.2.0/admin/teststby
cdump’
*.db_name=’test’
*.DB_UNIQUE_NAME=’teststby’
*.instance_name=’teststby’
*.LOG_ARCHIVE_DEST_1=’location=C:\oracle\archive2 arch
mandatory
valid_for=(ONLINE_LOGFILES,ALL_ROLES)
db_unique_name=teststby’
*.LOG_ARCHIVE_DEST_2=’service=test lgwr sync affirm
net_timeout=30
valid_for=(ONLINE_LOGFILES,ALL_ROLES)
db_unique_name=test’
*.log_archive_dest_state_1=’ENABLE’
*.log_archive_dest_state_2=’ENABLE’
*.user_dump_dest=’C:\oracle\product\10.2.0/admin/
teststby/udump’
*.standby_archive_dest=’location=c:\oracle\product\
10.2.0\archive’
*.db_file_name_convert=’C:\oracle\product\10.2.0\
oradata\test’,
‘C:\oracle\product\10.2.0\oradata\teststby’
*.log_file_name_convert=’C:\oracle\product\10.2.0\
oradata\test’,
‘C:\oracle\product\10.2.0\oradata\teststby’
*.standby_file_management=AUTO
*.log_archive_config=’DG_CONFIG=(test,teststby)’
*.service_names=teststby
*.fal_server=test
*.fal_client=teststby