Using Oracle Data Guard for Disaster Management and Recovery on Oracle Database Appliance

About Oracle Data Guard on Oracle Database Appliance

Oracle Database Appliance provides client interface through ODACLI commands and BUI for easy configuration and management of Oracle Data Guard for high availability, data protection, and disaster recovery.

Oracle Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Oracle Data Guard maintains these standby databases as copies of the production database. Then, if the production database becomes unavailable because of a planned or an unplanned outage, Oracle Data Guard can switch any standby database to the production role, minimizing the downtime associated with the outage. Oracle Data Guard can be used with traditional backup, restoration, and cluster techniques to provide a high level of data protection and data availability. Oracle Data Guard transport services are also used by other Oracle features such as Oracle Streams and Oracle GoldenGate for efficient and reliable transmission of redo from a source database to one or more remote destinations.

With Oracle Data Guard, administrators can optionally improve production database performance by offloading resource-intensive backup and reporting operations to standby systems.

The ability to create clone databases on a standby system enables you to set up test or development environments based on your standby databases. Since standby systems are not production systems, they are a better choice for seeding test or development environments.

Note:

Oracle Database Enterprise Edition includes Oracle Data Guard.

Parent topic: Using Oracle Data Guard for Disaster Management and Recovery on Oracle Database Appliance

Deploying Multiple Standby Databases with Oracle Data Guard on Oracle Database Appliance

In this release, Oracle Database Appliance supports Oracle Data Guard configuration with multiple standby databases.

Prerequisites for deploying multiple standby databases with Oracle Data Guard configuration

Primary and standby databases must be on different Oracle Database Appliance systems.
For multiple standby configuration, you must deploy three Oracle Database Appliance DB systems.
You can deploy multiple standby databases by providing the values in the odacli configure-dataguard command or through JSON file.

Note:

In this release, you can configure a maximum of two standby databases with Oracle Data Guard configuration.

Note:

You can only configure all standby databases at the time of Oracle Data Guard configuration, that is, when you run the

odacli
                        configure-dataguard

command. You cannot configure additional standby databases later.

Parent topic: Using Oracle Data Guard for Disaster Management and Recovery on Oracle Database Appliance

Configuring Oracle Data Guard on Oracle Database Appliance

Oracle Database Appliance enables you to set up Oracle Data Guard using ODACLI commands.

Prerequisites for Oracle Database Guard Configuration

Before you begin:

Oracle recommends running the primary and the standby databases on separate Oracle Database Appliance hardware, so ensure that you have at least two separate Oracle Database Appliance machines.
Oracle recommends that the primary and standby systems have the same Oracle Database Appliance configuration. The database must have identical configuration for database version and storage, that is, they must have either Oracle ASM or Oracle ACFS storage, to avoid any unpredictability with the database switch roles.
The primary and standby systems must be the same Oracle Database Appliance release, and must be on Oracle Database Appliance release 19.22 or later.
If you have customized the operating system, then ensure that environments on the systems are identical.
Ensure that your deployment follows Oracle Maximum Availability Architecture (MAA) best practices. See the Oracle Maximum Availability Architecture (MAA) page on Oracle Technology Network.
If you decide to use Oracle ObjectStore for backup and recovery, then you must configure access for the primary and standby systems.

Setting up Backup and Recovery for Oracle Database Guard Configuration

You can use either Object Store or External FRA (NFS) to set up the backup for primary and standby databases when configuring Oracle Data Guard on Oracle Database Appliance. A backup is necessary to instantiate a standby database.

To set up Object Store backup (recommended):

Configure the agent proxy settings:
```
# odacli modify-agentconfig-parameters -n HttpProxyHost -v www-proxy.test.com -n HttpProxyPort -v 80 -u
```
For more information, see the topic Configuring Agent Proxy Settings for Object Store Access in this guide.

Create the Object Store credentials on both primary and standby systems:

# odacli create-objectstoreswift -e swift_end_point_URL -n Object Store_Swift_name -t Object_Store_tenant_name -u Object_Store_user_name

For example:

# odacli create-objectstoreswift -e https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1  -n aaa -t test_user -u testuser

View the Object Store Swift name:
```
# odacli list-objectstoreswifts
```

Create the backup configuration:

# odacli create-backupconfig -d objectstore -c testuser -on aaa -w 7 -cr -n backupConfig7days

Associate the backup configuration with the database:
```
# odacli modify-database -n test_db -bin backupConfig7days -bp
```

To set up NFS backup:

Create the backup configuration. For high-availability deployments, run the command on one node only.
```
# odacli create-backupconfig -n nfsbkup -w 10 -d NFS -c /u01/nfs_backup
```
Associate the backup configuration with the database:
```
# odacli modify-database -n test_db -bin nfsbkup
```

Configuring Oracle Data Guard using ODACLI commands

Follow these steps:

Take a backup of your primary database to Object Store or External FRA (NFS).
```
# odacli create-backup --backupType Regular-L0 -n primary_DB
```
For example:
```
# odacli create-backup --backupType Regular-L0 -n test_db
```
Save the backup report:
```
# odacli describe-backupreport -i eba406c7-ae46-4d1d-a1e5-3e985397b171 > backup_report_test_db_0620.json
```
The backup report ID is the ID of the backup created in step 1 and can be obtained by running the odacli list-backupreports command.
Copy the backup report to the standby system and restore the backup to a standby database. Note that to create a database with role as standby in an Oracle Data Guard configuration on Oracle Database Appliance, you do not need to copy the wallet of the primary database when using Oracle Key Vault keystore for TDE-enabled databases. The same wallet can be specified in the odacli irestore-database command.
```
# odacli irestore-database -ro STANDBY
```
If you want to use Object Store, then specify the Object Store location:
```
# odacli irestore-database -r backup_report.json -u dbUniqueName -on objectStoreName -bp -ro STANDBY
Rman Backup Encryption Password(s). Multiple passwords needs to be comma separated.:
Password for SYS user:
```
In the above command, specify the dbUniqueName of the standby system.
```
odacli irestore-database -r backup_report.json -u dbUniqueName -ro STANDBY
Password for SYS user:
```

Configure Oracle Data Guard, by running the

odacli
                        configure-dataguard

command on the primary system. Provide the values for your configuration through the interactive command line interface.

In the interactive CLI configuration steps, the parameters are as follows:

Standby site address is IP address or host name of the standby host. Provide the fully qualified domain name and hostname if the primary and the standby systems are in the same domain and DNS is configured.
You can specify multiple standby databases.

For multiple standby databases, on non-multi user access enabled systems, retain the default user name as oda-admin. Specify the BUI password for oda-admin user and operating system password for the root user when prompted.

# odacli configure-dataguard
Number of standby databases (enter 1 or 2 | default: 1): 2
Standby 1 site address: standby1
BUI username for Standby site standby. If Multi-user Access/Multi-user
Access Passwordless is not enabled on Standby site standby1, enter
'oda-admin'; otherwise, enter the name of the user who has irestored the Standby
database (default: oda-admin):
BUI password for Standby site standby1:
Password for root user on Standby site standby1:
Standby 2 site address: standby2
BUI username for Standby site standby2. If Multi-user Access/Multi-user
Access Passwordless is not enabled on Standby site standby2, enter
'oda-admin'; otherwise, enter the name of the user who has irestored the Standby
database (default: oda-admin):
BUI password for Standby site standby2:
Password for root user on Standby site standby2:

For multiple standby databases, on multi-user access enabled systems, specify the user name who has irestored the standby database. Specify the BUI password of the same user when prompted.

# odacli configure-dataguard
Number of standby databases (enter 1 or 2 | default: 1): 2
Standby 1 site address: standby1
BUI username for Standby site standby1. If Multi-user Access/Multi-user Access
Passwordless is not enabled on Standby site standby1, enter 'oda-admin'; otherwise, enter the name of the user who has irestored the Standby database (default: oda-admin): u1
BUI password for Standby site standby1. If Multi-user Access Passwordless is enabled on
Standby site, copy the cwallet.sso file from Standby site
(/opt/oracle/dcs/conf/dcspublickey_wallet/) to Primary site (/root/).
Rename the file to 'cwallet.sso.standby1', set the file ownership (root:root) and file permission (0440) and then press enter:
Standby 2 site address: standby2
BUI username for Standby
 site standby2. If Multi-user Access/Multi-user Access
Passwordless is not enabled on Standby site standby2, enter 'oda-admin'; otherwise, enter the name of the user who has irestored the Standby database (default: oda-admin): usr1
BUI password for Standby
 site standby2. If Multi-user Access Passwordless is enabled on
Standby site, copy the cwallet.sso file from Standby site
(/opt/oracle/dcs/conf/dcspublickey_wallet/) to Primary site (/root/).
Rename the file to 'cwallet.sso.standby2', set the file ownership (root:root) and file permission (0440) and then press enter:

For multiple standby databases, on multi-user access passwordless systems, specify the user name who has irestored the standby database. You are prompted to copy the wallet, follow the instructions in the interactive command flow.

# odacli configure-dataguard
Number of standby databases (enter 1 or 2 | default: 1): 2
Standby 1 site address: standby1
BUI username for Standby
 site standby1. If Multi-user Access/Multi-user Access
Passwordless is not enabled on Standby site standby1, enter 'oda-admin'; otherwise, enter the name of the user who has irestored the Standby database (default: oda-admin): u1
BUI password for Standby
 site standby1. If Multi-user Access Passwordless is enabled on
Standby site, copy the cwallet.sso file from Standby site
(/opt/oracle/dcs/conf/dcspublickey_wallet/) to Primary site (/root/).
Rename the file to 'cwallet.sso.standby1', set the file ownership (root:root) and file permission (0440) and then press enter:
Standby 2 site address: standby2
BUI username for Standby
 site standby2. If Multi-user Access/Multi-user Access
Passwordless is not enabled on Standby site standby2, enter 'oda-admin'; otherwise, enter the name of the user who has irestored the Standby database (default: oda-admin): usr1
BUI password for Standby
 site standby2. If Multi-user Access Passwordless is enabled on
Standby site, copy the cwallet.sso file from Standby site
(/opt/oracle/dcs/conf/dcspublickey_wallet/) to Primary site (/root/).
Rename the file to 'cwallet.sso.standby2', set the file ownership (root:root) and file permission (0440) and then press enter:

Select Oracle Data Guard protection modes to meet availability, performance and data protection requirements. Oracle Data Guard Protection Modes are Maximum Availability, Maximum Performance, and Maximum Protection. The log transport modes are ASYNC, SYNC, and FASTSYNC.
You can select the following combinations of protection modes and transport types:

Table 13-1 Oracle Data Guard protection modes and transport modes

Protection Mode \ Transport Type	ASYNC	FASTSYNC**	SYNC
MAXPERFORMANCE	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.

Example with one standby configuration:

# odacli configure-dataguard
# /opt/oracle/dcs/bin/odacli configure-dataguard
Number of standby databases (enter 1 or 2 | default: 1):
Standby 1 site address: phxdbfzp04.dev3farm3phx.databasede3phx
BUI username for Standby site host1. If Multi-user Access/Multi-user Access Passwordless is not enabled on Standby site phxdbfzp04.dev3farm3phx.databasede3phx, enter 'oda-admin'; otherwise, enter the name of the user who has irestored the Standby database (default: oda-admin): oda-admin
BUI password for Standby site host2:
Password for root user on Standby site host2:
 
*******************************************************************************************
Data Guard configuration name: tdb_dg
Database name for Data Guard configuration: tdb
Primary database SYS password:
Protection mode [MAX_PROTECTION, MAX_PERFORMANCE, MAX_AVAILABILITY] (default: MAX_PERFORMANCE):
Enable Active Data Guard (Y/N, default:N):
*******************************************************************************************
 
Data Guard default settings for standby database - tdbstndby
Primary site network for Data Guard configuration: Public-network
Standby site network for Data Guard configuration: Public-network
Primary database listener port (TCP): 1521
Standby database listener port (TCP): 1521
Transport type: ASYNC
Do you want to edit this Data Guard configuration? (Y/N, default:N): N
*******************************************************************************************
Enter Primary database RMAN backup encryption password if any:
Do you want to provide another Primary database RMAN backup encryption password if any? [y/n] (default 'n'):
Standby database's SYS password will be set to Primary database's after Data Guard configuration. Ignore warning and proceed with Data Guard configuration? (Y/N, default:N): Y
{
  "jobId" : "e02cc0b3-bce3-4d6c-a1f5-5b121bb7f66a",
  "status" : "Created",
  "message" : "",
  "reports" : [ ],
  "createTimestamp" : "January 23, 2025 03:12:44 AM UTC",
  "resourceList" : [ ],
  "description" : "DG Config service for DB tdb",
  "updatedTime" : "January 23, 2025 03:12:44 AM UTC",
  "jobType" : null,
  "cpsMetadata" : null
}
 
[root@host1 work]# /opt/oracle/dcs/bin/odacli describe-job -i e02cc0b3-bce3-4d6c-a1f5-5b121bb7f66a
 
Job details                                                     
----------------------------------------------------------------
                     ID:  e02cc0b3-bce3-4d6c-a1f5-5b121bb7f66a
            Description:  DG Config service for DB tdb
                 Status:  Success
                Created:  January 23, 2025 03:12:44 UTC
                Message: 
 
