My Oracle Support Banner

What are the steps to back up and restore the REGISTRY$SQLPATCH table? (Doc ID 3060917.1)

Last updated on NOVEMBER 27, 2024

Applies to:

Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A to N/A
Oracle Database Cloud Service - Version N/A to N/A [Release 1.0]
Gen 2 Exadata Cloud at Customer - Version N/A to N/A [Release All Releases]
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

Goal

In an Oracle Multitenant environment or Non-CDB environment, during post-patching with datapatch, there might be scenarios where it becomes necessary to back up the REGISTRY$SQLPATCH table. This backup could be critical for restoration if rows with a successful status are accidentally deleted.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.