failover comand on daagurad

[NIckman]

Hi
we use oracle 9.2 ver
i have 2 databases. one is primary DB at one site and 2nd is secondary DB at site2. we use datagurad.
What are commands i need to perform when primary DB is crash to failover to
Secondary DB.
both DB are MAx protect mode.

pl let me know.

i thought this is procedure, pl let me know if i am wrong.
primary is failed.
log on to secondary unix sever.
after logon

DGMGRL> failover to 'secondary DB name' GRACEFULL

do i need to use this option GRACEFULL/FORCE
OR
just

DGMGRL> failvoer to 'secondary DB name'
if this command is success.

do i need to perform any commands. I mean "startup mount"

pl let me know how to perfrom failover procedure with commands.
I thought if you have dataguard , it will be simple as
type the above command only.

thanks,N.

[hrishy]

Hi

This command will not work

DGMGRL> failover to 'secondary DB name'

You must include graceful or forced keyword explicitly.

If you are okay with the data loss then forced is the keyword you should be using.
Since your site is using maxmimum protection mode you have no choice but to use

DGMGRL> failover to 'secondary DB name' graceful

Please test this throughly in your environment as my experiences with 9i datagaurd is hmm you know slightly different from what is documented :-).

regards
Hrishy

[NIckman]

thanks hrishy.

i got it. do i need to enter any other commands other than just you told single failover command to complete failover procedure. pl let me know. Thanks,N.

[hrishy]

Hi

When the above command returns you should use

show configuration
show site
show resource

commands to check if the failover operation is successful.

You should also see that the tnsnames now point to the new primary database (change in DNS etc ) and your application can connect to the new primary database.

Try and recreate the original primary and configure it as a standby etc..

regards
Hrishy

[NIckman]

Thanks once again.
can you tell me where to get procedure with commands to get recreate the original primary and configure it as a standby. pl help.thansk,N.

[hrishy]

Hi

Recreating the original primary as standby is same as creating a brand new standby from primary in 9.2

regards
Hrishy

[NIckman]

Hirshy

when failover occurs on primary DB,
you will connected to seconday standby server
issue this these 4 commands down bellow will complete whole failover procedure.
both DB is in max protection mode

DGMGRL> failover to 'secondary DB name' graceful
show configuration
show site
show resource

and change tns names only to secondary server.

i am seeing on various manules,
you need to change first to max perforamce mode and need to verify logs also and copy logs to stand by and need to restart DB and mount the data bases. do we need to do all these things or data gurad will take everyting.

thx.N.