MIME-Version: 1.0
In-Reply-To: <96FC82DA2FD4354D9A8B8434B6E7003D209E5B2E@COL0SGEM20.AD.DLA.MIL>
References: <96FC82DA2FD4354D9A8B8434B6E7003D209E59C9@COL0SGEM20.AD.DLA.MIL>
 <EB65599E-80CC-4221-B264-684AB89A496C@yahoo.com>
 <96FC82DA2FD4354D9A8B8434B6E7003D209E5B2E@COL0SGEM20.AD.DLA.MIL>
Date: Thu, 6 Jun 2013 16:25:06 +0300
Message-ID: <CAD0-Dgj9LhdxVVQ8BfriJ7oCSSpL2_v6+=nNw-a0JA6gVvwKxg@mail.gmail.com>
Subject: Re: auto start a data guard physical standby Oracle 11.2
From: Syed Jaffar Hussain <sjaffarhussain@gmail.com>
To: "Tom.Terrian.ctr@dla.mil" <Tom.Terrian.ctr@dla.mil>
Cc: Fuad Arshad <fuadar@yahoo.com>, Oracle-L Freelists <oracle-l@freelists.org>
Content-type: text/plain
Content-Transfer-Encoding: 8bit
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: sjaffarhussain@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@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@yahoo.com]
> Sent: Thursday, June 06, 2013 8:56 AM
> To: Terrian, Thomas J DLA CTR TRANSACTION SERVICES
> Cc: <oracle-l@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@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