Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id CCD121960623 for ; Thu, 6 Jun 2013 15:14:25 +0200 (CEST) Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTP for ; Thu, 6 Jun 2013 15:14:25 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 04E6B22192; Thu, 6 Jun 2013 09:01:16 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id UZoGwMlnDY9z; Thu, 6 Jun 2013 09:01:15 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C9FEA2212A; Thu, 6 Jun 2013 09:00:34 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 06 Jun 2013 08:59:53 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 06B882204E for ; Thu, 6 Jun 2013 08:59:53 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id CUzxSAox-4Pg for ; Thu, 6 Jun 2013 08:59:52 -0400 (EDT) Received: from SMTP2.dscc.dla.mil (smtp2.dscc.dla.mil [214.3.139.5]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B66C022041 for ; Thu, 6 Jun 2013 08:59:52 -0400 (EDT) Received: from dla.mil [131.74.111.219] by SMTP2.dscc.dla.mil - Websense Email Security (7.3.0); Thu, 06 Jun 2013 09:08:44 -0400 Received: from COL0SGEM20.AD.DLA.MIL ([131.74.111.222]) by col0sgem19.AD.DLA.MIL with Microsoft SMTPSVC(6.0.3790.4675); Thu, 6 Jun 2013 09:12:59 -0400 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-MimeOLE: Produced By Microsoft Exchange V6.5 Subject: RE: auto start a data guard physical standby Oracle 11.2 Date: Thu, 6 Jun 2013 09:12:58 -0400 Message-ID: <96FC82DA2FD4354D9A8B8434B6E7003D209E5B2E@COL0SGEM20.AD.DLA.MIL> In-Reply-To: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: auto start a data guard physical standby Oracle 11.2 References: <96FC82DA2FD4354D9A8B8434B6E7003D209E59C9@COL0SGEM20.AD.DLA.MIL> From: "Terrian, Thomas J DLA CTR TRANSACTION SERVICES" To: "Fuad Arshad" Cc: X-OriginalArrivalTime: 06 Jun 2013 13:12:59.0224 (UTC) FILETIME=[910A6D80:01CE62B7] X-SEF-7853D99-ADF1-478E-8894-213D316B8FFA: 1 X-SEF-Processed: 7_3_0_01192__2013_06_06_09_08_45 X-archive-position: 49194 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Tom.Terrian.ctr@dla.mil Precedence: normal Reply-To: Tom.Terrian.ctr@dla.mil List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l 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: 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" 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