Restoring Oracle RAC Pluggable Databases from a Pluggable Backup

Before running the restore, enter the following on the command line:

 Sql> alter pluggable database PDB_NAME close;

Create and customize an RMAN script file on the client computer where the last line in the script specifies the pluggable database to restore. The line has the following format, with "pluggable_database_name1" through "pluggable_databaseN". Each database must be separated by a "," and must be part of the backup.

    restore pluggable database pluggable_database_name1, ..pluggable_database_nameN;
     recover pluggable database pluggable_database_name1, ..pluggable_database_nameN;

Example: RMAN script backing up the pluggable databases "PLUG_DB1" and "PLUG_DB2".

run 
{ 
    restore pluggable database PLUG_DB1, PLUG_DB2;
    recover pluggable database PLUG_DB1, PLUG_DB2;
} 
exit;

Execute the RMAN script. See Running RMAN Scripts from Third Party Command Line.

After the restore completes, manually open all the PDBs from the sql command line.

Sql> alter pluggable database PLUG_DB1, PLUG_DB2 open;