Task Name                                Start Time                               End Time                                 Status         
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------------
Validate configure primary request       January 23, 2025 03:13:10 UTC            January 23, 2025 03:13:21 UTC            Success        
(Primary site) (Host: host1/Job                                                                                                      
ID:                                                                                                                                       
901389f5-0cad-4ee6-91be-3f77b85652af)                                                                                                     
Validate configure standby request       January 23, 2025 03:13:21 UTC            January 23, 2025 03:13:29 UTC            Success        
(Standby site) (Host:                                                                                                                     
host2/Job ID:                                                                                                                    
856d86e4-dd51-41a7-9050-b0c39ae771f9)                                                                                                     
Uploading Primary DB Password File       January 23, 2025 03:13:29 UTC            January 23, 2025 03:13:52 UTC            Success        
(Standby site)                                                                                                                            
Configure primary database (Primary      January 23, 2025 03:13:52 UTC            January 23, 2025 03:15:29 UTC            Success        
site) (Host: host1/Job ID:                                                                                                           
5dd46e86-e07f-423f-9ebf-2515b4ac17d5)                                                                                                     
Configure standby request (Standby       January 23, 2025 03:15:29 UTC            January 23, 2025 03:17:30 UTC            Success        
site) (Host:                                                                                                                              
host2/Job ID:                                                                                                                    
2ab511a2-15c0-4371-bf30-9b7e27ff5288)                                                                                                     
Create archive log restore (Primary      January 23, 2025 03:17:30 UTC            January 23, 2025 03:17:52 UTC            Success        
site) (Host: host1/Job ID:                                                                                                           
96766874-6537-4972-81a9-971440e2acfb)                                                                                                     
Configure and enable Data Guard          January 23, 2025 03:17:53 UTC            January 23, 2025 03:19:19 UTC            Success        
(Primary site) (Host: host1/Job                                                                                                      
ID:                                                                                                                                       
7ad65ffa-ea06-479d-bb21-e0b81fb8c743)                                                                                                     
Enable Flashback (Standby site) (Host:   January 23, 2025 03:19:19 UTC            January 23, 2025 03:19:38 UTC            Success        
host2/Job ID:                                                                                                                    
a1768703-4dd4-4f1f-b9a3-9fe0f99615d5)                                                                                                     
Re-enable Data Guard (Primary site)      January 23, 2025 03:19:38 UTC            January 23, 2025 03:19:44 UTC            Success        
(Host: host1/Job ID:                                                                                                                 
3f6dd276-63e3-4804-a179-e10052386206)                                                                                                     
Create Data Guard status (Primary        January 23, 2025 03:19:44 UTC            January 23, 2025 03:19:49 UTC            Success        
site) (Host: host1/Job ID:                                                                                                           
8a3eb946-3501-4618-9d4a-ad8a6d298cc8)                                                                                                     
Create Data Guard status (Standby        January 23, 2025 03:19:49 UTC            January 23, 2025 03:19:57 UTC            Success        
site) (Host:                                                                                                                              
host2/Job ID:                                                                                                                    
d9d65942-6284-40d5-a991-b1d21edae96f)

Example with two standby databases configuration:

# odacli configure-dataguard
Number of standby databases (enter 1 or 2 | default: 1): 2
Standby 1 site address: standby1
BUI username for Standby site standby1. If Multi-user Access/Multi-user
Access Passwordless is not enabled on Standby site standby1, enter
'oda-admin'; otherwise, enter the name of the user who has irestored the Standby
database (default: oda-admin):
BUI password for Standby site standby1:
Password for root user on Standby site standby1:
Standby 2 site address: standby2
BUI username for Standby site standby2. If Multi-user Access/Multi-user
Access Passwordless is not enabled on Standby site standby2, enter
'oda-admin'; otherwise, enter the name of the user who has irestored the Standby
database (default: oda-admin):
BUI password for Standby site standby2:
Password for root user on Standby site standby2:
 
*******************************************************************************************
Data Guard configuration name: dgbb
Database name for Data Guard configuration: bb
Primary database SYS password:
Protection mode [MAX_PROTECTION, MAX_PERFORMANCE, MAX_AVAILABILITY] (default:
MAX_PERFORMANCE):
Enable Active Data Guard (Y/N, default:N):
*******************************************************************************************
 
Data Guard default settings for standby database - bb1
Primary site network for Data Guard configuration: Public-network
Standby site network for Data Guard configuration: Public-network
Primary database listener port (TCP): 1521
Standby database listener port (TCP): 1521
Transport type: ASYNC
Do you want to edit this Data Guard configuration? (Y/N, default:N):
 
Data Guard default settings for standby database - bb2
Primary site network for Data Guard configuration: Public-network
Standby site network for Data Guard configuration: Public-network
Primary database listener port (TCP): 1521
Standby database listener port (TCP): 1521
Transport type: ASYNC
Do you want to edit this Data Guard configuration? (Y/N, default:N):
Warning: in compliance with Oracle MAA best practices. DbType (RAC) of Primary
database bb is different from DbType (SI) of Standby database. Ignore warning
and proceed with Data Guard configuration? (Y/N, default:N): y
Warning: in compliance with Oracle MAA best practices. DbType (RAC) of Primary
database bb is different from DbType (SI) of Standby database. Ignore warning
and proceed with Data Guard configuration? (Y/N, default:N): y
*******************************************************************************************
Enter Primary database RMAN backup encryption password if any:
Do you want to provide another Primary database RMAN backup encryption password
if any? [y/n] (default 'n'):
Standby database's SYS password will be set to Primary database's after Data
Guard configuration. Ignore warning and proceed with Data Guard configuration?
(Y/N, default:N): y
{
  "jobId" : "f1df87d7-221c-4dc3-a15f-fa35d91560f5",
  "status" : "Created",
  "message" : "",
  "reports" : [ ],
  "createTimestamp" : "January 17, 2025 22:57:55 PM UTC",
  "resourceList" : [ ],
  "description" : "DG Config service for DB bb",
  "updatedTime" : "January 17, 2025 22:57:55 PM UTC",
  "jobType" : null,
  "cpsMetadata" : null
}
 
[root@host1 ~]# odacli describe-job -i
"f1df87d7-221c-4dc3-a15f-fa35d91560f5"
 
Job details                                                     
----------------------------------------------------------------
                     ID:  f1df87d7-221c-4dc3-a15f-fa35d91560f5
            Description:  DG Config service for DB bb
                 Status:  Success
                Created:  January 17, 2025 22:57:55 UTC
                Message: 
 
Task Name                                Node Name                 Start Time  End Time              Status     
    
---------------------------------------- --------------------------------------------------------------------------------------------------------- ----------------
Validate configure primary request       host1          January 17,2025 22:58:38 UTC            January 17, 2025 22:58:44 UTC            Success  
      
(Primary site) (Host:host1/Job ID:                                                         
eb8bbb43-159c-48e0-8dda-9e2bbd280669)                                          
    
Validate configure standby request       host1          January 17,2025 22:58:44 UTC            January 17, 2025 22:58:52 UTC            Success  
(Standby site) (Host: standby1/Job ID:                                                                            
86345f35-500c-4ba8-8ff9-f97c201ad3c7)                                          
   
Uploading Primary DB Password File       host1          January 17,2025 22:58:52 UTC            January 17, 2025 22:59:07 UTC            Success  
(Standby site)                                                                 

Configure primary database (Primary      host1          January 17,2025 22:59:07 UTC            January 17, 2025 22:59:58 UTC            Success  
site) (Host: host1/Job ID:                                          
23ee7263-a59e-40bd-bbec-4c17a5d4ba99)                                          
                                                                                 
    
Configure standby request (Standby       host1          January 17,2025 22:59:58 UTC            January 17, 2025 23:02:00 UTC            Success  
site) (Host: standby1/Job ID:                                               
af543839-85ba-4e83-89d3-af161d528256)                                          

Create archive log restore (Primary      host1          January 17,2025 23:02:00 UTC            January 17, 2025 23:02:37 UTC            Success  
site) (Host: host1/Job ID:                                          
b2940217-cec6-4b22-92d2-f4ec8f26b8b8)                                          
   
Configure and enable Data Guard          host1          January 17,2025 23:02:37 UTC            January 17, 2025 23:04:19 UTC            Success  
(Primary site) (Host:                                                            
host1/Job ID:                                                       
7882e1e5-0d71-48df-bd86-e79ee6b57a21)                                          
 
Enable Flashback (Standby site) (Host:   host1          January 17,2025 23:04:19 UTC            January 17, 2025 23:04:37 UTC            Success  
standby1/Job ID:                                                            
c2ef962c-f429-4e97-8bc3-1355cd7d0ca8)                                          
   
Re-enable Data Guard (Primary site)      host1          January 17,2025 23:04:37 UTC            January 17, 2025 23:04:43 UTC            Success  
(Host: host1/Job ID:                                                
fb4a7055-0049-4d44-a726-0871ed54ca07)                                          

Create Data Guard status (Primary        host1          January 17,2025 23:04:43 UTC            January 17, 2025 23:04:54 UTC            Success  
site) (Host: host1/Job ID:                                          
5aca5c16-632f-488b-aade-1c677030c81d)                                          
 
Create Data Guard status (Standby        host1          January 17,2025 23:04:54 UTC            January 17, 2025 23:05:07 UTC            Success  
site) (Host: standby1/Job ID:                                               
5f0c5460-4c38-4aed-8a5b-e70c0ca70df8)                                          
  
Validate configure primary request       host1          January 17,2025 23:05:07 UTC            January 17, 2025 23:05:13 UTC            Success  
(Primary site) (Host:host1/Job ID:                                                       
5ac64b32-5da6-48df-b8cc-020853363695)                                          
 
Validate configure standby request       host1          January 17,2025 23:05:13 UTC            January 17, 2025 23:05:21 UTC            Success  
(Standby site) (Host: standby2/Job ID:                                                                            
81aa6900-4460-408e-9ab2-fdcd92c8b7bf)                                          
 
Uploading Primary DB Password File       host1          January 17,2025 23:05:21 UTC            January 17, 2025 23:05:32 UTC            Success  
(Standby site)                                                                 

Configure primary database (Primary      host1          January 17,2025 23:05:32 UTC            January 17, 2025 23:06:14 UTC            Success  
site) (Host: host1/Job ID:                                          
c78a8072-8023-4278-bd94-3dd1ef97e066)                                          
  
Configure standby request (Standby       host1          January 17,2025 23:06:14 UTC            January 17, 2025 23:07:43 UTC            Success  
site) (Host: standby2/Job ID:                                               
46274a35-bb06-43a9-a8a5-66dc4d163463)                                          
 
Create archive log restore (Primary      host1          January 17,2025 23:07:43 UTC            January 17, 2025 23:08:15 UTC            Success  
site) (Host: host1/Job ID:                                          
2b20aaa2-fcb7-4bc5-b501-27ad9d45f34b)                                          
 
Configure standby TNS entry (New         host1          January 17,2025 23:08:15 UTC            January 17, 2025 23:08:24 UTC            Success  
standby site) (Host: standby2/Job ID:                                                                            
7e32db8c-999c-44fa-bdf5-3aed77c9590c)                                          
 
Configure standby TNS entry (Existing    host1          January 17,2025 23:08:24 UTC            January 17, 2025 23:08:28 UTC            Success  
standby site) (Host: standby1/Job ID:                                                                            
6a44539e-d5b9-4c45-ad2c-7bff8c871e37)                                          

Add standby database (Primary site)      host1          January 17,2025 23:08:28 UTC            January 17, 2025 23:09:50 UTC            Success  
(Host: host1/Job ID:                                                
1d7c6c93-bd85-496a-bb7d-67ae7b224d58)                                          
  
Enable Flashback (Standby site) (Host:   host1          January 17,2025 23:09:50 UTC            January 17, 2025 23:10:03 UTC            Success  
standby2/Job ID:                                                            
4a6b8623-efc0-4016-80be-305b0ed56363)                                          

Re-enable Data Guard (Primary site)      host1          January 17,2025 23:10:03 UTC            January 17, 2025 23:10:09 UTC            Success  
(Host: host1/Job ID:                                                
2afea759-752a-42a4-a077-bd85d4b687a3)                                          

Update Data Guard status (Primary        host1          January 17,2025 23:10:09 UTC            January 17, 2025 23:10:35 UTC            Success  
site) (Host: host1/Job ID:                                          
11d93988-ea4d-4e37-af30-763c2522693d)                                          

Create Data Guard status (New standby    host1          January 17,2025 23:10:35 UTC            January 17, 2025 23:10:53 UTC            Success  
site) (Host: standby2/Job ID:
aa5b286f-30f1-48d1-8c2d-2490d15ce408)                                          
 
Update Data Guard status (Existing host1          January 17,2025 23:10:53 UTC            January 17, 2025 23:11:06 UTC            Success  
standby site) (Host: standby1/JobID: 
7d8ffa16-6785-468a-bff9-baf8e13b38ec)

Example with Oracle Data Guard custom configuration:

# odacli configure-dataguard
Number of standby databases (enter 1 or 2 | default: 1): 2
Standby 1 site address: standby1
BUI username for Standby site standby1. If Multi-user Access/Multi-user Access Passwordless is not enabled on Standby site standby1, enter 'oda-admin'; otherwise, enter the name of the user who has irestored the Standby database (default: oda-admin):
BUI password for Standby site standby1:
Password for root user on Standby site standby1:
Standby 2 site address: standby2
BUI username for Standby site standby2. If Multi-user Access/Multi-user Access Passwordless is not enabled on Standby site standby2, enter 'oda-admin'; otherwise, enter the name of the user who has irestored the Standby database (default: oda-admin):
BUI password for Standby site standby2:
Password for root user on Standby site standby2:
 
Data Guard configuration name: dg6  
Database name for Data Guard configuration: db
Primary database SYS password:
Protection mode [MAX_PROTECTION, MAX_PERFORMANCE, MAX_AVAILABILITY] (default: MAX_PERFORMANCE): MAX_AVAILABILITY
Enable Active Data Guard? (Y/N, default:N): y
*******************************************************************************************
Data Guard default settings for standby database kdb
Primary site network for Data Guard configuration: Public-network
Standby site network for Data Guard configuration: Public-network
Primary database listener port (TCP): 1521
Standby database listener port (TCP): 1521
Transport type: ASYNC
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 (TCP) (default: 1521):
Standby database listener port (TCP) (default: 1521):
Transport type [ASYNC, FASTSYNC, SYNC] (default: ASYNC): SYNC
*******************************************************************************************
Data Guard default settings for standby database ldb
Primary site network for Data Guard configuration: Public-network
Standby site network for Data Guard configuration: Public-network
Primary database listener port (TCP): 1521
Standby database listener port (TCP): 1521
Transport type: ASYNC
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 (TCP) (default: 1521):
Standby database listener port (TCP) (default: 1521):
Transport type [ASYNC, FASTSYNC, SYNC] (default: ASYNC): SYNC
Enter Primary database RMAN backup encryption password if any:
Do you want to provide another Primary database RMAN backup encryption password if any? [y/n] (default 'n'):
Standby database's SYS password will be set to Primary database's after Data Guard configuration. Ignore warning and proceed with Data Guard configuration? (Y/N, default:N): y
{
  "jobId" : "fcf23de7-3ef0-4dae-9a3c-735abf9bda4a",
  "status" : "Created",
  "message" : "",
  "reports" : [ ],
  "createTimestamp" : "December 13, 2024 01:58:53 AM CET",
  "resourceList" : [ ],
  "description" : "DG Config service for DB db",
  "updatedTime" : "December 13, 2024 01:58:53 AM CET",
  "jobType" : null,
  "cpsMetadata" : null
}
 
[root@test_host ~]# odacli describe-job -i fcf23de7-3ef0-4dae-9a3c-735abf9bda4a
 
Job details                                                     
----------------------------------------------------------------
                     ID:  fcf23de7-3ef0-4dae-9a3c-735abf9bda4a
            Description:  DG Config service for DB db
                 Status:  Success
                Created:  December 13, 2024 01:58:53 CET
                Message: 
 
Task Name                                Start Time                               End Time                                 Status         
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------------
Validate configure primary request       December 13, 2024 02:01:18 CET           December 13, 2024 02:01:29 CET           Success        
(Primary site) (Host:                                                                                                                     
test_host/Job ID:                                                                                                                   
cce1142e-24e4-4bbc-9d46-f46f96bf3191)                                                                                                     
Validate configure standby request       December 13, 2024 02:01:29 CET           December 13, 2024 02:01:45 CET           Success        
(Standby site) (Host:                                                                                                                     
standby1/Job ID:                                                                                                                   
f962f6dc-4eeb-497f-9a0c-b9387d25318b)                                                                                                     
Uploading Primary DB Password File       December 13, 2024 02:01:45 CET           December 13, 2024 02:02:16 CET           Success        
(Standby site)                                                                                                                            
Configure primary database (Primary      December 13, 2024 02:02:16 CET           December 13, 2024 02:02:43 CET           Success        
site) (Host: test_host/Job ID:                                                                                                      
0d909875-ecec-450a-a2f9-6c09103d9f26)                                                                                                     
Configure standby request (Standby       December 13, 2024 02:02:43 CET           December 13, 2024 02:04:11 CET           Success        
site) (Host: standby1/Job ID:                                                                                                      
03ffc6b5-5f45-47af-b96c-d75b82a09234)                                                                                                     
Create archive log restore (Primary      December 13, 2024 02:04:11 CET           December 13, 2024 02:04:47 CET           Success        
site) (Host: test_host/Job ID:                                                                                                      
49808676-bd12-4933-8c28-eef7dee17503)                                                                                                     
Configure and enable Data Guard          December 13, 2024 02:04:47 CET           December 13, 2024 02:06:32 CET           Success        
(Primary site) (Host:                                                                                                                     
test_host/Job ID:                                                                                                                   
7ed03a2d-bb93-4ff7-9e45-0f825c8fff2f)                                                                                                     
Enable Flashback (Standby site) (Host:   December 13, 2024 02:06:32 CET           December 13, 2024 02:06:53 CET           Success        
standby1/Job ID:                                                                                                                   
da1ee6fb-cfb3-4f6d-9eaa-a6c1c8811d0e)                                                                                                     
Re-enable Data Guard (Primary site)      December 13, 2024 02:06:53 CET           December 13, 2024 02:06:59 CET           Success        
(Host: test_host/Job ID:                                                                                                            
f1b8f204-da5b-40f4-886f-3dc2d0f71042)                                                                                                     
Enable Active Data Guard (Standby        December 13, 2024 02:06:59 CET           December 13, 2024 02:07:26 CET           Success        
site) (Host: standby1/Job ID:                                                                                                      
d5982a61-b48d-4449-8cad-2eb41fc89ff9)                                                                                                     
Create Data Guard status (Primary        December 13, 2024 02:07:26 CET           December 13, 2024 02:07:42 CET           Success        
site) (Host: test_host/Job ID:                                                                                                      
e7b6448b-301d-45e5-9a90-4388ac6f55f6)                                                                                                     
Create Data Guard status (Standby        December 13, 2024 02:07:42 CET           December 13, 2024 02:07:58 CET           Success        
site) (Host: standby1/Job ID:                                                                                                      
b046c3ca-dcae-47c4-b904-8fe8fb7cd166)                                                                                                     
Validate configure primary request       December 13, 2024 02:07:59 CET           December 13, 2024 02:08:10 CET           Success        
(Primary site) (Host:                                                                                                                     
test_host/Job ID:                                                                                                                   
f2cec30f-74ee-44e3-bbbc-f6bc47bcc781)                                                                                                     
Validate configure standby request       December 13, 2024 02:08:10 CET           December 13, 2024 02:08:26 CET           Success        
(Standby site) (Host:                                                                                                                     
standby2/Job ID:                                                                                                                   
f170c64f-347b-4606-af31-dbb4c0abaccf)                                                                                                     
Uploading Primary DB Password File       December 13, 2024 02:08:26 CET           December 13, 2024 02:08:57 CET           Success        
(Standby site)                                                                                                                            
Configure primary database (Primary      December 13, 2024 02:08:57 CET           December 13, 2024 02:09:23 CET           Success        
site) (Host: test_host/Job ID:                                                                                                      
f680835a-3813-433e-bcc3-8d49ae235833)                                                                                                     
Configure standby request (Standby       December 13, 2024 02:09:23 CET           December 13, 2024 02:11:02 CET           Success        
site) (Host: standby2/Job ID:                                                                                                      
d66ef480-0810-4219-a5e1-633be0d6fe9a)                                                                                                     
Create archive log restore (Primary      December 13, 2024 02:11:03 CET           December 13, 2024 02:11:36 CET           Success        
site) (Host: test_host/Job ID:                                                                                                      
ae4e5f3d-6792-44c4-8971-df41ae212a04)                                                                                                     
Configure standby TNS entry (New         December 13, 2024 02:11:36 CET           December 13, 2024 02:11:54 CET           Success        
standby site) (Host:                                                                                                                      
standby2/Job ID:                                                                                                                   
27bbe14a-6f7d-4a7f-bded-9d530327090f)                                                                                                     
Configure standby TNS entry (Existing    December 13, 2024 02:11:54 CET           December 13, 2024 02:12:13 CET           Success        
standby site) (Host:                                                                                                                      
standby1/Job ID:                                                                                                                   
dcf53474-d649-452f-818a-4fe069e9761e)                                                                                                     
Add standby database (Primary site)      December 13, 2024 02:12:13 CET           December 13, 2024 02:13:38 CET           Success        
(Host: test_host/Job ID:                                                                                                            
2ffb36d8-74a0-4dc4-9f79-cc74223f1016)                                                                                                     
Enable Flashback (Standby site) (Host:   December 13, 2024 02:13:38 CET           December 13, 2024 02:14:00 CET           Success        
standby2/Job ID:                                                                                                                   
01a23d42-d49a-4b61-9c28-19e9f7639800)                                                                                                     
Re-enable Data Guard (Primary site)      December 13, 2024 02:14:00 CET           December 13, 2024 02:14:06 CET           Success        
(Host: test_host/Job ID:                                                                                                            
f416981a-99c1-4c0a-ab72-2bbb5a0e3a40)                                                                                                     
Enable Active Data Guard (Standby        December 13, 2024 02:14:06 CET           December 13, 2024 02:14:32 CET           Success        
site) (Host: standby2/Job ID:                                                                                                      
99618fc7-0500-4275-8ea2-f65a8b4e8f77)                                                                                                     
Update Data Guard status (Primary        December 13, 2024 02:14:32 CET           December 13, 2024 02:14:48 CET           Success        
site) (Host: test_host/Job ID:                                                                                                      
14b4526c-eebe-410a-920e-396df5216c93)                                                                                                     
Create Data Guard status (Standby        December 13, 2024 02:14:48 CET           December 13, 2024 02:15:15 CET           Success        
site) (Host: standby2/Job ID:                                                                                                      
090f829d-7f80-4481-800c-c9c6115a4be2)                                                                                                     
Update Data Guard status (Old Standby    December 13, 2024 02:15:15 CET           December 13, 2024 02:15:31 CET           Success        
site) (Host: standby1/Job ID:                                                                                                      
afc0a2b3-18ad-461c-a13d-ec688427c6e6)

You can specify a JSON file to configure Oracle Data Guard. Ensure that you specify the databaseName and standbyEndpoints options in the JSON file.

{
    "name": "tdb_DG",
    "protectionMode": "MAX_PERFORMANCE",
    "enableFlashback": true,
    "enableActiveDg": "false",
    "databaseName": "tdb",                ==> newly added  mandatory field
    "replicationGroups": [
        {
            "sourceEndPoints": [
                {
                    "endpointType": "PRIMARY",
                    "hostName": "host_name",
                    "listenerPort": 1521,
                    "databaseUniqueName": "tdb",
                    "ipAddress": "xx.xx.xx.xx" ==> VIP of the corresponding network
                }
            ],
            "targetEndPoints": [
                {
                    "endpointType": "STANDBY",
                    "hostName": "host_name",
                    "listenerPort": 1521,
                    "databaseUniqueName": "tdbstndby",
                    "ipAddress": "xx.xx.xx.xx"
                }
            ],
            "transportType": "SYNC"
        }
    ],
    "standbyEndpoints": [               ==> newly added optional field
        {
            "name": "endpoint_test",
            "dcsUserName": "oda-admin"
        }
    ]
}

For more information about these command options, see the Oracle Database Appliance Command Line Reference chapter in this guide.

Configuring Oracle Data Guard with one standby database on Oracle Database Appliance using JSON file

# /opt/oracle/dcs/bin/odacli configure-dataguard --requestjson /mnt/host1/nfsbackup/dgcmd.json
Number of standby databases (enter 1 or 2 | default: 1):
BUI password for Standby site standby1:
Password for root user on Standby site standby1:
Primary database SYS password:
*******************************************************************************************
Standby database's SYS password will be set to Primary database's after Data Guard configuration. Ignore warning and proceed with Data Guard configuration? (Y/N, default:N): Y
{
  "jobId" : "73adf616-3b6c-452f-bf93-e95abc675cc5",
  "status" : "Created",
  "message" : "",
  "reports" : [ ],
  "createTimestamp" : "January 23, 2025 05:08:50 AM UTC",
  "resourceList" : [ ],
  "description" : "DG Config service for DB tdb",
  "updatedTime" : "January 23, 2025 05:08:50 AM UTC",
  "jobType" : null,
  "cpsMetadata" : null
}
  
[root@host1 work]# /opt/oracle/dcs/bin/odacli describe-job -i 73adf616-3b6c-452f-bf93-e95abc675cc5
 
Job details                                                     
----------------------------------------------------------------
                     ID:  73adf616-3b6c-452f-bf93-e95abc675cc5
            Description:  DG Config service for DB tdb
                 Status:  Success
                Created:  January 23, 2025 05:08:50 UTC
                Message: 
 
