Re: auto start a data guard physical standby Oracle 11.2

From: Syed Jaffar Hussain <sjaffarhussain_at_gmail.com>
Date: Thu, 6 Jun 2013 16:25:06 +0300
Message-ID: <CAD0-Dgj9LhdxVVQ8BfriJ7oCSSpL2_v6+=nNw-a0JA6gVvwKxg_at_mail.gmail.com>



Thomas,
Very recently I have configured physical standby database for over 40 RAC databases. In fact, I have opened a SR just yesterday about the subject and I am yet to get the reply from the Oracle support. Have you thought writing a trigger (on database startup)? Will let you know if I come across of any solution/workaround on this.

Regards,

On Thu, Jun 6, 2013 at 4:12 PM, Terrian, Thomas J DLA CTR TRANSACTION SERVICES <Tom.Terrian.ctr_at_dla.mil> wrote:

> Thanks, we do not plan on using the broker. Is there any way (perhaps
> within crs) to automate putting it into recovery mode when the machine
> is bounced?
>
> -----Original Message-----
> From: Fuad Arshad [mailto:fuadar_at_yahoo.com]
> Sent: Thursday, June 06, 2013 8:56 AM
> To: Terrian, Thomas J DLA CTR TRANSACTION SERVICES
> Cc: <oracle-l_at_freelists.org>
> Subject: Re: auto start a data guard physical standby Oracle 11.2
>
> if you are using dataguard broker that should be automatic as well the
> dataguard broker control the stare if the apply process if it is enabled
>
>
> Fuad
>
>
> On Jun 6, 2013, at 7:07, "Terrian, Thomas J DLA CTR TRANSACTION
> SERVICES" <Tom.Terrian.ctr_at_dla.mil> wrote:
>
> > Does anyone know how to automatically startup an Oracle 11.2 Physical
> > Standby database when a machine gets rebooted and put it into recovery
>
> > mode?
> >
> > I guess I can add it to crs with the following:
> >
> > srvctl add database -d xxx -o /u01/app/oracle/product/11.2.0 -s MOUNT
> > -r PHYSICAL_STANDBY -n xxxx -i xxx
> >
> > I assume that crs will mount the database for me when the machine is
> > bounced. Is there any way to automatically put it into recovery mode?
> > (i.e. alter database recover managed standby database disconnect;)
> >
> > Thanks,
> > Tom Terrian
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Best Regards,

Syed Jaffar Hussain
Oracle ACE Director
<http://apex.oracle.com/pls/otn/f?p=19297:4:4640302666204919::NO:4:P4_ID:186>
Oracle Certified Master
(10g)<http://education.oracle.com/education/otn/shussain.html>
Co-author Oracle 11gR1/R2 RAC Essentials <http://link.packtpub.com/yNZicz>
*Oracle Magazine DBA of year (2011)*
OCP 8i,9i,10g & 11g DBA
RAC Certified Expert
ITIL V3 foundation certified
Oracle RAC SIG Representative for Saudi Arabian
region<http://www.oracleracsig.org>

Advisory & Governance Council for
VirtaThon<http://www.brainsurface.com/virtathon/advisorygovernancecouncil/>
I blog at  : http://jaffardba.blogspot.com/
LinkedIn : http://www.linkedin.com/in/sjaffarhussain
Follow me on twitter : http://twitter.com/#!/sjaffarhussain
--------------------
"Winners don't do different things. They do things differently."


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 06 2013 - 15:25:06 CEST

Original text of this message