Performing Oracle Container and Pluggable Database Backups

Commvault supports a backup of the entire container database or one or more pluggable databases.

Create an instance for a container database, and then perform a full or incremental backup. You can back up single and multiple pluggable databases with custom RMAN scripts.

Before You Begin

Add an instance for the container database.

Procedure

Backing up a Container Database

Create a full or incremental backup of the container database instance.

Backing up a Single Pluggable Database

Create and customize an RMAN script, substituting the pluggable database name. Place the script in the Database tab of the Custom RMAN Script tab on the Advanced Backup Options dialog box.
```
run { 
    setlimit channel ch1 maxopenfiles 8; 
    backup 
    incremental level = 0
    filesperset = 32
    pluggable database pluggable_database_name
  ;
} 
exit;
```
The script runs when the Backup Options dialog box closes.

Backing Up Multiple Pluggable Databases

Create and customize an RMAN script file on the client computer, substituting the pluggable database names. Separate each database with a ",". The last line in the script specifies the pluggable databases to back up. The script is placed in the Database tab of the Custom RMAN Script tab on the Advanced Backup Options dialog box.

Create a script with the sample line,
```
run { 
    setlimit channel ch1 maxopenfiles 8; 
    backup 
    incremental level = 0
    filesperset = 32
    pluggable database pluggable_database_name1, ..pluggable_database_nameN
  ;
} 
exit;
```
Example

An RMAN script that backs up the pluggable databases "PLUG_DB1" and "PLUG_DB2".
```
run { 
     setlimit channel ch1 maxopenfiles 8;
     backup 
      incremental level = 0 
      filesperset = 32 
      pluggable database PLUG_DB1, PLUG_DB2; 
 } 
 exit;
```
The script runs when the Backup Options dialog box closes.