Task Name                                Start Time                               End Time                                 Status         
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------------
Validate configure primary request       January 23, 2025 05:09:19 UTC            January 23, 2025 05:09:30 UTC            Success        
(Primary site) (Host: host1/Job                                                                                                      
ID:                                                                                                                                       
7bd1a3d5-2f8c-4d9e-a381-61d04f01b514)                                                                                                     
Validate configure standby request       January 23, 2025 05:09:30 UTC            January 23, 2025 05:09:43 UTC            Success        
(Standby site) (Host:                                                                                                                     
host2/Job ID:                                                                                                                    
18731cf2-bf42-4a3a-b187-17e93cedbb7c)                                                                                                     
Uploading Primary DB Password File       January 23, 2025 05:09:43 UTC            January 23, 2025 05:10:03 UTC            Success        
(Standby site)                                                                                                                            
Configure primary database (Primary      January 23, 2025 05:10:03 UTC            January 23, 2025 05:11:35 UTC            Success        
site) (Host: host1/Job ID:                                                                                                           
d3030fe0-8885-42d6-a57f-ae38baef54af)                                                                                                     
Configure standby request (Standby       January 23, 2025 05:11:35 UTC            January 23, 2025 05:13:35 UTC            Success        
site) (Host:                                                                                                                              
host2/Job ID:                                                                                                                    
763881f4-ea4d-43bc-8e6a-c7f78765c0ff)                                                                                                     
Create archive log restore (Primary      January 23, 2025 05:13:35 UTC            January 23, 2025 05:13:54 UTC            Success        
site) (Host: host1/Job ID:                                                                                                           
5dfbe653-10c8-420f-bada-4c0c8cb6a9e1)                                                                                                     
Configure and enable Data Guard          January 23, 2025 05:13:54 UTC            January 23, 2025 05:15:26 UTC            Success        
(Primary site) (Host: host1/Job                                                                                                      
ID:                                                                                                                                       
137d29a2-9d2c-4ddc-85c8-3a729847e188)                                                                                                     
Enable Flashback (Standby site) (Host:   January 23, 2025 05:15:26 UTC            January 23, 2025 05:15:44 UTC            Success        
host2/Job ID:                                                                                                                    
70306983-40a2-4039-98cb-57ba5e11e9a5)                                                                                                     
Re-enable Data Guard (Primary site)      January 23, 2025 05:15:44 UTC            January 23, 2025 05:15:50 UTC            Success        
(Host: host1/Job ID:                                                                                                                 
4a5fb2aa-1b0b-45c8-b2f3-95103c9f1f00)                                                                                                     
Create Data Guard status (Primary        January 23, 2025 05:15:50 UTC            January 23, 2025 05:15:56 UTC            Success        
site) (Host: host1/Job ID:                                                                                                           
6848b9c1-356f-43ff-b6e0-5e9b1b01fc53)                                                                                                     
Create Data Guard status (Standby        January 23, 2025 05:15:56 UTC            January 23, 2025 05:16:09 UTC            Success        
site) (Host:                                                                                                                              
host2/Job ID:                                                                                                                    
3109148f-9ef8-4914-ab43-adab4851e126)

Example JSON for configuring Oracle Data Guard with two standby databases on Oracle Database Appliance

To configure two standby databases using JSON file, you must specify two replicationGroups sections, where sourceEndpoints corresponds to the information about the primary database and targetEndPoints in each replicationGroups section corresponds to each standby database. For example:

{
  "name": "dgname",
  "protectionMode": "MAX_PERFORMANCE",
  "databaseName": "vmdb1",
  "enableActiveDg": false,
  "databaseName": "tdb", ==> newly added field
  "standbyEndpoints": [ ==> newly added field
        {
            "name": "endpoint_test",
            "dcsUserName": "oda-admin"
        }
    ]
  "replicationGroups": [
    {
      "sourceEndPoints": [
        {
          "databaseUniqueName": "vmdb1",
          "ipAddress": "xx.xx.xx.xx",
          "hostName": "host_name",
          "listenerPort": 1521
        }
      ],
      "targetEndPoints": [
        {
          "databaseUniqueName": "bvmdb1",
          "ipAddress": "xx.xx.xx.xx",
          "hostName": "host_name,
          "listenerPort": 1521
        }
      ],
      "transportType": "ASYNC"
    },
    {
      "sourceEndPoints": [
        {
          "databaseUniqueName": "vmdb1",
          "ipAddress": "xx.xx.xx.xx",
          "hostName": "host_name",
          "listenerPort": 1521
        }
      ],
      "targetEndPoints": [
        {
          "databaseUniqueName": "avmdb1",
          "ipAddress": "xx.xx.xx.xx",
          "hostName": "host_name",
          "listenerPort": 1521
        }
      ],
      "transportType": "ASYNC"
    }
  ]
}

Configuring Oracle Data Guard on Oracle Database Appliance Using BUI

Oracle Database Appliance enables you to set up Oracle Data Guard using BUI.

Prerequisites for Oracle Database Guard Configuration

Before you begin:

Oracle recommends running the primary and the standby databases on separate Oracle Database Appliance hardware, so ensure that you have at least two separate Oracle Database Appliance machines.
Oracle recommends that the primary and standby systems have the same Oracle Database Appliance configuration. The database must have identical configuration for database version and storage, that is, they must have either Oracle ASM or Oracle ACFS storage, to avoid any unpredictability with the database switch roles.
The primary and standby systems must be the same Oracle Database Appliance release, and must be on Oracle Database Appliance release 19.26 or later.
If you have customized the operating system, then ensure that environments on the systems are identical.
Ensure that your deployment follows Oracle Maximum Availability Architecture (MAA) best practices. See the Oracle Maximum Availability Architecture (MAA) page on Oracle Technology Network.
If you decide to use Oracle ObjectStore for backup and recovery, then you must configure access for the primary and standby systems.
Ensure that the backup for for primary and standby databases is set up. You can use either Object Store or External FRA (NFS) to set up the backup for primary and standby databases when configuring Oracle Data Guard on Oracle Database Appliance. A backup is necessary to instantiate a standby database.

Configuring Oracle Data Guard using BUI

Follow these steps:

Log into the Browser User Interface:
https://host-ip-address:7093/mgmt/index.html
Click Database.
In the Database page, click on the database to view the database details.
In the Database details page, click the Dataguard Associations tab. The Oracle Data Guard configurations associated with the database are displayed.
To configure an Oracle Data Guard configuration, click Configure.
In the System Information tab, you can use a JSON file to provide the Oracle Data Guard configuration values or specify the values for each field.
To configure Oracle Data Guard using JSON file, in the System Information tab, click Browse and load the configuration.
Or, specify the Dataguard Configuration Name and Select Protection Mode. The Database name field is already populated.
Select Enable Active Dataguard, if you want to enable Oracle Active Data Guard.
In the Primary Information tab, specify the VIP of the Associated Network, Listener Port, Database SYS Password, and Backup Encryption Passwords. For high-availability systems, specify the Node 0 VIP of the Associated Network, Node 1 Primary Host Name, and Node 1 VIP of the Associated Network.
In the Standby Information tab, specify the Standby Host Name, VIP of the Associated Network, BUI User, BUI Password, System User, Database Unique Name, Database SYS Password, Listener Port, and Select Transport Type. For high-availability systems, specify the Node 0 Standby Host Name, Node 0 VIP of the Associated Network, Node 1 Standby Host Name, and Node 1 VIP of the Associated Network.
You can add multiple standby Oracle Data Guard configurations. Click Add Standby to add a new standby Oracle Data Guard configuration. A new Standby Information tab is opened for each new standby you add.
For each new standby, specify the Standby Host Name, VIP of the Associated Network, BUI User, BUI Password, System User, Database Unique Name, Database SYS Password, Listener Port, and Select Transport Type. For high-availability systems, specify the Node 0 Standby Host Name, Node 0 VIP of the Associated Network, Node 1 Standby Host Name, and Node 1 VIP of the Associated Network.
Click Save Configuration if you want to save the configuration as a JSON file.
Click Configure and click Yes to confirm. Verify that the job is submitted and completes successfully.

Example JSON for configuring Oracle Data Guard on Oracle Database Appliance

{
  "name": "test1_test7",
  "databaseName": "test",
  "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"
    }
  ]
}

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

odacli Oracle Data Guard Commands

Parent topic: Using Oracle Data Guard for Disaster Management and Recovery on Oracle Database Appliance

Viewing Oracle Data Guard Status on Oracle Database Appliance Using BUI

View Oracle Data Guard status using BUI.

Listing and Viewing Oracle Data Guard Status using BUI

Follow these steps:

Log into the Browser User Interface:
https://host-ip-address:7093/mgmt/index.html
Click Database.
In the Database page, click on the database to view the database details.
In the Database details page, click the Dataguard Associations tab.
The Oracle Data Guard configurations associated with the database are displayed.
To view the status of a specific Oracle Data Guard configuration, from the Actions drop-down list of the Oracle Data Guard configuration, select View.

Related Topics

odacli Oracle Data Guard Commands

Parent topic: Using Oracle Data Guard for Disaster Management and Recovery on Oracle Database Appliance

Performing Oracle Data Guard Operations

Perform failover, switchover, and reinstate operations on Oracle Data Guard using ODACLI commands.

Performing Oracle Data Guard operations using ODACLI commands

Follow these steps:

To switch roles between the primary database and standby database in your Oracle Data Guard configuration, run the following command on the primary system. Specify the standby database unique name with the -u option.
```
# odacli switchover-dataguard -i dg_ID -u standby_db_unique_name_to_switchover
```
For example:
```
# odacli switchover-dataguard -i 75f23ce0-006a-4aeb-ba6d-b4b60275c19 -u test_db2
```
Confirm that the switchover of roles completed successfully:
```
# odacli describe-dataguardstatus -i 75f23ce0-006a-4aeb-ba6d-b4b60275c19
```
A failover provides for transitioning a standby database in your configuration to take over the primary database role, if all instances of an Oracle RAC primary database fail, or are unreachable.
To failover a standby database to the primary database in your Oracle Data Guard configuration, run the following command on your current standby system.
```
# odacli failover-dataguard -i dg_ID -u standby_db_unique_name_to_failover_to
```
For example:
```
# odacli failover-dataguard -i 75f23ce0-006a-4aeb-ba6d-b4b60275c19 -u test_db2
```
Confirm that the requested database failover to the new primary database has completed successfully:
```
# odacli describe-dataguardstatus -i 75f23ce0-006a-4aeb-ba6d-b4b60275c19
```
To reinstate a failed primary database after a failover and convert it to a new standby database in your Oracle Data Guard configuration, run the following command on your new primary system.
```
# odacli reinstate-dataguard -i dg_ID -u db_unique_name_to_reinstate
```
For example:
```
# odacli reinstate-dataguard -i 75f23ce0-006a-4aeb-ba6d-b4b60275c19 -u test_db2
```
Confirm that the requested database is reinstated as a new standby database:
```
# odacli describe-dataguardstatus -i 75f23ce0-006a-4aeb-ba6d-b4b60275c19
```

For more information about these command options, see the Oracle Database Appliance Command Line Reference chapter in this guide.

Related Topics

odacli Oracle Data Guard Commands

Parent topic: Using Oracle Data Guard for Disaster Management and Recovery on Oracle Database Appliance

Performing Oracle Data Guard Operations Using BUI

Perform failover, switchover, and reinstate operations on Oracle Data Guard using BUI.

Performing switchover, failover, and reinstate Oracle Data Guard operations using BUI

Follow these steps:

Log into the Browser User Interface:
https://host-ip-address:7093/mgmt/index.html
Click Database.
In the Database page, click on the database to view the database details.
In the Database details page, click the Dataguard Associations tab. The Oracle Data Guard configurations associated with the database are displayed.
You can perform switchover operation only from the primary Oracle Data Guard Association using the BUI. From the Actions drop-down list of the Oracle Data Guard configuration, select Switchover.
In the Confirmation message, verify the DB Unique Name and Target Database Password, and click Yes.
You can perform failover operation only from the standby Oracle Data Guard Association using the BUI. From the Actions drop-down list of the Oracle Data Guard configuration, select Failover.
In the Confirmation message, verify the DB Unique Name and Target Database Password, and click Yes.
You can perform reinstate operation only from the primary Oracle Data Guard Association using the BUI. To reinstate an Oracle Data Guard configuration, from the Actions drop-down list of the Oracle Data Guard configuration, select Reinstate.
In the Confirmation message, verify the DB Unique Name and Target Database Password, and click Yes.

Related Topics

odacli Oracle Data Guard Commands

Parent topic: Using Oracle Data Guard for Disaster Management and Recovery on Oracle Database Appliance

Creating an Oracle Data Guard Network

Create an Oracle Data Guard network and associate it with a database using ODACLI commands.

Configuring an Oracle Data Guard Network using ODACLI commands

You can configure Oracle Data Guard using a network of type Public, Database, or Dataguard.

Follow these steps:

Create the network:

# odacli create-network -n btbond1 -t VLAN -p 192.209.10.227 -w Dataguard -no-d -s 255.255.255.240 -v 369 -g 192.209.10.225

View the new network:

# odacli list-networks

ID                                     Name                 NIC          Interface Type  Subnet Mask        Gateway            VLAN ID  Node Networks          
-------------------------------------- -------------------- ------------ --------------- ------------------ ------------------ -------- -----------------------
836cfa4b-5d2c-45e3-a62d-099fc7c57984   Private-network      priv0        INTERNAL        255.255.255.240   [ IP Address on node0:  192.168.16.24 ]
1a312239-761d-4321-84d2-8da406f21e5c   Public-network       btbond1.359  VLAN            255.255.255.240    10.209.10.65       359  [ IP Address on node0:  192.209.10.69 ]
f279ac96-5a4a-4b73-86af-1afbdb6ae5d4   vlan369              btbond1.369  VLAN            255.255.255.240    10.209.10.225      369  [ IP Address on node0:  192.209.10.227]

