Re: Data Guard implementation : Question about role transition
- From: Asif Momen <asif_oracle@xxxxxxxxx>
- To: RichardGoulet <Richard.Goulet@xxxxxxxxxxx>, ksmadduri@xxxxxxxxx
- Date: Fri, 12 Jun 2009 23:55:34 -0700 (PDT)
Hi Kumar,
I assume you are on Oracle 10g.
1) If you are using Data Guard Broker, then disable the configuration .
2) Disable log shipping on the primary.
3) Test your standby database using/simulating Snapshot Standby Database.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/scenarios.htm#CIHIABDH
I have used the above procedure many times during DR testing. Should you need
more information, drop a mail.
Regards
Asif Momen
http://momendba.blogspot.com
--- On Fri, 6/12/09, Kumar Madduri <ksmadduri@xxxxxxxxx> wrote:
From: Kumar Madduri <ksmadduri@xxxxxxxxx>
Subject: Re: Data Guard implementation : Question about role transition
To: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
Cc: Oracle-L@xxxxxxxxxxxxx
Date: Friday, June 12, 2009, 12:38 PM
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.
- Kumar
On Fri, Jun 12, 2009 at 12:00 PM, Goulet, Richard<Richard.Goulet@xxxxxxxxxxx>
wrote:
> Kumar,
>
> 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@xxxxxxxxx]
> 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@xxxxxxxxxxx> wrote:
>> Kumar,
>>
>> 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@xxxxxxxxxxxxx
>> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kumar Madduri
>> Sent: Friday, June 12, 2009 11:11 AM
>> To: Oracle-L@xxxxxxxxxxxxx
>> Subject: Data Guard implementation : Question about role transition
>>
>> Hi
>> 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
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>>
>
Other related posts:
