Patching Oracle Data Guard Database

Starting with Oracle Grid Infrastructure 23ai, Oracle FPP enables you to automatically patch Oracle Data Guard standby databases before patching their primary databases.

Oracle Fleet Patching and Provisioning (Oracle FPP) automatically discovers the standby databases, associated with primary databases, and patches the standby databases before patching the primary database using a single command.

Note:

If the Oracle Database Guard databases are registered on a different client, which can be in different data center, then those servers must be register peers of each other.

Check the Oracle Data Guard configuration of a database to identify the primary database and its standby databases.
```
rhpctl query workingcopy -workingcopy workingcopy_name -details
```
Schedule a job for each standby database associated with the primary database using a single job ID.
```
rhpctl move database -dbname primary_dbname -sourcewc source_working_copy 
-patchedwc destination_working_copy -patchdataguard YES -schedule NOW
```
The above command provides a parent job ID, which you can use as a single point of reference to monitor the progress of standby and primary database patching.
Monitor the progress of the entire patching operation.
```
rhpctl query job -jobid job_id
```
Optionally, you can monitor the progress of the individual standby database patching operations.
```
rhpctl query job -jobid job_id
```

Related Topics

Parent topic: Patching and Upgrading Oracle Database