Home » Server Options » Data Guard » DGMGRL setting
icon9.gif  DGMGRL setting [message #207165] Mon, 04 December 2006 06:35 Go to next message
200112262
Messages: 4
Registered: December 2006
Junior Member
hi all,

iam new in data guarding in 10G R2 i read oracle book about broker and configuration but whole configuration fail
i have to windows server to copy of oracle and i install
to database
primary :
GLOBAL NAME: DGPRIM
SID : DGPRIM

standby :

GLOBAL NAME: DGSTAND
SID : DGSTAND

both initial parameter set as below
primary :
dg_broker_start=true
standby_management = auto
remote_archive_enable=false (when i set it true it make a crash as well as log_archive_start)
log_archive_dest_1= location=c:\temp\archivce(server1)
i did not configure the dest_2 coz it not mintion in the book
standby:
dg_broker_start=true
standby_management = auto
remote_archive_enable=false (when i set it true it make a crash as well as log_archive_start)
log_archive_dest_1= location=c:\temp\archivce (server2)
standby_archive_destination=c:\temp\archivce (server2)
also i did not configure the dest_2 coz it not mention in the book

i restart the both database then i run the dgmgrl in the primary
and both of them in open
and i configure the lsnr and it work prop.
and i add the services in both
dgmgrl>
1- create the configuration
2- add the standby database
maxpefromence
since i enable the configuration
i have this error
ora16009 remote arhive log destination must be standby database

sorry i wrote alote but just to make sure what i did is right
or i have to do some thing which is not in the book
and pllllz i need a hand coz realy i lost and i have to submit after 1 week
plz a some details and thanx in advance
icon9.gif  Re: DGMGRL setting [message #207267 is a reply to message #207165] Mon, 04 December 2006 22:01 Go to previous messageGo to next message
200112262
Messages: 4
Registered: December 2006
Junior Member
plllllllllllz i neeed a help urrrgent
Re: DGMGRL setting [message #207419 is a reply to message #207165] Tue, 05 December 2006 08:14 Go to previous messageGo to next message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
whats fal_server and fal_client set to in primary and standby?

Try to set them to proper value.
Sandeep
Re: DGMGRL setting [message #207448 is a reply to message #207419] Tue, 05 December 2006 11:10 Go to previous messageGo to next message
200112262
Messages: 4
Registered: December 2006
Junior Member
primary
fal_client : primary_sid
fal_server : standby_sid

standby
fal_client : standby_sid
fal_server : primary_sid



what do u thing
Re: DGMGRL setting [message #207466 is a reply to message #207165] Tue, 05 December 2006 12:09 Go to previous messageGo to next message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
looks good.

Please verify tnsping works on primary_sid and standby_sid values.

Also, have you created standby database in normal way? Shutdown primary..copy files and then create standby controlfile and then mount standby?

Sandeep
Re: DGMGRL setting [message #207522 is a reply to message #207466] Tue, 05 December 2006 21:45 Go to previous messageGo to next message
200112262
Messages: 4
Registered: December 2006
Junior Member
thank very much for replay
should be standby database in mount mode
should i copy the datafile from primary to standby or its optional coz i did i copy all data file and redo file except the
temp datafile to standby i started up i have an error

i will do what did u say
thax in advance
Re: DGMGRL setting [message #207692 is a reply to message #207165] Wed, 06 December 2006 11:39 Go to previous messageGo to next message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
please read 10g data guard manual to get step by step install instructions for data guard.

Sandeep
Re: DGMGRL setting [message #207714 is a reply to message #207692] Wed, 06 December 2006 13:33 Go to previous message
ualual
Messages: 22
Registered: May 2005
Junior Member
Agree with Sandeep,

You need to hit the manual again.
http://oracleheva1.oracle.com/docs/cd/B19306_01/server.102/b14239/concepts.htm

What are you try to create?

physical standby
http://oracleheva1.oracle.com/docs/cd/B19306_01/server.102/b14239/create_ps.htm

or

logical
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14239/create_ls.htm#g105412


Previous Topic: Roll Forward & Missing Archive logs
Next Topic: which to startup first
Goto Forum:
  


Current Time: Sun Dec 04 13:04:09 CST 2016

Total time taken to generate the page: 0.08665 seconds