Re: Data Guard implementation : Question about role transition
Date: Fri, 12 Jun 2009 12:38:48 -0700
Thank you Richard.
As an extension to this, what I plan to do is, shutdown the standby, take an rman backup (before activating the standby). Do my testing. Then instead of rebuilding the standby, restore the backup taken prior to breaking the standby and continue recovery. I am hopoing this would work.
On Fri, Jun 12, 2009 at 12:00 PM, Goulet, Richard<Richard.Goulet_at_parexel.com>
> Well I've never tried that, yet. But I would assume that the4
following would have to be done to simulate a failure of the primary database:
> 1) If you have the data broker observer running kill it.
> 2) On the primary disable the log_archive destinations that are
feeding the standby.
> 3) On the primary remove the TNSNAMES.ORA entries for the standby
(commenting them out should be sufficient).
> 4) On the standby move the TNSNAMES.ORA file aside, either rename
it or move it to another directory so the two cannot communicate with each other.
> 5) Follow the steps on the standby for a failover.
> Dick Goulet
> Senior Oracle DBA
> PAREXEL International
> -----Original Message-----
> From: Kumar Madduri [mailto:ksmadduri_at_gmail.com]
> Sent: Friday, June 12, 2009 1:07 PM
> To: Goulet, Richard
> Subject: Re: Data Guard implementation : Question about role transition
> Hi Richard
> I want to open the standby in read-write mode because this is going to
> be used by Oracle Apps. This would be the scenario in a 'real' DR case
> as well. I am trying to see if I can simulate and document this.
> Thank you
> - Kumar
> On Fri, Jun 12, 2009 at 9:51 AM, Goulet,
> Richard<Richard.Goulet_at_parexel.com> wrote:
>> What exactly are you trying to out? That the data made it to
>> the standby site? If so, stop the managed recovery and open the
>> database read only. Afterwards you can resume standby operations
>> without having to rebuild the database. But note that on a real
>> failover or switchover you can't just open the standby database, but
>> have to shutdown first.
>> Dick Goulet
>> Senior Oracle DBA
>> PAREXEL International
>> -----Original Message-----
>> From: oracle-l-bounce_at_freelists.org
>> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kumar Madduri
>> Sent: Friday, June 12, 2009 11:11 AM
>> To: Oracle-L_at_freelists.org
>> Subject: Data Guard implementation : Question about role transition
>> Chapter 7 of the data guard implementation guide describes about role
>> transitions. There are two scenarios which are described here (a)
>> failvoer (b) switchover.
>> What if I really dont want to do both of them. I want to test my
>> standby by breaking it, but dont want to make it primary.
>> My standby is in a remote location and I just want to set it up, break
>> the standby (when the primary is up) and see if I can make it work.
>> Once this works, the idea is to rebuild the standby and it would be in
>> managed recovery state
>> The standby is in a DR site which ideally I want to failover during an
>> actual DR but I want to test my standby setup (on whether I can break
>> it etc) before the acctual DR and document the procedure.
>> When I tried to keep primary up and try to break the standby , it
>> would not allow me even though I disable the log_archive_Dest_2.
>> Thank you for any pointers
>> - Kumar