Re: auto start a data guard physical standby Oracle 11.2

From: Maureen English <maureen.english_at_alaska.edu>
Date: Thu, 06 Jun 2013 09:26:55 -0800
Message-ID: <51B0C65F.1070503_at_alaska.edu>



The

alter database open read only;

requires a license for an active standby database.

We use:

startup mount;
alter database recover managed standby database using current logfile disconnect from session;

to start the database in managed recovery mode, using realtime apply.

  • Maureen

Patterson, Joel wrote:
> Do you have rc3 directories?
>
> Could you put something like this in there?
>
> Set environment
> connect / as sysdba
> -- shutdown immediate
> startup nomount
> alter database mount standby database;
> set logsource "<dir path>"
> recover standby database
> auto
> alter database open read only;
>
> Joel Patterson
> Database Administrator
> 904 928-2790
>
>
>
> --
> Joel Patterson
> Sr. Database Administrator | Enterprise Integration
> Phone: 904-928-2790 | Fax: 904-733-4916
> http://www.entint.com/
>
> http://www.entint.com/
>
> http://www.facebook.com/pages/Enterprise-Integration/212351215444231 http://twitter.com/#!/entint http://www.linkedin.com/company/18276?trk=tyah http://www.youtube.com/user/ValueofIT
>
> This message (and any associated files) is intended only for the use
> of the addressee and may contain information that is confidential,
> subject to copyright or constitutes a trade secret. If you are not the
> intended recipient, you are hereby notified that any dissemination,
> copying or distribution of this message, or files associated with this
> message, is strictly prohibited. If you have received this message in
> error, please notify us immediately by replying to the message and
> deleting it from your computer. Messages sent to and from us may be
> monitored. Any views or opinions presented are solely those of the
> author and do not necessarily represent those of the company. [v.1.1]
>
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Terrian, Thomas J DLA CTR TRANSACTION SERVICES
> Sent: Thursday, June 06, 2013 8:07 AM
> To: oracle-l_at_freelists.org
> Subject: auto start a data guard physical standby Oracle 11.2
>
> 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
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 06 2013 - 19:26:55 CEST

Original text of this message