Re: auto start a data guard physical standby Oracle 11.2
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-lReceived on Thu Jun 06 2013 - 15:25:06 CEST