Backup and Recovery

Backup
RMAN connection to root container...
Normal Backup will capture full instance
For just Root Container
     BACKUP DATABASE ROOT

For Pluggable Databases
     BACKUP PLUGGABLE DATABASE <pdb1,pdb2,pdb3>


RMAN connection to pluggable database will only work on that pdb

Restore
Connect to root container. Normal restore is full instance. For pdb...
RUN {ALTER PLUGGABLE DATABASE <pdb> CLOSE;

     
     SET UNTIL TIME "<timeset value>";

     
     RESTORE PLUGGABLE DATABASE <pdb>;

     
     RECOVER PLUGGABLE DATABASE <pdb>;

     
     ALTER PLUGGABLE DATABASE <pdb>OPEN; }
Comments