RE: standby reinstate failed: other options

>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

--
http://www.freelists.org/webpage/oracle-l

Attachment: pic14129.jpg
Description: JPEG image

Other related posts: