How to Apply patch on DBCS with Data guard

March 23, 2022 | 10 minute read
SATYABRATA MISHRA
Senior Product Manager, Database PTS
Text Size 100%:

Oracle Database Cloud Service (DBCS) runs Enterprise and Standard Edition databases on Virtual Machine (VM) DB Systems and enables you to easily build, scale, and secure Oracle database cost-effectively in the cloud. Database patching is an important and critical subject. This article provides a walkthrough of patching process for DBCS with Data Guard.

PATCHING

To patch DBCS with Data Guard. We need to first apply the patch on the standby database then the primary. Follow below steps for applying the patch.

Step -1   Run the precheck for the patch on the standby database.

Go to the standby database console and click on Updates on Resources tab and run the Precheck for the patch on the standby database.

​ 

Check the status of the precheck in the update history and the work request tab will show more details if there are any issues.

 

 

                   Use right-click->Open image in new tab if you are facing difficulties reading.

Step-2   Apply the patch on standby

Click on Apply option for applying the patch on the standby database.

                 Use right-click->Open image in new tab if you are facing difficulties reading.

Check the status of the patch in the Update History work request tab will show more details if there is an issue.

                  Use right-click->Open image in new tab if you are facing difficulties reading.

Step-3 Verify apply lag

Verify the lag from the primary site Data Guard association and make sure it is zero seconds.

 

​  

                 Use right-click->Open image in new tab if you are facing difficulties reading.

Step-4   Perform switch over from primary to the standby database

Go to primary database resources Data Guard association tab and switchover from primary to standby database.

 

            Use right-click->Open image in new tab if you are facing difficulties to reading.

Verify the switchover status in the work request

 

            Use right-click->Open image in new tab if you are facing difficulties to reading.

Now your primary database is the standby and the standby database is the new primary.

Step-5 Verify the database status and run the datapatch on the new primary database.

Log in to the new primary database and verify the database status, role and run the datapatch.

  Use right-click->Open image in new tab if you are facing difficulties to reading.

Step-6  Run Precheck for patch on new standby database.

 Login to new standby database console go to updates tab on resources, Run the Precheck for patch on the new standby database.

            Use right-click->Open image in new tab if you are facing difficulties to reading

Note- If your precheck patch failed, refer to the below link to fix this issue apart from MOS.

https://docs.oracle.com/en-us/iaas/Content/Database/Troubleshooting/Patching/patchingfail.htm#Determin

Verify the update history for the status of the precheck

              Use right-click->Open image in new tab if you are facing difficulties to reading

Step-7  Apply the patch

Click on apply button for applying patch on new standby database.

                 Use right-click->Open image in new tab if you are facing difficulties to reading

Verify the patch status with update history