Creating an Oracle Logical Dump Subclient for Amazon RDS

You can create a subclient that contains the Amazon RDS Oracle data that you want to protect.

Before You Begin

To back up the entire database, the RDS user must have the privileges equivalent to the RDS admin user. Ensure that the RDS user has at least the following Oracle privileges:

CREATE SESSION, CONNECT, CREATE DIRECTORY, CREATE TABLE, CREATE DATABASE LINK, READ, WRITE, DBMS_DATAPUMP, DBMS_FILE_TRANSFER, DATAPUMP_IMP_FULL_DATABASE, DATAPUMP_EXP_FULL_DATABASE

Procedure

1. From the Command Center navigation pane, go to Protect > Databases.

   The databases Overview page appears.

2. On the Instances tab, click the instance to which you want to add the subclient.

   The Overview page of the instance appears.

3. On the Subclients tab, click Add logical dump subclient.

   The Add subclient dialog box appears.

4. In the Subclient name box, enter a unique name for the subclient.

5. From the Plan list, select a backup plan.

6. In the Number of streams box, enter the number of data streams that you want to use for backups.

7. Determine the schemas to include:

   • To include the entire database, select Full Database. By default, Full database is selected.

   • To include a subset of the tables, select Schema. Then, under available schemas, select the schemas to include in the backup, and then click Add all.

8. In the Staging path box, enter the full path to the staging location on the proxy server to use for backups and restores.

9. Click Save.