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 8B4A919605B3 for ; Thu, 6 Jun 2013 14:08:38 +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 14:08:38 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D809522110; Thu, 6 Jun 2013 07:55:28 -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 KOwsrLfry+xg; Thu, 6 Jun 2013 07:55:28 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 931E7220A9; Thu, 6 Jun 2013 07:54:47 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 06 Jun 2013 07:54:06 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7B28120E39 for ; Thu, 6 Jun 2013 07:54:06 -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 15-CYiRw-bZB for ; Thu, 6 Jun 2013 07:54:06 -0400 (EDT) Received: from SMTP1.dscc.dla.mil (smtp1.dscc.dla.mil [214.3.139.10]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 07A5A2204F for ; Thu, 6 Jun 2013 07:54:05 -0400 (EDT) Received: from Unknown [131.74.111.229] by SMTP1.dscc.dla.mil - Websense Email Security (7.3.0); Thu, 06 Jun 2013 08:02:28 -0400 Received: from COL0SGEM20.AD.DLA.MIL ([131.74.111.222]) by col0sgem29.AD.DLA.MIL with Microsoft SMTPSVC(6.0.3790.4675); Thu, 6 Jun 2013 08:07:12 -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: auto start a data guard physical standby Oracle 11.2 Date: Thu, 6 Jun 2013 08:07:12 -0400 Message-ID: <96FC82DA2FD4354D9A8B8434B6E7003D209E59C9@COL0SGEM20.AD.DLA.MIL> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: auto start a data guard physical standby Oracle 11.2 From: "Terrian, Thomas J DLA CTR TRANSACTION SERVICES" To: X-OriginalArrivalTime: 06 Jun 2013 12:07:12.0960 (UTC) FILETIME=[60E25400:01CE62AE] X-SEF-7853D99-ADF1-478E-8894-213D316B8FFA: 1 X-SEF-Processed: 7_3_0_01192__2013_06_06_08_02_28 X-archive-position: 49192 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 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