Home » Server Options » Data Guard » dataguard on 10g
dataguard on 10g [message #213603] Thu, 11 January 2007 07:23 Go to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
hello
i was trying to setup dataguard on oracle 10g win xp, after creating the standby database step by step using the documentation, i noticed that when i archive or switch logs on the primary site, the logs are not transfered to the standby site,
then after reading again the parameters in the documentation of the standby site i found that the location where the received logs from the primary site is not defined,
is that the problem or did i miss something...

documenation: OracleŽ Data Guard
Concepts and Administration
10g Release 1 (10.1)
Part No. B10823-01

thanks
Re: dataguard on 10g [message #213792 is a reply to message #213603] Fri, 12 January 2007 05:42 Go to previous message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
make sure u have tnsnames set up.

Following are parameters i pulled from metalink

Sandeep

Initialization parameters (PRIMARY)
==========================
*.control_files='/u02/admin/v10g/datafiles/control01.ctl'
*.log_archive_config='DG_CONFIG=(v10g_stdg2,v10g_stdg1)'
*.log_archive_dest_1='LOCATION=/u02/admin/v10g/v10garch/
VALID_FOR=(ALL_LOGFILES,ALL_ROLES) *.db_unique_name=v10g_stdg2'
*.log_archive_dest_2='SERVICE=v10g_stdg1
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=v10g_stdg1 LGWR ASYNC REOPEN=10'

*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'
*.db_unique_name='v10g_stdg2'

*.FAL_CLIENT='v10g_stdg2'
*.FAL_SERVER='v10g_stdg1'

*.standby_archive_dest='/u02/admin/v10g/v10garch'
*.standby_file_management='auto'
*.remote_login_passwordfile='EXCLUSIVE'

Initialization parameter(STANDBY)
==================================
*.control_files='/u02/admin/v10g/datafiles/standby.ctl'
*.log_archive_config='DG_CONFIG=(v10g_stdg2,v10g_stdg1)'
*.log_archive_dest_1='LOCATION=/u02/admin/v10g/v10garch/
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
*.db_unique_name=v10g_stdg1'
*.log_archive_dest_2='SERVICE=v10g_stdg2
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=v10g_stdg2 LGWR ASYNC REOPEN=10'

*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'
*.db_unique_name='v10g_stdg1'

*.FAL_CLIENT='v10g_stdg1'
*.FAL_SERVER='v10g_stdg2'

*.standby_archive_dest='/u02/admin/v10g/v10garch'
*.standby_file_management='auto'
*.remote_login_passwordfile='EXCLUSIVE'
Previous Topic: Physical Standby database ORA-01031: insufficient privileges
Next Topic: dataguard parameter
Goto Forum:
  


Current Time: Thu Mar 28 05:56:58 CDT 2024