-
pando
hahaha :-) sorry i couldnt stop laughing out loud..these kind of questions deserve those answers :-D
regards
Hrishy
-
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;
-
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
-
in maximum performance mode its not necessary to have standby redo logs.
anyways if any has done failover himself plz comment..
-
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
-
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"
-
Hi
I was wrong you indeed need to do
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH
SKIP STANDBY LOGFILE
regards
Hrishy
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|