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='o rcl'

*.FAL_SERVER='s tandby'

*.log_archive_d est_1='LOCATION =/orcl/oradata/orcl_arch/'

*.log_archive_d est_2='SERVICE= standby LGWR SYNC AFFIRM reopen=60'

*.log_archive_d est_state_1='en able'

*.log_archive_d est_state_2='en able'

*.log_archive_f ormat='orcl_%s. arc'
*.log_archive_s tart=TRUE
*.standby_archi ve_dest='oracle/oradata/orcl_standby_ar chive'
*.standby_file_ management='AUT O'
-create standby redo logs
-create a passowrd file for log apply services

STANDBY DATABASE

*.db_name='orcl '

*.FAL_CLIENT='s tandby'

*.FAL_SERVER='o rcl'

*.log_archive_d est_1='LOCATION =/oracle/oradata/standby_arch/'

*.log_archive_d est_2='SERVICE= orcl LGWR SYNC AFFIRM reopen=60'

*.log_archive_d est_state_1='en able'

*.log_archive_d est_state_2='TR UE'

*.log_archive_f ormat='orcl_%s. arc'

*.log_archive_s tart=TRUE
*.log_file_name _convert 'primarylocatio n','standbyloca tion'
*.db_file_name_ convert='primar ydatafilelocaio n','standbydata filelocaion'


Thanks & Regards,
Vinod Sadanandan
Oracle DBA