Oracle GI Restart (ohasd) starting Physical Standby
From: Lyall Barbour <lyallbarbour_at_sanfranmail.com>
Date: Thu, 15 Aug 2019 19:13:23 +0200
Message-ID: <trinity-a1d0e611-611c-4510-8098-38e05bbb056b-1565889203404_at_3c-app-mailcom-lxa01>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 15 2019 - 19:13:23 CEST
Date: Thu, 15 Aug 2019 19:13:23 +0200
Message-ID: <trinity-a1d0e611-611c-4510-8098-38e05bbb056b-1565889203404_at_3c-app-mailcom-lxa01>
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
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