Dataguard failover - what went wrong here??

[hrishy]

pando
hahaha :-) sorry i couldnt stop laughing out loud..these kind of questions deserve those answers :-D

regards
Hrishy

[hafeezkalsekar]

hi hirshy ,
there i nothing to laugh in it
i have maximum performance mode so i dont need standby logfile;
i was confused whether to use ....finish skip standby logfile or just recover ... skip standby logfile before giving switchover command,'
as some document recomends 1) alter database recover managed standby finish skip standby log file;
and some recomends 2) alter database recover managed standby database skip standby logfile;

[hrishy]

Hi

Okay i have stopped laughing...but my 2 cents you should always have a standby logfile even when you are having maximum performance mode.

regards
Hrishy

[hafeezkalsekar]

in maximum performance mode its not necessary to have standby redo logs.
anyways if any has done failover himself plz comment..

[hrishy]

Hi

You need to do this as you dont have standby redologs

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH

and then failover using

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY

http://download-east.oracle.com/docs...nt.htm#1024703

regards
Hrishy

[hafeezkalsekar]

sorry hirshy
but as far as i know if u dont have standby redo logs,
u have to fire "alter database recover managed standby database finish skip standby logfile"

[hrishy]

Hi

I was wrong you indeed need to do

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH
SKIP STANDBY LOGFILE

regards
Hrishy