To attach a network of type Dataguard to a database:
```
# odacli modify-database -in test_db -an vlan369
```

For more information about these command options, see the Oracle Database Appliance Command Line Reference chapter in this guide.

Related Topics

odacli Oracle Data Guard Commands

Parent topic: Using Oracle Data Guard for Disaster Management and Recovery on Oracle Database Appliance

Migrating an Oracle Database from One System to Another Using Integrated Oracle Data Guard

Understand how you can use Integrated Oracle Data Guard to migrate an Oracle Database from one system to another.

Migrating Oracle Data Guard Database using ODACLI commands

If your database is on an old Oracle Database Appliance hardware model, and you want to move your deployment to a new Oracle Database Appliance hardware, then you can use your Oracle Data Guard configuration on Oracle Database Appliance to migrate from one system to another. The same steps can also be applied to migrate an Oracle Database from an Oracle Database Appliance bare Metal system to a DB system in a KVM deployment, or from one DB system in a KVM deployment to another DB system.

Before you begin:

Oracle recommends running the primary and the standby databases on separate Oracle Database Appliance hardware, so ensure that you have at least two separate Oracle Database Appliance machines.
The primary and standby systems must be the same Oracle Database Appliance release, and must be on Oracle Database Appliance release 19.8 or later. The instances on the primary and standby databases must have similar configuration for database parameter settings including database version, memory, CPU, networking, and storage (Oracle ASM or Oracle ACFS), thus avoiding any unpredictability when the databases switch roles.
If you have customized the operating system, then ensure that environments on both machines are identical.
Ensure that your deployment follows Oracle Maximum Availability Architecture (MAA) best practices.

Follow these steps:

Take a backup of your primary database to Object Store or External FRA (NFS).
```
# odacli create-backup primary_DB
```
For example:
```
# odacli create-backup --backupType Regular-L0 -in test_db
```
Save the backup report:
```
# odacli describe-backupreport -i eba406c7-ae46-4d1d-a1e5-3e985397b171 > backup_report_test_db_0620.json
```
The backup report ID is the ID of the backup created in step 1 and can be obtained by running the odacli list-backupreports command.

Copy the backup report to the standby system and restore the backup to a standby database.

# odacli irestore-database -ro STANDBY

If your backup option is Object Store, then specify the Object Store location:

# odacli irestore-database -r backup_report.json -u dbUniqueName -on objectStoreName -bp -ro STANDBY -dh
Password for SYS user:
Rman Backup Encryption Password(s). Multiple passwords needs to be comma separated.:

If your backup option is NFS, then specify the NFS location:

odacli irestore-database -r backup_report.json -u dbUniqueName -ro STANDBY
Password for SYS user:

Configure Oracle Data Guard, by running the following command on the primary system:

# /opt/oracle/dcs/bin/odacli configure-dataguard
Number of standby databases (enter 1 or 2 | default: 1):
Standby 1 site address: standby1
BUI username for Standby site standby1. If Multi-user Access/Multi-user Access Passwordless is not enabled on Standby site standby1, enter 'oda-admin'; otherwise, enter the name of the user who has irestored the Standby database (default: oda-admin): oda-admin
BUI password for Standby site standby1:
Password for root user on Standby site standby1:
 
*******************************************************************************************
Data Guard configuration name: tdb_dg
Database name for Data Guard configuration: tdb
Primary database SYS password:
Protection mode [MAX_PROTECTION, MAX_PERFORMANCE, MAX_AVAILABILITY] (default: MAX_PERFORMANCE):
Enable Active Data Guard (Y/N, default:N):
*******************************************************************************************
 
Data Guard default settings for standby database - tdbstndby
Primary site network for Data Guard configuration: Public-network
Standby site network for Data Guard configuration: Public-network
Primary database listener port (TCP): 1521
Standby database listener port (TCP): 1521
Transport type: ASYNC
Do you want to edit this Data Guard configuration? (Y/N, default:N): N
*******************************************************************************************
Enter Primary database RMAN backup encryption password if any:
Do you want to provide another Primary database RMAN backup encryption password if any? [y/n] (default 'n'):
Standby database's SYS password will be set to Primary database's after Data Guard configuration. Ignore warning and proceed with Data Guard configuration? (Y/N, default:N): Y
{
  "jobId" : "e02cc0b3-bce3-4d6c-a1f5-5b121bb7f66a",
  "status" : "Created",
  "message" : "",
  "reports" : [ ],
  "createTimestamp" : "January 23, 2025 03:12:44 AM UTC",
  "resourceList" : [ ],
  "description" : "DG Config service for DB tdb",
  "updatedTime" : "January 23, 2025 03:12:44 AM UTC",
  "jobType" : null,
  "cpsMetadata" : null
}
 
[root@phxdbfzp22 work]# /opt/oracle/dcs/bin/odacli describe-job -i e02cc0b3-bce3-4d6c-a1f5-5b121bb7f66a
 
Job details                                                     
----------------------------------------------------------------
                     ID:  e02cc0b3-bce3-4d6c-a1f5-5b121bb7f66a
            Description:  DG Config service for DB tdb
                 Status:  Success
                Created:  January 23, 2025 03:12:44 UTC
                Message: 
 
Task Name                                Start Time                               End Time                                 Status         
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------------
Validate configure primary request       January 23, 2025 03:13:10 UTC            January 23, 2025 03:13:21 UTC            Success        
(Primary site) (Host: phxdbfzp22/Job                                                                                                      
ID:                                                                                                                                       
901389f5-0cad-4ee6-91be-3f77b85652af)                                                                                                     
Validate configure standby request       January 23, 2025 03:13:21 UTC            January 23, 2025 03:13:29 UTC            Success        
(Standby site) (Host:                                                                                                               host1/Job ID:                                                                                                                    
856d86e4-dd51-41a7-9050-b0c39ae771f9)                                                                                                     
Uploading Primary DB Password File       January 23, 2025 03:13:29 UTC            January 23, 2025 03:13:52 UTC            Success        
(Standby site)                                                                                                                            
Configure primary database (Primary      January 23, 2025 03:13:52 UTC            January 23, 2025 03:15:29 UTC            Success        
site) (Host: phxdbfzp22/Job ID:                                                                                                           
5dd46e86-e07f-423f-9ebf-2515b4ac17d5)                                                                                                     
Configure standby request (Standby       January 23, 2025 03:15:29 UTC            January 23, 2025 03:17:30 UTC            Success        
site) (Host:                                                                                                                              
host1/Job ID:                                                                                                                    
2ab511a2-15c0-4371-bf30-9b7e27ff5288)                                                                                                     
Create archive log restore (Primary      January 23, 2025 03:17:30 UTC            January 23, 2025 03:17:52 UTC            Success        
site) (Host: phxdbfzp22/Job ID:                                                                                                           
96766874-6537-4972-81a9-971440e2acfb)                                                                                                     
Configure and enable Data Guard          January 23, 2025 03:17:53 UTC            January 23, 2025 03:19:19 UTC            Success        
(Primary site) (Host: phxdbfzp22/Job                                                                                                      
ID:                                                                                                                                       
7ad65ffa-ea06-479d-bb21-e0b81fb8c743)                                                                                                     
Enable Flashback (Standby site) (Host:   January 23, 2025 03:19:19 UTC            January 23, 2025 03:19:38 UTC            Success        
host1/Job ID:                                                                                                                    
a1768703-4dd4-4f1f-b9a3-9fe0f99615d5)                                                                                                     
Re-enable Data Guard (Primary site)      January 23, 2025 03:19:38 UTC            January 23, 2025 03:19:44 UTC            Success        
(Host: phxdbfzp22/Job ID:                                                                                                                 
3f6dd276-63e3-4804-a179-e10052386206)                                                                                                     
Create Data Guard status (Primary        January 23, 2025 03:19:44 UTC            January 23, 2025 03:19:49 UTC            Success        
site) (Host: phxdbfzp22/Job ID:                                                                                                           
8a3eb946-3501-4618-9d4a-ad8a6d298cc8)                                                                                                     
Create Data Guard status (Standby        January 23, 2025 03:19:49 UTC            January 23, 2025 03:19:57 UTC            Success        
site) (Host:                                                                                                                              
host1/Job ID:                                                                                                                    
d9d65942-6284-40d5-a991-b1d21edae96f)

Check the status of Oracle Data Guard and ensure it is working:
```
# odacli describe-dataguardstatus -i dataguard_configuration_ID
```

Switch over to the standby database:

# odacli switchover-dataguard -i 75f23ce0-006a-4aeb-ba6d-b4b60275c19 -u houdg02

Deconfigure Oracle Data Guard. The process also deletes the standby database on the old Oracle Database Appliance hardware machine.

# /opt/oracle/dcs/bin/odacli deconfigure-dataguard --id "ee22f382-b04e-4658-a6c7-ab00fc7e3270"
Number of standby databases (enter 1 or 2 | default: 1):
Standby 1 site address: standby1
BUI username for Standby site standby1. If Multi-user Access/Multi-user Access Passwordless is not enabled on Standby site standby1, enter 'oda-admin'; otherwise, enter the name of the user who has irestored the Standby database (default: oda-admin): oda-admin
BUI password for Standby site standby1:
Password for root user on Standby site standby1:
Standby database will be deleted after Data Guard configuration is removed. Ignore warning and proceed with Data Guard deconfiguration? (Y/N): Y
{
  "jobId" : "0613c649-3da6-463a-8359-2f6d7d17399b",
  "status" : "Created",
  "message" : "",
  "reports" : [ ],
  "createTimestamp" : "January 23, 2025 03:42:41 AM UTC",
  "resourceList" : [ ],
  "description" : "DG Deconfig service",
  "updatedTime" : "January 23, 2025 03:42:41 AM UTC",
  "jobType" : null,
  "cpsMetadata" : null
}
 
[root@phxdbfzp22 work]# /opt/oracle/dcs/bin/odacli describe-job -i 0613c649-3da6-463a-8359-2f6d7d17399b
 
Job details                                                     
----------------------------------------------------------------
                     ID:  0613c649-3da6-463a-8359-2f6d7d17399b
            Description:  DG Deconfig service
                 Status:  Success
                Created:  January 23, 2025 03:42:41 UTC
                Message: 
 
Task Name                                Start Time                               End Time                                 Status         
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------------
De-configure Dataguard (Primary site)    January 23, 2025 03:42:44 UTC            January 23, 2025 03:44:22 UTC            Success        
(Host: phxdbfzp22/Job ID:                                                                                                                 
93758e42-2cf4-4aa1-949e-b6018c1c35d7)                                                                                                     
Delete Dataguard Status(Primary site)    January 23, 2025 03:44:22 UTC            January 23, 2025 03:44:28 UTC            Success        
(Host: phxdbfzp22/Job ID:                                                                                                                 
e090af71-9c6d-4d14-8e16-3c64c4aa7f14)                                                                                                     
Delete Dataguard Status(Standby site)    January 23, 2025 03:44:28 UTC            January 23, 2025 03:44:36 UTC            Success        
(Host:                                                                                                                                    
host1/Job ID:                                                                                                                    
a5bf022a-c1ca-4c1a-8747-4ff6a0e938c0)                                                                                                     
Delete Standby Database (Standby site)   January 23, 2025 03:44:36 UTC            January 23, 2025 03:46:07 UTC            Success        
(Host:                                                                                                                                    
host1/Job ID:                                                                                                                    
f93b1f26-69d9-4690-84f9-4c0c9947423a)

For more information about these command options, see the Oracle Database Appliance Command Line Reference chapter in this guide.

Related Topics

odacli Oracle Data Guard Commands

Parent topic: Using Oracle Data Guard for Disaster Management and Recovery on Oracle Database Appliance

Patching Oracle Data Guard Databases on Oracle Database Appliance

Understand how you can patch primary and standby databases on Oracle Data Guard using ODACLI commands.

Prerequisites for patching Oracle Data Guard primary and standby databases using ODACLI commands

Before patching the database homes, upload the Oracle Database clone files for the database version, to the repository. See Updating Oracle Database Appliance Repository with Database Clone Files Using the CLI for the procedure to update the repository with the latest Oracle Database clone files. Also ensure that the primary Oracle Database Appliance system and the standby Oracle Database Appliance system are on the same Oracle Database Appliance release. It is recommended that the two systems be on the latest Oracle Database Appliance release. See Patching Oracle Database Appliance Bare Metal Systems Using the Command-Line for the procedure to patch your Oracle Database Appliance deployment.

Important:

Patch the standby database on Oracle Database Appliance first, before patching the primary database to ensure that all functions are updated correctly.

Patching the standby first may affect Oracle Active Data Guard OJVM functionality. Hence, ensure that you patch the standby system first, and then patch the primary system immediately after that.

Patching Oracle Data Guard primary and standby databases using odacli update-database command

You can use the odacli update-database command to update the databases in your Oracle Data Guard configuration. Follow these steps for patching databases in your Oracle Data Guard configuration:

