New in Oracle 12c Release 2 is the ability for scripts to be executed through the Data Guard broker DGMGRL command-line interface very similar to like say in SQL*Plus.
DGMGRL commands, SQL commands using the DGMGRL SQL command, and OS commands using the new HOST (or !) capability can be bundled into a script file and executed via the DGMGRL command line.
A worked example of creating a Data Guard Broker environment via a single script is shown below.
Create Data Guard Broker Configuration [oracle@host01 ~]$ vi cre_dgb_config connect sys/G#vin2407@amer_sb; sql "alter system set dg_broker_start=TRUE"; connect sys/G#vin2407@amer; sql "alter system set dg_broker_start=TRUE"; host sleep 20; -- #############################################; -- Creating the Data Guard Broker Configuration; -- #############################################; create configuration 'amer_dg' as primary database is 'amer' connect identifier is 'amer'; add database 'amer_dg' as connect identifier is 'amer_dg'; enable configuration; show database 'amer'; show database 'amer_dg'; -- #############################################; -- Changing the Protection Level; -- #############################################; EDIT DATABASE 'amer' SET PROPERTY 'LogXptMode'='SYNC'; EDIT DATABASE 'amer_sb' SET PROPERTY 'LogXptMode'='SYNC'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY; show configuration; -- #############################################; -- Checking the Data Guard Broker Configuration; -- #############################################; show database 'amer' 'InconsistentProperties'; show database 'amer' 'InconsistentLogXptProps'; show configuration; DGMGRL> @cre_dgb_config Connected to "amer_dg" Connected as SYSDBA. Succeeded. Connected to "amer" Connected as SYSDBA. Succeeded. Configuration "amer_dg" created with primary database "amer" Database "amer_dg" added Enabled. Database - amer Role: PRIMARY Intended State: TRANSPORT-ON Instance(s): amer Database Status: SUCCESS Executing operating system command(s):" sleep 10;" Database - amer_dg Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 0 seconds (computed 1 second ago) Apply Lag: 0 seconds (computed 1 second ago) Average Apply Rate: 1.00 KByte/s Real Time Query: ON Instance(s): amer Database Status: SUCCESS Property "LogXptMode" updated Property "LogXptMode" updated Succeeded. Configuration - amer_dg Protection Mode: MaxAvailability Members: amer - Primary database amer_dg - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS (status updated 4 seconds ago) INCONSISTENT PROPERTIES INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE INCONSISTENT LOG TRANSPORT PROPERTIES INSTANCE_NAME STANDBY_NAME PROPERTY_NAME MEMORY_VALUE BROKER_VALUE Configuration - amer_dg Protection Mode: MaxAvailability Members: amer - Primary database amer_dg - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS (status updated 5 seconds ago) DGMGRL>
Please follow and like us:
Last Update: June 22, 2020
Total 0 Votes:
0
0