Restoring Oracle RAC Pluggable Databases from a Container Backup

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

     Sql> alter pluggable database PDB_NAME close;
  2. Create and customize an RMAN script file on the client computer, where the last line in the script specifies the pluggable databases 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;

    Example: RMAN script restoring the pluggable database "SINGLE_PDB".

    run 
     { 
         restore pluggable database SINGLE_PDB ; 
     } 
     exit;
  3. Execute the RMAN script. See Running RMAN Scripts from Third Party Command Line.

  4. After the restore competes, manually open the PDB from the sql command line.

    Sql> alter pluggable database SINGLE_PDB open;
×

Loading...