auto start a data guard physical standby Oracle 11.2

From: Terrian, Thomas J DLA CTR TRANSACTION SERVICES <Tom.Terrian.ctr_at_dla.mil>
Date: Thu, 6 Jun 2013 08:07:12 -0400
Message-ID: <96FC82DA2FD4354D9A8B8434B6E7003D209E59C9_at_COL0SGEM20.AD.DLA.MIL>

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

Received on Thu Jun 06 2013 - 14:07:12 CEST