If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Dataguard failover - what went wrong here??

I have the below DG configuration replicating to a physical standby in a Maximum performance mode (using LGWR as the Xptmode).

I had to perform/simulate a failover to the standby in this case. So I "DEFER"ed the appropriate log_archive_dest_state_n on the primary (I didn't disable the DG configuration)..and then went about activating the standby database. Here's a cut n paste of what I did..in exact sequence (the commands were typed one after the other rapidly). Why in the world did the SWITCHOVER (failover rather) throw errors the first 2 times..and then work in the end? Yes, it's on windows..

---->>>>> WHAT?? WHY IS IT BEING MODIFIED?!! I DEFER'ED the log_arch_dest_state on the primary..SHOULDN'T THAT TAKE CARE OF THIS? NOTE : THE "ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;" was successful. YET, IT THROWS THIS ERROR!

Do you need to do log switches on the primary and or force the secondary to sync up before making the secondary database active? Also, do you need to change the control file before you activate the server.

Originally posted by gandolf989 Do you need to do log switches on the primary and or force the secondary to sync up before making the secondary database active? Also, do you need to change the control file before you activate the server.

fyi, It has been awhile since I have mucked with standby servers.

If the logXptMode were ARCH (max availability mode), yes you would need to switch archivelogs..and everything in online redologs is history.

As for controlfile stuff..it is taken care of when you activate the standby.

In my case, the failover worked -- it eventually did what I asked it to (i blew my online redologs..but thats okay by me). But I don't get why it complained the first couple of times..and worked the 3rd time.

PS : I've performed real failovers / switchovers many times in past..never faced this before.

i have data guard configured in maximum protection mode and arch and
no standby logfiles, for
failover what should i follow
1) alter database recover managed standby database skip standby log files;
or
alter database recover managed standby finish skip standby log file;
if i follow option a) do i need to do option b) as well ?

i have data guard configured in maximum protection mode and arch and
no standby logfiles, for
failover what should i follow
1) alter database recover managed standby database skip standby log files;
or
alter database recover managed standby finish skip standby log file;
if i follow option a) do i need to do option b) as well ?