RE: Data Guard implementation : Question about role transition

From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Date: Fri, 12 Jun 2009 15:00:11 -0400
Message-ID: <23C4836D8E9C5F4280A66C0C247BC16F299E44A7_at_US-BOS-MX011.na.pxl.int>



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_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:
> 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_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
>
> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 12 2009 - 14:00:11 CDT

Original text of this message