Patching workflow with primary database A and standby database B:

Create prepatch report for database B:

# odacli create-prepatchreport -db -dbid databaseId -to dbhomeid

Update standby database B:

# odacli update-database -i databaseId -to dbhomeId

Switch roles between the primary database and standby database in your Oracle Data Guard configuration, by running the following command on the primary system:
```
# odacli switchover-dataguard -i dgid -u db_A
```

Create prepatch report for database A:

# odacli create-prepatchreport -db -dbid databaseId -to dbhomeid

Update database A:

# odacli update-database -i databaseId -to dbhomeid

Switch roles again between the primary database and standby database in your Oracle Data Guard configuration, by running the following command on the primary system:
```
# odacli switchover-dataguard -i dgid -u db_A
```
Create a prepatch report for the datapatch for database A:
```
# odacli create-prepatchreport -dp -dbid databaseId 
```
Apply datapatch on database A:
```
# odacli update-database -i databaseId -dp 
```

For more information about these command options, see the Oracle Database Appliance Command Line Reference chapter in this guide.

Patching Oracle Data Guard primary and standby databases using odacli update-dbhome command

Follow these steps to patch the databases in your Oracle Data Guard configuration on Oracle Database Appliance:

Run the following command on the standby database:
```
# odacli update-dbhome
```
After patching job on the standby database is successful, run the following command on the primary database:
```
# odacli update-dbhome
```
Confirm that the patching jobs are successful:
```
# /opt/oracle/dcs/bin/odacli list-jobs
```
Confirm the existing Data Guard configuration is working properly by running the following command on both primary and standby systems:
```
odacli describe-dataguardstatus -i dgid
```

For more information about these command options, see the Oracle Database Appliance Command Line Reference chapter in this guide.

Parent topic: Using Oracle Data Guard for Disaster Management and Recovery on Oracle Database Appliance

Enabling Oracle Active Data Guard on Existing Configurations

Understand how you can enable Oracle Active Data Guard on existing configurations.

Oracle Active Data Guard is licensed option to the Oracle Database Enterprise Edition and enables advanced capabilities that extend the basic Oracle Data Guard functionality.

Oracle Active Data Guard function requires database to be open as read-only while enabling the redo log apply option. Follow these steps to enable Oracle Active Data Guard on existing configurations:

Modify database to have read-only start option:

srvctl modify database -d standby_db_unique_name -startoption "read only" 
srvctl stop database -d standby_db_unique_name 
srvctl start database -d standby_db_unique_name

To check if Oracle Data Guard has read-only start option set, run the following command:

srvctl config database -d standby_db_unique_name | grep "Start options"

Enable redo log apply by running the following PL/SQL commands:

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; 
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Parent topic: Using Oracle Data Guard for Disaster Management and Recovery on Oracle Database Appliance

Registering Oracle Data Guard on Oracle Database Appliance Using ODACLI Commands

Oracle Database Appliance enables you to migrate Oracle Data Guard configuration that were manually configured, and register the configuration metadata with Oracle Database Appliance using ODACLI commands.

Prerequisites for Oracle Database Guard Registration

Before you begin:

Oracle recommends running the primary and the standby databases on separate Oracle Database Appliance hardware, so ensure that you have at least two separate Oracle Database Appliance machines.
Oracle recommends that the primary and standby systems have the same Oracle Database Appliance configuration. The database must have identical configuration for database version and storage, that is, they must have either Oracle ASM or Oracle ACFS storage, to avoid any unpredictability with the database switch roles.
The primary and standby systems must be the same Oracle Database Appliance release, and must be on Oracle Database Appliance release 19.22 or later.
If you have customized the operating system, then ensure that environments on the systems are identical.
Ensure that your deployment follows Oracle Maximum Availability Architecture (MAA) best practices. See the Oracle Maximum Availability Architecture (MAA) page on Oracle Technology Network.

Registering Oracle Data Guard using ODACLI commands

Follow these steps:

Register Oracle Data Guard with Oracle Database Appliance, in one of the following ways:

Register Oracle Data Guard using interactive mode:

[root@node1 ~]# odacli register-dataguard
Number of standby databases (enter 1 or 2 | default: 1): 2
Standby 1 site address: host2
BUI username for Standby site host2. If Multi-user Access/Multi-user Access Passwordless is not enabled on Standby site host2, enter 'oda-admin'; otherwise, enter the name of the user who has irestored the Standby database (default: oda-admin):
BUI password for Standby site host2:
Password for root user on Standby site host2:
Standby 2 site address: host3
BUI username for Standby site host3. If Multi-user Access/Multi-user Access Passwordless is not enabled on Standby site host1, enter 'oda-admin'; otherwise, enter the name of the user who has irestored the Standby database (default: oda-admin):
BUI password for Standby site host3:
Password for root user on Standby site host3:
   
*******************************************************************************************
Data Guard configuration name: books_dgconf
Database name for Data Guard configuration: books
Primary database SYS password:
Protection mode [MAX_PROTECTION, MAX_PERFORMANCE, MAX_AVAILABILITY] (default: MAX_PERFORMANCE):
*******************************************************************************************
   
Data Guard default settings for standby database - books_u1
Primary site network for Data Guard configuration: Public-network
Standby site network for Data Guard configuration: Public-network
Primary database listener port (TCP): 1521
Standby database listener port (TCP): 1521
Transport type: ASYNC
For standby 'books_u1', does the above Data Guard configuration match your actual configuration? (Y/N, default:N): y
   
Data Guard default settings for standby database - books_u2
Primary site network for Data Guard configuration: Public-network
Standby site network for Data Guard configuration: Public-network
Primary database listener port (TCP): 1521
Standby database listener port (TCP): 1521
Transport type: ASYNC
For standby 'books_u2', does the above Data Guard configuration match your actual configuration? (Y/N, default:N): y
{
  "jobId" : "525d4c0d-5d4c-401b-9d7a-add15e1057a5",
  "status" : "Created",
  "message" : "",
  "reports" : [ ],
  "createTimestamp" : "December 15, 2024 03:22:40 AM MSK",
  "resourceList" : [ ],
  "description" : "Register Dataguard service for DB a9cca840-d5f6-4c52-8136-10668ce88c69",
  "updatedTime" : "December 15, 2024 03:22:40 AM MSK",
  "jobType" : null,
  "cpsMetadata" : null
}
   
[root@host1 ~]# odacli describe-job -i 525d4c0d-5d4c-401b-9d7a-add15e1057a5
   
Job details                                                   
----------------------------------------------------------------
                     ID:  525d4c0d-5d4c-401b-9d7a-add15e1057a5
            Description:  Register Dataguard service for DB a9cca840-d5f6-4c52-8136-10668ce88c69
                 Status:  Success
                Created:  December 15, 2024 03:22:40 MSK
                Message:
   
Task Name                                Node Name                 Start Time                               End Time                                 Status       
---------------------------------------- ------------------------- ---------------------------------------- ---------------------------------------- ----------------
Validate register dataguard primary      host1             December 15, 2024 03:23:45 MSK           December 15, 2024 03:24:20 MSK           Success      
request (Primary site) (Host:                                                                                                                                     
host1/Job ID:                                                                                                                                             
e11da95d-e00e-41b3-9894-8dd7a9ffceb9)                                                                                                                             
Validate register dataguard standby      host1             December 15, 2024 03:24:20 MSK           December 15, 2024 03:25:05 MSK           Success      
request (Standby site) (Host:                                                                                                                                     
host2/Job ID:                                                                                                                                             
6e566598-700c-4154-8056-853df67d15b3)                                                                                                                             
Validate register dataguard standby      host1             December 15, 2024 03:25:05 MSK           December 15, 2024 03:25:45 MSK           Success      
request (Standby site) (Host:                                                                                                                                     
host1/Job ID:                                                                                                                                            
11330cdd-ccdf-4e05-acf8-2885418a9efc)                                                                                                                             
Create Data Guard status (Primary        host1             December 15, 2024 03:25:45 MSK           December 15, 2024 03:26:07 MSK           Success      
site) (Host: host1/Job ID:                                                                                                                                
a779a3d6-709a-4a1c-a649-9fbf373624ed)                                                                                                                             
Create Data Guard status (Standby        host1             December 15, 2024 03:26:07 MSK           December 15, 2024 03:26:34 MSK           Success      
site) (Host: host2/Job ID:                                                                                                                                
9233aea0-021a-4790-b359-60de42d50526)                                                                                                                             
Create Data Guard status (Standby        host1             December 15, 2024 03:26:34 MSK           December 15, 2024 03:27:01 MSK           Success      
site) (Host: host1/Job ID:                                                                                                                               
79f7ec79-fb43-4f57-8f05-da37afbe275b)

Oracle Data Guard status on the primary system:

