Loading...

Performing Oracle Container and Pluggable Database Backups

SnapProtect 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

Backup a Container Database

Procedure

Backup a Single Pluggable Database

Procedure

  1. 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;

  2. The script runs when the Backup Options dialog box closes.

Backup Multiple Pluggable Databases

Procedure

  1. 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;

  2. The script runs when the Backup Options dialog box closes.