DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, January 10, 2018

RMAN new features and enhancements







RMAN new features and enhancements


Container and pluggable database backup and restore

RMAN> BACKUP DATABASE; (To backup the CBD + all PDBs)
RMAN> BACKUP DATABASE root; (To backup only the CBD)
RMAN> BACKUP PLUGGABLE DATABASE pdb1,pdb2; (To backup all specified
PDBs)
RMAN> BACKUP TABLESPACE pdb1:example; (To backup a specific
tablespace in a PDB)
Some examples when performing RESTORE operations are:
RMAN> RESTORE DATABASE; (To restore an entire CDB, including all
PDBs)
RMAN> RESTORE DATABASE root; (To restore only the root container)
RMAN> RESTORE PLUGGABLE DATABASE pdb1; (To restore a specific PDB)
RMAN> RESTORE TABLESPACE pdb1:example; (To restore a tablespace in a
PDB)
Finally, some example of RECOVERY operations are:
RMAN> RECOVER DATABASE; (Root plus all PDBs)
RMAN> RUN {
SET UNTIL SCN 1428;
RESTORE DATABASE;
RECOVER DATABASE;
ALTER DATABASE OPEN RESETLOGS; }
RMAN> RUN {
RESTORE PLUGGABLE DATABASE pdb1 TO RESTORE POINT one;
RECOVER PLUGGABLE DATABASE pdb1 TO RESTORE POINT one;
ALTER PLUGGABLE DATABASE pdb1 OPEN RESETLOGS;}


No comments: