Topic: Database Administration >> Dataguard issue -URGENT???????????
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Dataguard issue -URGENT??????????? |
| kiran |
Posted: Jul 23, 2007 03:06:35 AM |
Total Post: 1
Joined: Feb, 2006
|
Dear all,
please help me in solving the problem of the dataguard, the problem i am facing is when ever a archive log is created it is first applied in standby system and next it is applied to PRIMARY system and if the STANDBY connection is lost the primary hangs.
If i put the value of log_archive_dest_2 as 'SERVICE=STANDBY OPTIONAL ARCH ASYNC NOAFFIRM REGISTER' then i am getting an error ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes.
can any one help me out of this problem.
The parameters i have used for primary and standby are given below.
#######################################################
## ADDED PARAMETERS FOR DATAGUARD on PRIMARY
#######################################################
dg_broker_start=true
standby_file_management='AUTO'
log_archive_dest_state_1=ENABLE
log_archive_dest_state_2=ENABLE
log_archive_dest_1='LOCATION=/oracle/C30/saparch/C30arch MANDATORY'
log_archive_dest_2='SERVICE=STANDBY ARCH NOAFFIRM'
remote_archive_enable=true
standby_archive_dest='/oracle/C30/saparch/C30arch'
fal_server='SERVICE=STANDBY'
fal_client='SERVICE=PRIMARY'
########################################################
##################################################################
## ADDED PARAMETERS FOR DATAGUARD ON STANDBY
##################################################################
dg_broker_start=true
standby_file_management='AUTO'
log_archive_dest_state_2='defer'
log_archive_dest_1='LOCATION=/oracle/C30/saparch/C30arch'
#log_archive_dest_2='SERVICE=PRIMARY OPTIONAL ARCH ASYNC NOAFFIRM REGISTER'
standby_archive_dest='/oracle/C30/saparch/C30arch'
fal_client='SERVICE=STANDBY'
fal_server='SERVICE=PRIMARY'
#####################################################
Please help me out!!!!!!!!!!! |
|
|
 DreamzZ |
| Posted: Jul 23, 2007 03:04:15 PM |  |
|
Total Post: 23
Joined: Jul, 2007
|
when ever a archive log is created it is first applied in standby system and next it is applied to PRIMARY system and if the STANDBY connection is lost the primary hangs.
How??
although dataguard first perform activity on PRimary.
check this
http://www.scribd.com/doc/138958/DATAGUARD-CONFIGURATION
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 239 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
