| dataguard on 10g [message #213603] |
Thu, 11 January 2007 07:23  |
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  |
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'
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
