MAXPERFORMANC E
Y* Y Y
MAXAVAILABILITY N Y Y*
MAXPROTECTION N N Y*
* in the table indicates the default supported pair and ** FASTSYNC mode is available only in Oracle Database 12.1 or later.
# odacli configure-dataguard Standby site address: test_domain root@test_domain's password:
BUI username for Standby site (default: oda-admin): BUI password for Standby site:
Database name for Data Guard configuration: test_db Primary database syspassword:
******************************************************************** ***********************
Data Guard default settings
Primary site network for Data Guard configuration: Public-network Standby site network for Data Guard configuration: Public-network Primary database listener port: 1521
Standby database listener port: 1521 Transport type: ASYNC
Protection mode: MAX_PERFORMANCE Data Guard configuration name: test_dg Active Data Guard: disabled
Do you want to edit this Data Guard configuration? (Y/N, default:N): As a requirement, Standby database's SYS password will be set to Primary database's after Data Guard configuration. Are you sure you want to proceed with Data Guard configuration? (Y/N): y
******************************************************************** ***********************
Configure Data Guard test_dg started
******************************************************************** ***********************
Step 1: Validate Data Guard configuration request (Primary site) Description: Validate DG Config Creation for db test_db
Job ID: 523a38ac-e641-46e2-bf38-ecfb641e5dc9 Started December 08, 2020 21:08:59 PM UTC
Validate create Data Guard configuration request Finished December 08, 2020 21:09:02 PM UTC
******************************************************************** ***********************
Step 2: Validate Data Guard configuration request (Standby site) Description: Validate DG Config Creation for db test_db
Job ID: 712843f9-65ca-4aea-95eb-4e5c461f3672 Started December 08, 2020 21:09:03 PM UTC
Validate create Data Guard configuration request Finished December 08, 2020 21:09:05 PM UTC
******************************************************************** ***********************
Step 3: Download password file from Primary database (Primary site) Description: Download orapwd file from Primary database
Started December 08, 2020 21:09:05 PM UTC
Prepare orapwd file for Primary database test_db Finished December 08, 2020 21:09:10 PM UTC
******************************************************************** ***********************
Step 4: Upload password file to Standby database (Standby site) Description: Upload orapwd file to Standby database
Started December 08, 2020 21:09:10 PM UTC Write orapwd file to Standby database test_db Finished December 08, 2020 21:09:19 PM UTC
******************************************************************** ***********************
Step 5: Configure Primary database (Primary site)
Description: DG Config service for db test_db - ConfigurePrimary Job ID: ad8486a2-bea6-47ff-a8ab-330be98987ab
Started December 08, 2020 21:09:19 PM UTC Configure host DNS on primary env
Configure Data Guard Tns on primary env
Enable Data Guard related Db parameters for primary env Enable force logging and archivelog mode in primary env Enable FlashBack
Configure network parameters for local listener on primary env Restart listener on primary env
Create services for primary db
Finished December 08, 2020 21:09:35 PM UTC
******************************************************************** ***********************
Step 6: Configure Standby database (Standby site)
Description: DG Config service for db test_db - ConfigureStandby Job ID: 47876bb8-8fef-41a6-a0b6-92b184c74900
Started December 08, 2020 21:09:37 PM UTC Configure Data Guard Tns on standby env Configure host DNS on standby env
Clear Data Guard related Db parameters for standby env Enable Data Guard related Db parameters for standby env Enable force logging and archivelog mode in standby env Populate standby database metadata
Configure network parameters for local listener on standby env Reset Db sizing and hidden parameters for ODA best practice Restart Listener on standby env
Create services for standby db
Finished December 08, 2020 21:11:02 PM UTC
******************************************************************** ***********************
Step 7: Configure and enable Data Guard (Primary site) Description: DG Config service for db test_db - ConfigureDg Job ID: 64674e50-3eea-48d0-a25e-bc61401a3d71
Started December 08, 2020 21:11:02 PM UTC Config and enable Data Guard
Post check Data Guard configuration
Finished December 08, 2020 21:12:21 PM UTC
******************************************************************** ***********************
Step 8: Enable Flashback (Standby site)
Description: DG Config service for db test_db - EnableFlashback Job ID: 6f461b2f-88e1-41bf-9ca8-d91bc7d4bf97
Started December 08, 2020 21:12:22 PM UTC Enable FlashBack
Finished December 08, 2020 21:12:33 PM UTC
******************************************************************** ***********************
Step 9: Re-enable Data Guard (Primary site)
Description: DG Config service for db test_db - ReenableDg Job ID: 3a4a404d-e1b5-4c4e-9db1-545676eebc77
Started December 08, 2020 21:12:34 PM UTC
Re-enable Data Guard if inconsistent properties found Post check Data Guard configuration
Finished December 08, 2020 21:12:36 PM UTC
******************************************************************** ***********************
Step 10: Create Data Guard status (Primary site)
Description: DG Status service for db test_db - NewDgconfig Job ID: 572dea8d-5682-4193-a984-0aebb072be45
Started December 08, 2020 21:12:36 PM UTC Create Data Guard status
Finished December 08, 2020 21:12:39 PM UTC
******************************************************************** ***********************
Step 11: Create Data Guard status (Standby site)
Description: DG Status service for db test_db - NewDgconfig Job ID: 75e55d7f-49c3-4e2d-8907-a7130cc05034
Started December 08, 2020 21:12:40 PM UTC Create Data Guard status
Finished December 08, 2020 21:12:41 PM UTC
******************************************************************** ***********************
Configure Data Guard test_dg completed
******************************************************************** ***********************
Example with Oracle Data Guard custom configuration:
# odacli configure-dataguard Standby site address: test_domain root@test_db's password:
BUI username for Standby site (default: oda-admin): BUI password for Standby site:
Database name for Data Guard configuration: test_db Primary database syspassword:
******************************************************************** ***********************
Data Guard default settings
Primary site network for Data Guard configuration: Public-network Standby site network for Data Guard configuration: Public-network Primary database listener port: 1521
Standby database listener port: 1521 Transport type: ASYNC
Protection mode: MAX_PERFORMANCE Data Guard configuration name: test_dg Active Data Guard: disabled
Do you want to edit this Data Guard configuration? (Y/N, default:N): y
******************************************************************** ***********************
Primary site network for Data Guard configuration [Public-network] (default: Public-network):
Standby site network for Data Guard configuration [Public-network] (default: Public-network):
Primary database listener port (default: 1521): Standby database listener port (default: 1521):
Transport type [ASYNC, FASTSYNC, SYNC] (default: ASYNC): SYNC
Protection mode [MAX_PROTECTION, MAX_PERFORMANCE, MAX_AVAILABILITY] (default: MAX_PERFORMANCE): MAX_PROTECTION
Data Guard configuration name (default: pcpub_scpub): custom_test_dg Enable Active Data Guard? (Y/N, default:N): y
The TrustStore of the Standby site should be removed unless it is necessary for some other purpose. Do you
As a requirement, Standby database's SYS password will be set to Primary database's after Data Guard configuration. Are you sure you want to proceed with Data Guard configuration? (Y/N): y
******************************************************************** ***********************
Configure Data Guard custom_test_dg started
******************************************************************** ***********************
Step 1: Validate Data Guard configuration request (Primary site) Description: Validate DG Config Creation for db test_db
Job ID: 523a38ac-e641-46e2-bf38-ecfb641e5dc9 Started December 08, 2020 21:08:59 PM UTC
Validate create Data Guard configuration request Finished December 08, 2020 21:09:02 PM UTC
******************************************************************** ***********************
Step 2: Validate Data Guard configuration request (Standby site) Description: Validate DG Config Creation for db test_db
Job ID: 712843f9-65ca-4aea-95eb-4e5c461f3672 Started December 08, 2020 21:09:03 PM UTC
Validate create Data Guard configuration request Finished December 08, 2020 21:09:05 PM UTC
******************************************************************** ***********************
Step 3: Download password file from Primary database (Primary site) Description: Download orapwd file from Primary database
Started December 08, 2020 21:09:05 PM UTC
Prepare orapwd file for Primary database test_db Finished December 08, 2020 21:09:10 PM UTC
******************************************************************** ***********************
Step 4: Upload password file to Standby database (Standby site) Description: Upload orapwd file to Standby database
Started December 08, 2020 21:09:10 PM UTC Write orapwd file to Standby database test_db Finished December 08, 2020 21:09:19 PM UTC
******************************************************************** ***********************
Step 5: Configure Primary database (Primary site)
Description: DG Config service creation for db test_db - ConfigurePrimary
Job ID: ad8486a2-bea6-47ff-a8ab-330be98987ab Started December 08, 2020 21:09:19 PM UTC Configure host DNS on primary env
Configure Data Guard Tns on primary env
Enable Data Guard related Db parameters for primary env Enable force logging and archivelog mode in primary env Enable FlashBack
Configure network parameters for local listener on primary env Restart listener on primary env
Create services for primary db
Finished December 08, 2020 21:09:35 PM UTC
******************************************************************** ***********************
Step 6: Configure Standby database (Standby site)
Description: DG Config service creation for db test_db - ConfigureStandby
Job ID: 47876bb8-8fef-41a6-a0b6-92b184c74900 Started December 08, 2020 21:09:37 PM UTC Configure Data Guard Tns on standby env Configure host DNS on standby env
Clear Data Guard related Db parameters for standby env Enable Data Guard related Db parameters for standby env Enable force logging and archivelog mode in standby env Populate standby database metadata
Configure network parameters for local listener on standby env Reset Db sizing and hidden parameters for ODA best practice Restart Listener on standby env
Create services for standby db
Finished December 08, 2020 21:11:02 PM UTC
******************************************************************** ***********************
Step 7: Configure and enable Data Guard (Primary site)
Description: DG Config service creation for db test_db - ConfigureDg Job ID: 64674e50-3eea-48d0-a25e-bc61401a3d71
Started December 08, 2020 21:11:02 PM UTC Config and enable Data Guard
Post check Data Guard configuration
Finished December 08, 2020 21:12:21 PM UTC
******************************************************************** ***********************
Step 8: Enable Flashback (Standby site)
Description: DG Config service creation for db test_db - EnableFlashback
Job ID: 6f461b2f-88e1-41bf-9ca8-d91bc7d4bf97 Started December 08, 2020 21:12:22 PM UTC Enable FlashBack
Finished December 08, 2020 21:12:33 PM UTC
******************************************************************** ***********************
Step 9: Re-enable Data Guard (Primary site)
Description: DG Config service creation for db test_db - ReenableDg Job ID: 3a4a404d-e1b5-4c4e-9db1-545676eebc77
Started December 08, 2020 21:12:34 PM UTC
Re-enable Data Guard if inconsistent properties found Post check Data Guard configuration
Finished December 08, 2020 21:12:36 PM UTC
******************************************************************** ***********************
Step 10: Enable Active Data Guard (Standby site)
Description: DG Config service creation for db test_db - EnableActivedg
Job ID: 3117c046-2d71-453d-9950-c85bed19f5f2 Started December 08, 2020 21:12:38 PM UTC Started
Open standby db Restart standby db
Finished December 08, 2020 21:12:45 PM UTC
******************************************************************** ***********************
Step 11: Create Data Guard status (Primary site)
Description: DG Status service creation for db test_db - NewDgconfig Job ID: 572dea8d-5682-4193-a984-0aebb072be45
Started December 08, 2020 21:12:46 PM UTC Create Data Guard status
Finished December 08, 2020 21:12:49 PM UTC
******************************************************************** ***********************
Step 12: Create Data Guard status (Standby site)
Description: DG Status service creation for db test_db - NewDgconfig Job ID: 75e55d7f-49c3-4e2d-8907-a7130cc05034
Started December 08, 2020 21:12:52 PM UTC Create Data Guard status
Finished December 08, 2020 21:12:55 PM UTC
******************************************************************** ***********************
******************************************************************** ***********************
You can also specify a JSON file to configure Oracle Data Guard. An example JSON file is described in this topic.
# odacli configure-dataguard -r configdg_ODA_HA.json Standby machine address: test_domain
BUI username for Standby machine (default: oda-admin): BUI password for Standby machine:
Primary database syspassword:
As a requirement, Standby database's SYS password will be set to Primary database's after Data Guard configuration. Are you sure you want to proceed? (Y/N): y
Data Guard configuration for database 'test' started
******************************************************************** ***********************
Step 1: Validate Data Guard configuration request (Primary machine) ...
For more information about these command options, see the Oracle Database
Appliance Command Line Reference chapter in this guide.
Example JSON for configuring Oracle Data Guard on Oracle Database Appliance
{ "name": "test1_test7", "protectionMode": "MAX_PERFORMANCE", "enableFlashback": true, "enableActiveDg": false, "replicationGroups": [ { "sourceEndPoints": [ { "endpointType": "PRIMARY", "hostName": test_domain1", "listenerPort": 1521, "databaseUniqueName": "test1", "ipAddress": "test_IPaddress" }, { "endpointType": "PRIMARY", "hostName": "test_domain1", "listenerPort": 1521, "databaseUniqueName": "test1", "ipAddress": "test_IPaddress2" } ], "targetEndPoints": [ { "endpointType": "STANDBY", "hostName": "test_domain2", "listenerPort": 1521, "databaseUniqueName": "test7",
"ipAddress": "test_IPaddress3" }, { "endpointType": "STANDBY", "hostName": "test_domain2", "listenerPort": 1521, "databaseUniqueName": "test7", "ipAddress": "test_IPaddress4" } ], "transportType": "ASYNC" } ] } Related Topics
• Configuring Agent Proxy Settings for Object Store Access
If the Object Store IP address is accessible only through proxy setup by the Oracle Database Appliance server, then define the proxy setting for the agent, so that the agent can access the Object Store.
• https://www.oracle.com/in/database/technologies/high-availability/maa.html
Viewing Oracle Data Guard Status on Oracle Database
Appliance
View Oracle Data Guard status using ODACLI commands.
Viewing Oracle Data Guard Status using ODACLI commands
Follow these steps:
• To view the status of primary and standby databases in your Oracle Data Guard configuration, use the following command:
# odacli list-dataguardstatus
• To view the status of your specific Oracle Data Guard configuration, use the following command:
# odacli describe-dataguardstatus -i 5f0ed48a-366d-454c-a389- fe367772dbb7
For more information about these command options, see the Oracle Database
Appliance Command Line Reference chapter in this guide.
Related Topics
• Oracle Data Guard odacli Commands
Use ODACLI commands to configure and manage Oracle Data Guard in your Oracle Database Appliance deployment.