Re: Oracle GI Restart (ohasd) starting Physical Standby

From: Joseph Testa <info_at_dbsec-it.com>
Date: Thu, 15 Aug 2019 13:27:03 -0400
Message-ID: <CALFywNVDC-wfxNhK_p-+iGw7RqiZdE6NR9tanSBX4i-Esfm+pg_at_mail.gmail.com>



Doesn't the broker take care of that?

Joe

On Thu, Aug 15, 2019, 13: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:27:03 CEST

Original text of this message