# Working with Amazon RDS for Oracle

When using Amazon RDS for Oracle as a source, make sure to fulfill the prerequisites described below.

Information noteOracle databases with Multi-AZ enabled are supported.

## Required Amazon RDS for Oracle permissions

Grant the following privileges:

* GRANT SELECT ANY TABLE
* GRANT SELECT on ALL\_VIEWS to user;
* GRANT SELECT on DBA\_TABLESPACES to user;
* GRANT SELECT on ALL\_INDEXES to user;
* GRANT SELECT on ALL\_OBJECTS to user;
* GRANT SELECT on ALL\_TABLES to user;
* GRANT SELECT on ALL\_USERS to user;
* GRANT SELECT on ALL\_CATALOG to user;
* GRANT SELECT on ALL\_CONSTRAINTS to user;
* GRANT SELECT on ALL\_CONS\_COLUMNS to user;
* GRANT SELECT on ALL\_TAB\_COLS to user;
* GRANT SELECT on ALL\_IND\_COLUMNS to user;
* GRANT SELECT on ALL\_LOG\_GROUPS to user;
* GRANT LOGMINING TO user;

In addition, execute the following statements:

```
exec rdsadmin.rdsadmin_util.grant_sys_object('V_$DATABASE','user','SELECT');
exec rdsadmin.rdsadmin_util.grant_sys_object('V_$PARAMETER','user','SELECT');
exec rdsadmin.rdsadmin_util.grant_sys_object('V_$NLS_PARAMETERS','user','SELECT');
exec rdsadmin.rdsadmin_util.grant_sys_object('V_$CONTAINERS','user','SELECT');
```

## Preparing replication from Amazon RDS for Oracle

This section details the requirements for working with Oracle on Amazon RDS.

### Set up supplemental logging

Qlik Replicate requires database-level supplemental logging to be enabled. To enable database-level supplemental logging, execute the following command:

` exec rdsadmin.rdsadmin_util.alter_supplemental_logging('ADD');
                 `

Although not required, examples of additional commands that you can execute to change the supplemental logging attributes include:

`exec rdsadmin.rdsadmin_util.alter_supplemental_logging('ADD','ALL');` `exec rdsadmin.rdsadmin_util.alter_supplemental_logging('DROP','PRIMARY KEY');`

### Enabling automatic backups

In Step 5: Management Options of setting up your Oracle database instance, set the Enabled Automatic Backups option to Yes.

### Setting up archiving

To retain archived redo logs of your Oracle database instance, execute the following command (example 24 hours):

` exec rdsadmin.rdsadmin_util.set_configuration('archivelog retention hours',24);
                 `

Make sure that your storage has sufficient space for the archived redo logs during the specified period.