Recover tablespace in CDB / PDB

CDB Root - System or Undo datafile Missing or corrupted

System or undo missing in root container ( Similiar to non-cdbs).

To recover either system or undo we need to put the entire CDB in mount mode, which means all the PDB's will be affected.

RMAN> startup mount

RMAN> restore tablespace system, undotbs1;

RMAN> recover tablespace system, undotbs1;

RMAN> alter database open;

Sysuax or other datafile in root container (similiar to non-cdbs).

(CDB instance is up and running PDB's are not affected).

To recover other tablespace apart from system and undo we can bring the tablespace to offline mode and recover it.

RMAN> alter tablespace sysaux offline immediate;

RMAN> restore tablespace sysaux;

RMAN> recover tablespace sysaux;

RMAN> alter tablespace sysaux online;