# odacli list-dataguardstatus
Updated about 2 minute(s) ago
It can take up to several minutes to update Data Guard status. You can re-run the command to obtain the latest status.
ID                                       Name                             Database Name        Role       Protection Mode     Status 
---------------------------------------- -------------------------------- -------------------- ---------- ------------------ ----------
a3543f5a-63a8-42c3-abcc-a8e180a1dd25     books_dgconf                     books                PRIMARY    MAX_PERFORMANCE    CONFIGURED
[root@host1_node1 ~]# odacli list-dataguardstatus -j
[ {
  "id" : "a3543f5a-63a8-42c3-abcc-a8e180a1dd25",
  "name" : "books_dgconf",
  "databaseId" : "a9cca840-d5f6-4c52-8136-10668ce88c69",
  "protectionMode" : "MAX_PERFORMANCE",
  "role" : "PRIMARY",
  "replicationGroups" : [ {
    "sourceEndPoints" : [ {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "n1",
      "listenerPort" : 1521,
      "serviceName" : "test_service",
      "sysPassword" : null,
      "openMode" : "READ WRITE",
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.xx.xxx.xxx",
      "hostName" : "host2",
      "listenerPort" : 1521,
      "serviceName" : "test_service",
      "sysPassword" : null,
      "openMode" : "READ WRITE",
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "targetEndPoints" : [ {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u1",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "n2",
      "listenerPort" : 1521,
      "serviceName" : "test_service",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u1",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "test_service",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "transportType" : "ASYNC",
    "applyLag" : "0 seconds",
    "transportLag" : "0 seconds",
    "approximateRoleTransitionTime" : "30 seconds",
    "applyRate" : "12.00 KByte/s"
  }, {
    "sourceEndPoints" : [ {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "n1",
      "listenerPort" : 1521,
      "serviceName" : "test_service",
      "sysPassword" : null,
      "openMode" : "READ WRITE",
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.x.xx.xxx",
      "hostName" : "host2",
      "listenerPort" : 1521,
      "serviceName" : "test_service",
      "sysPassword" : null,
      "openMode" : "READ WRITE",
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "targetEndPoints" : [ {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u2",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "host1",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u2",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "host1",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "transportType" : "ASYNC",
    "applyLag" : "0 seconds",
    "transportLag" : "0 seconds",
    "approximateRoleTransitionTime" : "30 seconds",
    "applyRate" : "5.00 KByte/s"
  } ],
  "observers" : [ ],
  "createTime" : "December 15, 2024 03:25:48 AM MSK",
  "state" : {
    "status" : "CONFIGURED"
  },
  "updatedTime" : "December 15, 2024 03:26:06 AM MSK"
} ]
   
[root@host1_node2 ~]# odacli list-dataguardstatus -j
[ {
  "id" : "a3543f5a-63a8-42c3-abcc-a8e180a1dd25",
  "name" : "books_dgconf",
  "databaseId" : "a9cca840-d5f6-4c52-8136-10668ce88c69",
  "protectionMode" : "MAX_PERFORMANCE",
  "role" : "PRIMARY",
  "replicationGroups" : [ {
    "sourceEndPoints" : [ {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "n1",
      "listenerPort" : 1521,
      "serviceName" : "test_service",
      "sysPassword" : null,
      "openMode" : "READ WRITE",
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host2",
      "listenerPort" : 1521,
      "serviceName" : "test_service",
      "sysPassword" : null,
      "openMode" : "READ WRITE",
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "targetEndPoints" : [ {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u1",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "n2",
      "listenerPort" : 1521,
      "serviceName" : "test_service",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u1",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "test_service",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "transportType" : "ASYNC",
    "applyLag" : "0 seconds",
    "transportLag" : "0 seconds",
    "approximateRoleTransitionTime" : "30 seconds",
    "applyRate" : "12.00 KByte/s"
  }, {
    "sourceEndPoints" : [ {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "n1",
      "listenerPort" : 1521,
      "serviceName" : "test_service",
      "sysPassword" : null,
      "openMode" : "READ WRITE",
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host2",
      "listenerPort" : 1521,
      "serviceName" : "test_service",
      "sysPassword" : null,
      "openMode" : "READ WRITE",
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "targetEndPoints" : [ {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u2",
      "ipAddress" : "x.xx.xxx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "host1",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u2",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "host1",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "transportType" : "ASYNC",
    "applyLag" : "0 seconds",
    "transportLag" : "0 seconds",
    "approximateRoleTransitionTime" : "30 seconds",
    "applyRate" : "5.00 KByte/s"
  } ],
  "observers" : [ ],
  "createTime" : "December 15, 2024 03:25:48 AM MSK",
  "state" : {
    "status" : "CONFIGURED"
  },
  "updatedTime" : "December 15, 2024 03:26:06 AM MSK"
} ]

Oracle Data Guard status on the first standby system:

# odacli list-dataguardstatus
Updated about 3 minute(s) ago
It can take up to several minutes to update Data Guard status. You can re-run the command to obtain the latest status.
ID                                       Name                             Database Name        Role       Protection Mode     Status 
---------------------------------------- -------------------------------- -------------------- ---------- ------------------ ----------
a3543f5a-63a8-42c3-abcc-a8e180a1dd25     books_dgconf                     books                STANDBY    MAX_PERFORMANCE    CONFIGURED
[root@host2_node1 ~]# odacli list-dataguardstatus -j
[ {
  "id" : "a3543f5a-63a8-42c3-abcc-a8e180a1dd25",
  "name" : "books_dgconf",
  "databaseId" : "d2ccb22b-3e31-47cb-967c-1f1fdefea54e",
  "protectionMode" : "MAX_PERFORMANCE",
  "role" : "STANDBY",
  "replicationGroups" : [ {
    "sourceEndPoints" : [ {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "targetEndPoints" : [ {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u1",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : "MOUNTED",
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u1",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : "MOUNTED",
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "transportType" : "ASYNC",
    "applyLag" : "0 seconds",
    "transportLag" : "0 seconds",
    "approximateRoleTransitionTime" : "30 seconds",
    "applyRate" : "11.00 KByte/s"
  }, {
    "sourceEndPoints" : [ {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "targetEndPoints" : [ {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u2",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u2",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "transportType" : "ASYNC",
    "applyLag" : "0 seconds",
    "transportLag" : "0 seconds",
    "approximateRoleTransitionTime" : "30 seconds",
    "applyRate" : "5.00 KByte/s"
  } ],
  "observers" : [ ],
  "createTime" : "December 15, 2024 00:26:21 AM GMT",
  "state" : {
    "status" : "CONFIGURED"
  },
  "updatedTime" : "December 15, 2024 00:26:31 AM GMT"
} ]
   
[root@host2_node2 bin]# odacli list-dataguardstatus
Updated about 5 minute(s) ago
It can take up to several minutes to update Data Guard status. You can re-run the command to obtain the latest status.
ID                                       Name                             Database Name        Role       Protection Mode     Status 
---------------------------------------- -------------------------------- -------------------- ---------- ------------------ ----------
a3543f5a-63a8-42c3-abcc-a8e180a1dd25     books_dgconf                     books                STANDBY    MAX_PERFORMANCE    CONFIGURED
[root@scaoda603c4n2 bin]# odacli list-dataguardstatus -j
[ {
  "id" : "a3543f5a-63a8-42c3-abcc-a8e180a1dd25",
  "name" : "books_dgconf",
  "databaseId" : "d2ccb22b-3e31-47cb-967c-1f1fdefea54e",
  "protectionMode" : "MAX_PERFORMANCE",
  "role" : "STANDBY",
  "replicationGroups" : [ {
    "sourceEndPoints" : [ {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "targetEndPoints" : [ {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u1",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : "MOUNTED",
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u1",
      "ipAddress" : "10.32.202.58",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : "MOUNTED",
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "transportType" : "ASYNC",
    "applyLag" : "0 seconds",
    "transportLag" : "0 seconds",
    "approximateRoleTransitionTime" : "30 seconds",
    "applyRate" : "11.00 KByte/s"
  }, {
    "sourceEndPoints" : [ {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "targetEndPoints" : [ {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u2",
      "ipAddress" : "10.32.202.9",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u2",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "transportType" : "ASYNC",
    "applyLag" : "0 seconds",
    "transportLag" : "0 seconds",
    "approximateRoleTransitionTime" : "30 seconds",
    "applyRate" : "5.00 KByte/s"
  } ],
  "observers" : [ ],
  "createTime" : "December 15, 2024 00:26:21 AM GMT",
  "state" : {
    "status" : "CONFIGURED"
  },
  "updatedTime" : "December 15, 2024 00:26:31 AM GMT"
} ]

Oracle Data Guard status on the second standby system:

# odacli list-dataguardstatus
Updated about 3 minute(s) ago
It can take up to several minutes to update Data Guard status. You can re-run the command to obtain the latest status.
ID                                       Name                             Database Name        Role       Protection Mode     Status 
---------------------------------------- -------------------------------- -------------------- ---------- ------------------ ----------
a3543f5a-63a8-42c3-abcc-a8e180a1dd25     books_dgconf                     books                STANDBY    MAX_PERFORMANCE    CONFIGURED
[root@scaoda603c4n1 ~]# odacli list-dataguardstatus -j
[ {
  "id" : "a3543f5a-63a8-42c3-abcc-a8e180a1dd25",
  "name" : "books_dgconf",
  "databaseId" : "d2ccb22b-3e31-47cb-967c-1f1fdefea54e",
  "protectionMode" : "MAX_PERFORMANCE",
  "role" : "STANDBY",
  "replicationGroups" : [ {
    "sourceEndPoints" : [ {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "targetEndPoints" : [ {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u1",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : "MOUNTED",
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u1",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : "MOUNTED",
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "transportType" : "ASYNC",
    "applyLag" : "0 seconds",
    "transportLag" : "0 seconds",
    "approximateRoleTransitionTime" : "30 seconds",
    "applyRate" : "11.00 KByte/s"
  }, {
    "sourceEndPoints" : [ {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "targetEndPoints" : [ {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u2",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u2",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "transportType" : "ASYNC",
    "applyLag" : "0 seconds",
    "transportLag" : "0 seconds",
    "approximateRoleTransitionTime" : "30 seconds",
    "applyRate" : "5.00 KByte/s"
  } ],
  "observers" : [ ],
  "createTime" : "December 15, 2024 00:26:21 AM GMT",
  "state" : {
    "status" : "CONFIGURED"
  },
  "updatedTime" : "December 15, 2024 00:26:31 AM GMT"
} ]
   
[root@host3_node2 bin]# odacli list-dataguardstatus
Updated about 5 minute(s) ago
It can take up to several minutes to update Data Guard status. You can re-run the command to obtain the latest status.
ID                                       Name                             Database Name        Role       Protection Mode     Status 
---------------------------------------- -------------------------------- -------------------- ---------- ------------------ ----------
a3543f5a-63a8-42c3-abcc-a8e180a1dd25     books_dgconf                     books                STANDBY    MAX_PERFORMANCE    CONFIGURED
[root@scaoda603c4n2 bin]# odacli list-dataguardstatus -j
[ {
  "id" : "a3543f5a-63a8-42c3-abcc-a8e180a1dd25",
  "name" : "books_dgconf",
  "databaseId" : "d2ccb22b-3e31-47cb-967c-1f1fdefea54e",
  "protectionMode" : "MAX_PERFORMANCE",
  "role" : "STANDBY",
  "replicationGroups" : [ {
    "sourceEndPoints" : [ {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "targetEndPoints" : [ {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u1",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : "MOUNTED",
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u1",
      "ipAddress" : "10.32.202.58",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : "MOUNTED",
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "transportType" : "ASYNC",
    "applyLag" : "0 seconds",
    "transportLag" : "0 seconds",
    "approximateRoleTransitionTime" : "30 seconds",
    "applyRate" : "11.00 KByte/s"
  }, {
    "sourceEndPoints" : [ {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "books",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "targetEndPoints" : [ {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u2",
      "ipAddress" : "10.32.202.9",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    }, {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "books_u2",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host_name",
      "listenerPort" : 1521,
      "serviceName" : "service_name",
      "sysPassword" : null,
      "openMode" : null,
      "state" : {
        "status" : "ENABLED"
      }
    } ],
    "transportType" : "ASYNC",
    "applyLag" : "0 seconds",
    "transportLag" : "0 seconds",
    "approximateRoleTransitionTime" : "30 seconds",
    "applyRate" : "5.00 KByte/s"
  } ],
  "observers" : [ ],
  "createTime" : "December 15, 2024 00:26:21 AM GMT",
  "state" : {
    "status" : "CONFIGURED"
  },
  "updatedTime" : "December 15, 2024 00:26:31 AM GMT"
} ]

Register Oracle Data Guard with two standby systems with JSON file:

[root@node1 ~]# odacli register-dataguard -r advregdg.json
Number of standby databases (enter 1 or 2 | default: 1): 2
Standby 1 site address: host2
BUI username for Standby site host2. If Multi-user Access/Multi-user Access Passwordless is not enabled on Standby site host2, enter 'oda-admin'; otherwise, enter the name of the user who has irestored the Standby database (default: oda-admin): u1
BUI password for Standby site host2. If Multi-user Access Passwordless is enabled on Standby site, copy the cwallet.sso file from Standby site (/opt/oracle/dcs/conf/dcspublickey_wallet/) to Primary site (/root/). Rename the file to 'cwallet.sso.host2', set the file ownership (root:root) and file permission (0440) and then press enter:
Standby 2 site address: host3
BUI username for Standby site host3. If Multi-user Access/Multi-user Access Passwordless is not enabled on Standby site host3, enter 'oda-admin'; otherwise, enter the name of the user who has irestored the Standby database (default: oda-admin): usr1
BUI password for Standby site host3. If Multi-user Access Passwordless is enabled on Standby site, copy the cwallet.sso file from Standby site (/opt/oracle/dcs/conf/dcspublickey_wallet/) to Primary site (/root/). Rename the file to 'cwallet.sso.host3', set the file ownership (root:root) and file permission (0440) and then press enter:
Primary database SYS password:
{
  "jobId" : "5c4be2a3-5892-4482-9549-e47005f05548",
  "status" : "Created",
  "message" : "",
  "reports" : [ ],
  "createTimestamp" : "December 19, 2024 01:13:42 AM UYT",
  "resourceList" : [ ],
  "description" : "Register Dataguard service for DB 0f56f07e-a1e5-4c88-a535-4cfc7858a80a",
  "updatedTime" : "December 19, 2024 01:13:42 AM UYT",
  "jobType" : null,
  "cpsMetadata" : null
}
[root@host2 ~]# odacli describe-job -i 5c4be2a3-5892-4482-9549-e47005f05548
  
Job details                                                    
----------------------------------------------------------------
                     ID:  5c4be2a3-5892-4482-9549-e47005f05548
            Description:  Register Dataguard service for DB 0f56f07e-a1e5-4c88-a535-4cfc7858a80a
                 Status:  Success
                Created:  December 19, 2024 01:13:42 UYT
                Message:
  
Task Name                                Start Time                               End Time                                 Status        
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------------
Validate register dataguard primary      December 19, 2024 01:13:58 UYT           December 19, 2024 01:14:15 UYT           Success       
request (Primary site) (Host:                                                                                                            
host2/Job ID:                                                                                                                  
6e0cdfbd-69f8-442c-be4a-73937e67b938)                                                                                                    
Validate register dataguard standby      December 19, 2024 01:14:15 UYT           December 19, 2024 01:14:35 UYT           Success       
request (Standby site) (Host:                                                                                                            
host2/Job ID:                                                                                                                  
f505eec8-533d-4a80-9edc-34ec16008167)                                                                                                    
Validate register dataguard standby      December 19, 2024 01:14:35 UYT           December 19, 2024 01:15:01 UYT           Success       
request (Standby site) (Host:                                                                                                            
host2/Job ID:                                                                                                                  
3d8e79e9-15ab-4d7d-ba92-2f3d0e73852b)                                                                                                    
Create Data Guard status (Primary        December 19, 2024 01:15:01 UYT           December 19, 2024 01:15:07 UYT           Success       
site) (Host: host2/Job ID:                                                                                                     
87591524-9ec4-42f6-ae3a-1b5eddf4945d)                                                                                                    
Create Data Guard status (Standby        December 19, 2024 01:15:07 UYT           December 19, 2024 01:15:15 UYT           Success       
site) (Host: host2/Job ID:                                                                                                     
4705752a-24b7-41b5-b2e5-2c64f6eac3c4)                                                                                                    
Create Data Guard status (Standby        December 19, 2024 01:15:15 UYT           December 19, 2024 01:15:23 UYT           Success       
site) (Host: host2/Job ID:                                                                                                     
0c7553ba-0f53-49f3-9f7f-8128f7d47e30)
 
{
  "name" : "dgconf_c2",
  "protectionMode" : "MAX_AVAILABILITY",
  "replicationGroups" : [ {
    "sourceEndPoints" : [ {
     "endpointType" : "PRIMARY",
      "databaseUniqueName" : "c2",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host2",
      "listenerPort" : 1521,
      "serviceName" : "c2",
      "sysPassword" : null
    } ],
    "targetEndPoints" : [ {
     "endpointType" : "STANDBY",
      "databaseUniqueName" : "c2t_2",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "c2t_2",
      "listenerPort" : 1521,
      "serviceName" : "c2t_2",
      "sysPassword" : null
    } ],
    "transportType" : "SYNC"
  }, {
  "sourceEndPoints" : [ {
     "endpointType" : "PRIMARY",
      "databaseUniqueName" : "c2",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host2",
      "listenerPort" : 1521,
      "serviceName" : "c2",
      "sysPassword" : null
    } ],
    "targetEndPoints" : [ {
       "endpointType" : "STANDBY",
      "databaseUniqueName" : "c2t_1",
      "ipAddress" : "xx.xx.xx.xx",
      "hostName" : "host2",
      "listenerPort" : 1521,
      "serviceName" : "c2t_1",
      "sysPassword" : null
    } ],
    "transportType" : "FASTSYNC"
  }]
}

For more information about these command options, see the Oracle Database Appliance Command Line Reference chapter in this guide.

Related Topics

https://www.oracle.com/in/database/technologies/high-availability/maa.html

Parent topic: Using Oracle Data Guard for Disaster Management and Recovery on Oracle Database Appliance

Registering Oracle Data Guard on Oracle Database Appliance Using BUI

Oracle Database Appliance enables you to migrate Oracle Data Guard configuration that were manually configured, and register the configuration metadata with Oracle Database Appliance using BUI.

Prerequisites for Oracle Database Guard Registration

Before you begin:

Oracle recommends running the primary and the standby databases on separate Oracle Database Appliance hardware, so ensure that you have at least two separate Oracle Database Appliance systems.
Oracle recommends that the primary and standby systems have the same Oracle Database Appliance configuration. The database must have identical configuration for database version and storage, that is, they must have either Oracle ASM or Oracle ACFS storage, to avoid any unpredictability with the database switch roles.
The primary and standby systems must be the same Oracle Database Appliance release, and must be on Oracle Database Appliance release 19.26 or later.
If you have customized the operating system, then ensure that environments on the systems are identical.
Ensure that your deployment follows Oracle Maximum Availability Architecture (MAA) best practices. See the Oracle Maximum Availability Architecture (MAA) page on Oracle Technology Network.

Registering Oracle Data Guard using BUI

Follow these steps:

Log into the Browser User Interface:
https://host-ip-address:7093/mgmt/index.html
Click Database.
In the Database page, click on the database to view the database details.
In the Database details page, click the Dataguard Associations tab. The Oracle Data Guard configurations associated with the database are displayed.
To register an Oracle Data Guard configuration, click Register.
In the System Information tab, you can use a JSON file to provide the Oracle Data Guard configuration values or specify the values for each field.
To register Oracle Data Guard using JSON file, in the System Information tab, click Browse and load the configuration.
Or, specify the Dataguard Configuration Name and Select Protection Mode. The Database name field is already populated.
Select Enable Active Dataguard, if you want to enable Oracle Active Data Guard.
In the Primary Information tab, specify the VIP of the Associated Network, Listener Port, Database SYS Password, and Backup Encryption Passwords. For high-availability systems, specify the Node 0 VIP of the Associated Network, Node 1 Primary Host Name, and Node 1 VIP of the Associated Network.
In the Standby Information tab, specify the Standby Host Name, VIP of the Associated Network, BUI User, BUI Password, System User, Database Unique Name, Database SYS Password, Listener Port, and Select Transport Type. For high-availability systems, specify the Node 0 Standby Host Name, Node 0 VIP of the Associated Network, Node 1 Standby Host Name, and Node 1 VIP of the Associated Network.
You can add multiple standby Oracle Data Guard configurations. Click Add Standby to add a new standby Oracle Data Guard configuration. A new Standby Information tab is opened for each new standby you add.
For each new standby, specify the Standby Host Name, VIP of the Associated Network, BUI User, BUI Password, System User, Database Unique Name, Database SYS Password, Listener Port, and Select Transport Type. For high-availability systems, specify the Node 0 Standby Host Name, Node 0 VIP of the Associated Network, Node 1 Standby Host Name, and Node 1 VIP of the Associated Network.
Click Save Configuration if you want to save the configuration as a JSON file.
Click Register and click Yes to confirm. Verify that the job is submitted and completes successfully.

Example JSON for registering Oracle Data Guard on Oracle Database Appliance

[root@node1 ~]# cat dg.json
{
  "name" : "provdb1_sprovdb",
  "protectionMode" : "MAX_PERFORMANCE",
  "replicationGroups" : [ {
    "sourceEndPoints" : [ {
      "endpointType" : "PRIMARY",
      "databaseUniqueName" : "provdb1",
      "ipAddress" : "10.32.65.225",
      "hostName" : "host1.domain.com",
      "listenerPort" : 1521,
      "serviceName" : "provdb.domain.com",
      "sysPassword" : null
    } ],
    "targetEndPoints" : [ {
      "endpointType" : "STANDBY",
      "databaseUniqueName" : "sprovdb",
      "ipAddress" : "10.32.65.230",
      "hostName" : "host2.domain.com",
      "listenerPort" : 1521,
      "serviceName" : "sprovdb.domain.com",
      "sysPassword" : null
    } ],
    "transportType" : "ASYNC"
  } ]
}

Related Topics

https://www.oracle.com/in/database/technologies/high-availability/maa.html

Parent topic: Using Oracle Data Guard for Disaster Management and Recovery on Oracle Database Appliance

Deconfiguring Oracle Data Guard on Oracle Database Appliance

Deconfigure Oracle Data Guard status using ODACLI commands.

Deconfiguring Oracle Data Guard Status using ODACLI commands

To deconfigure Oracle Data Guard, you must specify the Oracle Data Guard Configuration ID. Run the odacli list-dataguardstatus command to find the Oracle Data Guard Configuration ID.

Follow these steps:

To deconfigure Oracle Data Guard with one standby database, run the following command on the primary system:

# /opt/oracle/dcs/bin/odacli deconfigure-dataguard --id "ee22f382-b04e-4658-a6c7-ab00fc7e3270"
Number of standby databases (enter 1 or 2 | default: 1):
Standby 1 site address: standby1
BUI username for Standby site standby1. If Multi-user Access/Multi-user Access Passwordless is not enabled on Standby site standby1, enter 'oda-admin'; otherwise, enter the name of the user who has irestored the Standby database (default: oda-admin): oda-admin
BUI password for Standby site standby1:
Password for root user on Standby site standby1:
Standby database will be deleted after Data Guard configuration is removed. Ignore warning and proceed with Data Guard deconfiguration? (Y/N): Y
{
  "jobId" : "0613c649-3da6-463a-8359-2f6d7d17399b",
  "status" : "Created",
  "message" : "",
  "reports" : [ ],
  "createTimestamp" : "January 23, 2025 03:42:41 AM UTC",
  "resourceList" : [ ],
  "description" : "DG Deconfig service",
  "updatedTime" : "January 23, 2025 03:42:41 AM UTC",
  "jobType" : null,
  "cpsMetadata" : null
}
 
[root@n1 oda]# /opt/oracle/dcs/bin/odacli describe-job -i 0613c649-3da6-463a-8359-2f6d7d17399b
 
Job details                                                     
----------------------------------------------------------------
                     ID:  0613c649-3da6-463a-8359-2f6d7d17399b
            Description:  DG Deconfig service
                 Status:  Success
                Created:  January 23, 2025 03:42:41 UTC
                Message: 
 
Task Name                                Start Time                               End Time                                 Status         
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------------
De-configure Dataguard (Primary site)    January 23, 2025 03:42:44 UTC            January 23, 2025 03:44:22 UTC            Success        
(Host: phxdbfzp22/Job ID:                                                                                                                 
93758e42-2cf4-4aa1-949e-b6018c1c35d7)                                                                                                     
Delete Dataguard Status(Primary site)    January 23, 2025 03:44:22 UTC            January 23, 2025 03:44:28 UTC            Success        
(Host: phxdbfzp22/Job ID:                                                                                                                 
e090af71-9c6d-4d14-8e16-3c64c4aa7f14)                                                                                                     
Delete Dataguard Status(Standby site)    January 23, 2025 03:44:28 UTC            January 23, 2025 03:44:36 UTC            Success        
(Host:                                                                                                                                    
standby1           
/Job ID:                                                                                                                    
a5bf022a-c1ca-4c1a-8747-4ff6a0e938c0)                                                                                                     
Delete Standby Database (Standby site)   January 23, 2025 03:44:36 UTC            January 23, 2025 03:46:07 UTC            Success        
(Host:                                                                                                                                    
standby1           
/Job ID:                                                                                                                    
f93b1f26-69d9-4690-84f9-4c0c9947423a)

To deconfigure Oracle Data Guard with two standby databases, run the following command on the primary system:

# odacli deconfigure-dataguard -i
281ed08c-302f-4a94-932f-02fabf95e88e
Number of standby databases (enter 1 or 2 | default: 1): 2
Standby 1 site address: standby1
BUI username for Standby site standby1. If Multi-user Access/Multi-user
Access Passwordless is not enabled on Standby site standby1, enter
'oda-admin'; otherwise, enter the name of the user who has irestored the Standby
database (default: oda-admin):
BUI password for Standby site standby1:
Password for root user on Standby site standby1:
Standby 2 site address: standby2
BUI username for Standby site standby2. If Multi-user Access/Multi-user
Access Passwordless is not enabled on Standby site standby2, enter
'oda-admin'; otherwise, enter the name of the user who has irestored the Standby
database (default: oda-admin):
BUI password for Standby site standby2:
Password for root user on Standby site standby2:
Standby database will be deleted after Data Guard configuration is removed.
Ignore warning and proceed with Data Guard deconfiguration? (Y/N): y
{
  "jobId" : "e0b74b70-da87-4f46-8950-8cf061a8c576",
  "status" : "Created",
  "message" : "",
  "reports" : [ ],
  "createTimestamp" : "January 17, 2025 21:12:57 PM UTC",
  "resourceList" : [ ],
  "description" : "DG Deconfig service",
  "updatedTime" : "January 17, 2025 21:12:57 PM UTC",
  "jobType" : null,
  "cpsMetadata" : null
}
 
[root@n1 ~]# odacli describe-job -i "e0b74b70-da87-4f46-8950-8cf061a8c576"
 
Job details                                                     
----------------------------------------------------------------
                     ID:  e0b74b70-da87-4f46-8950-8cf061a8c576
            Description:  DG Deconfig service
                 Status:  Success
                Created:  January 17, 2025 21:12:57 UTC
                Message: 
 
Task Name                                Start Time                            
 End Time                                 Status         
------------------------------------------------------------------------------------------------------------------------ ----------------
De-configure Dataguard (Primary site)    January 17, 2025 21:13:02 UTC         January 17, 2025 21:14:14 UTC            Success        
(Host: scaoda8m014/Job ID:                                                                                              
65fbb55a-167d-428b-90ad-72c9e6acd706)                                          
                                                           
Delete Dataguard Status(Primary site)    January 17, 2025 21:14:14 UTC         January 17, 2025 21:14:20 UTC            Success        
(Host: scaoda8m014/Job ID:                                                     
3ade2aa0-6dcf-469a-a592-61e7111d26c2)                                          
                                                           
Delete Dataguard Status(Standby site)    January 17, 2025 21:14:20 UTC         January 17, 2025 21:14:29 UTC            Success        
(Host: standby1/Job ID:                                                     
9948a60f-119f-4a6d-944f-fe02741be5b9)                                          
                                                           
Delete Standby Database (Standby site)   January 17, 2025 21:14:29 UTC         January 17, 2025 21:16:41 UTC            Success        
(Host: standby1/Job ID:                                                     
714e53db-3dd6-4a22-b614-5110a4e98004)                                          
                                                           
Delete Dataguard Status(Standby site)    January 17, 2025 21:16:41 UTC         January 17, 2025 21:16:49 UTC            Success        
(Host: standby2/Job ID:                                                
17958ff9-c3e3-4ca8-9dc2-975ea2f369cb)                                          
                                                           
Delete Standby Database (Standby site)   January 17, 2025 21:16:49 UTC         January 17, 2025 21:19:22 UTC            Success        
(Host: standby2/Job ID:                                                
c352ea80-6c98-4249-bc7f-2700f1e81fdc)

For more information about these command options, see the Oracle Database Appliance Command Line Reference chapter in this guide.

Related Topics

odacli Oracle Data Guard Commands

Parent topic: Using Oracle Data Guard for Disaster Management and Recovery on Oracle Database Appliance

Deconfiguring Oracle Data Guard on Oracle Database Appliance Using BUI

Deconfigure Oracle Data Guard status using BUI.

Deconfiguring Oracle Data Guard Status using BUI

Follow these steps:

Log into the Browser User Interface:
https://host-ip-address:7093/mgmt/index.html
Click Database.
In the Database page, click on the database to view the database details.
In the Database details page, click the Dataguard Associations tab. The Oracle Data Guard configurations associated with the database are displayed.
From the Actions drop-down list of the Oracle Data Guard configuration, select Deconfigure.
In the Standby Information tab, specify the Standby Host Name, VIP of the Associated Network, BUI User, BUI Password, System User, and Database SYS Password. For high-availability systems, specify the Node 0 Standby Host Name, Node 0 VIP of the Associated Network, Node 1 Standby Host Name, and Node 1 VIP of the Associated Network.
Select Force Run to run the operation.
Click Add Standby to add another standby for deconfiguration.
After adding details of all the standby systems that you want to deconfigure, click Deconfigure and confirm the action. Verify that the job is submitted and completes successfully.

Related Topics

odacli Oracle Data Guard Commands

Parent topic: Using Oracle Data Guard for Disaster Management and Recovery on Oracle Database Appliance