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.
Was this article helpful?
thumb_up
Yes
thumb_down
No