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