Oracle 9i Standby database configuration

[Pradipta Chakraborty]

Hi All gurus,
This is Pradipta from kolkata,India. Can anyone help me in configuring oracle 9i standby database configuration on RHEL 4 ? Please give me the steps & procedures in detail.

[debasisdas]

Find the details of installation here.

[Vinod Sadanandan]

Hi,

I have listed few important parms below for a standby minimal configuration without a VCS\RAC ,but I have not mentioned the other basic things here (The primary and standby should be contactable from both primary and standby node )

PRIMARY DATABASE
*.db_name='orcl'

*.FAL_CLIENT='orcl'

*.FAL_SERVER='standby'

*.log_archive_dest_1='LOCATION=/orcl/oradata/orcl_arch/'

*.log_archive_dest_2='SERVICE=standby LGWR SYNC AFFIRM reopen=60'

*.log_archive_dest_state_1='enable'

*.log_archive_dest_state_2='enable'

*.log_archive_format='orcl_%s.arc'
*.log_archive_start=TRUE
*.standby_archive_dest='oracle/oradata/orcl_standby_archive'
*.standby_file_management='AUTO'
-create standby redo logs
-create a passowrd file for log apply services

STANDBY DATABASE

*.db_name='orcl'

*.FAL_CLIENT='standby'

*.FAL_SERVER='orcl'

*.log_archive_dest_1='LOCATION=/oracle/oradata/standby_arch/'

*.log_archive_dest_2='SERVICE=orcl LGWR SYNC AFFIRM reopen=60'

*.log_archive_dest_state_1='enable'

*.log_archive_dest_state_2='TRUE'

*.log_archive_format='orcl_%s.arc'

*.log_archive_start=TRUE
*.log_file_name_convert 'primarylocation','standbylocation'
*.db_file_name_convert='primarydatafilelocaion','s tandbydatafilelocaion'


Thanks & Regards,
Vinod Sadanandan
Oracle DBA