Re: Oracle GI Restart (ohasd) starting Physical Standby

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 15 Aug 2019 12:23:14 -0500
Message-Id: <DD13A2F1-50F4-4C56-966B-63FD9E30F9E4_at_gmail.com>



I don’t think oracle restart can be configured to start managed recovery. But if you set up data guard broker, it will start the process once the standby is mounted.

Sent from my iPad

> On Aug 15, 2019, at 12:13, Lyall Barbour <lyallbarbour_at_sanfranmail.com> wrote:
>
> Hello gurus,
> Not sure why i'm having a hard time figuring this out...
>
> Oracle 12.1 Linux, DataGuard Primary to Physical Standby.
> Oracle 12.2 GI HAS (roothas.pl) configured on Primary and PS set to auto-restart both databases during a reboot.
>
> plvpdbxxxxxxx SEPIC1 /orausers > srvctl config database -db sepic1 -all -verbose
> Database unique name: SEPIC1
> Database name:
> Oracle home: /orasw/SEPIC1/product/12.1.0.2
> Oracle user: oracle
> Spfile:
> Password file:
> Domain: gmacinsurance.com
> Start options: mount
> Stop options: immediate
> Database role: PHYSICAL_STANDBY
> Management policy: AUTOMATIC
> Disk Groups:
> Services:
> Database is enabled
> OSDBA group: dba
> OSOPER group: dba
> Database instance: SEPIC1
>
> This all works as expected. Now i want the non-Active dataguard physical standby to automatically start recovering. In our old scripts we would put in :
>
> alter database recover managed standby database disconnect;
>
> Can Oracle Restart do this?
>
> TIA
>
> Lyall
> -- http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 15 2019 - 19:23:14 CEST

Original text of this message