PIT restore job of the root fails with error "Specifying CDB$ROOT database is not supported"

book

Article ID: 100014336

calendar_today

Updated On:

Description

Error Message

RMAN-05105: Specifying CDB$ROOT database is not supported

Cause

RMAN does not support this type of operation on the root for following reasons:

  • The root holds the metadata for all other pluggable databases (PDB) in that container database (CDB). The CDB might also go in an inconsistent state because of metadata inconsistencies between the PDBs and the root.
  • The root also holds the undo tablespace, which is common (shared) among all the PDBs. If a user restores the root to a PIT, the undo tablespace that holds the undo data of other containers will be lost.

     

Resolution

Recover the whole container database instead of recovering only the root.

 

Applies To

All versions of Backup Exec + All versions of Oracle from 12c onwards, as the database.

Issue/Introduction

The point-in-time (PIT) restore job of the root fails with an error message.