DBCA fails with "Error while restoring PDB backup piece" and ORA-04062 (Doc ID 2921426.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

When I try to create an empty Container database or a PDB with a CDB, DBCA fails with the error "Error while restoring PDB backup piece."

[Thread-96] [ 2023-01-11 14:14:00.770 CET ] [RMANEngine.readSqlOutput:997] Log RMAN Output=RMAN-03002: failure of restore command at 01/11/2023 14:14:00

[Thread-96] [ 2023-01-11 14:14:00.770 CET ] [RMANEngine.readSqlOutput:997] Log RMAN Output=ORA-04062: signature of package "SYS.DBMS_BACKUP_RESTORE" has been changed
[Thread-96] [ 2023-01-11 14:14:00.779 CET ] [RMANEngine.readSqlOutput:997] Log RMAN Output=

[progressPage.flowWorker] [ 2023-01-11 14:14:00.794 CET ] [RMANUtil.restorePDBBackUp:1697] Error while restoring PDB backup piece: echo set off
RMAN> 2> 3> 4> 5>
executing command: SET COMMAND ID
Starting restore at 11-JAN-23
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1343 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/11/2023 14:14:00
ORA-04062: signature of package "SYS.DBMS_BACKUP_RESTORE" has been changed
RMAN>
echo set onI

NFO: Jan 11, 2023 2:14:00 PM oracle.install.commons.util.progress.ProgressPane log
INFO: Creating and starting Oracle instance : Failed

Changes

 One of the existing PDB's were also patched

Cause

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