>Now if you did a "failover" and not a switchover, sometimes a reinstate
will work depending on how far back, etc it is.
it worked for me may be 4 times out of 5 (this is per database) in pre and
post-production.
Actually, it worked the fifth time too after I quickly re-learned the old
good habbit to copy redo logs aside before messing with db.
btw, how is that accomplishable in ASM?
---------------------------------------------------------------------------------
Please consider the environment before printing this e-mail
From: TESTAJ3@xxxxxxxxxxxxxx
To: Richard.Goulet@xxxxxxxxxxx
Cc: "Laimutis.Nedzinskas@xxxxxx" <Laimutis.Nedzinskas@xxxxxx>,
"oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>,
oracle-l-bounce@xxxxxxxxxxxxx
Date: 2011.08.29 16:49
Subject: RE: standby reinstate failed: other options,
Sorry I didn't see the original thread on this one.
I've messed with DG broker probably more than I ever wanted to. Even when
oracle says to "rebuild standby" its not necessarily true, i've gotten
around it multiple times between, bouncing standby, disable, re-enable
configuration, manually catching up logs.
Now if you did a "failover" and not a switchover, sometimes a reinstate
will work depending on how far back, etc it is.
joe
(Embedded image moved to file: pic14129.jpg)
From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
To: "Laimutis.Nedzinskas@xxxxxx" <Laimutis.Nedzinskas@xxxxxx>,
"oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: 08/29/2011 09:31 AM
Subje RE: standby reinstate failed: other options
ct:
Sent oracle-l-bounce@xxxxxxxxxxxxx
by:
You're going to have to rebuild the standby from the primary. Which leads
to the other side that having a system that fires on its own is normally
not a good thing. Call me old fashion if you like, but I prefer to fail
over my standby manually just because of this.
Richard Goulet
Senior Oracle DBA/Na Team Leader
--
//www.freelists.org/webpage/oracle-l
Attachment:
pic14129.jpg
Description: JPEG image
