Restoring Oracle Container and Pluggable Databases

SnapProtect supports the restore of container and pluggable databases.

If you have backed up an entire container database you can restore the entire container database, a single pluggable database, or multiple pluggable databases.

Restore a Container Database

Before You Begin

Perform a backup of the Oracle Container or Pluggable Database.

Procedure

Container databases can be restored like any full database. See Restoring Offline Full Databases for Oracle.

Restore a Single Pluggable Database

Before You Begin

  1. Perform a backup of the Oracle Container or Pluggable Database.
  2. Close the pluggable database. On the command line, type the following command.

    Sql> alter pluggable database pluggable_database_name close;

Procedure

  1. Create and customize an RMAN script file on the client computer, substituting the pluggable database name.. Place the script in the Database tab of the Custom Rman Script tab on the Advanced Restore Options dialog box.

    run {
        restore pluggable database single_pluggable_database;
        recover pluggable database single_pluggable_database ;
    }
    exit;

  2. The script runs when the Restore Options dialog box is closed.

What to Do Next

  • Once the restore is done, manually open all the pluggable database. On the command line, type the following command.

Sql> alter pluggable database single_pluggable_database open;

Restore Multiple Pluggable Databases

Before You Begin

  1. Perform a backup of the Oracle Container or Pluggable Database.
  2. Close all pluggable databases that you want to restore. On the command line, type the following command.

    Sql> alter pluggable database pluggable_database_name  close;

Procedure

  1. Create and customize an RMAN script file on the client computer, substituting the pluggable database names.

    The script is placed in the Database tab of the Custom Rman Script tab on the Advanced Restore Options dialog box. The line has the following format. Separate each database with a ",".  Each database must be part of the backup. Separate each database with a ",".

    run {
    restore pluggable database pluggable_database_name1, pluggable_database_nameN;
    recover pluggable database pluggable_database_name1, pluggable_database_nameN;
    }

  2. The script runs when the Restore Options dialog box is closed.

What to Do Next

  • Once the restore is done, manually open all the pluggable databases. On the command line, type the following command.

Sql> alter pluggable database pluggable_database_name1, pluggable_database_nameN open;