Amazon RDS

Required settings

Host name
Port (default is 1521)
Service account
Database name
Schema name
Database log mode to be ARCHIVELOG
Supplemental logging to be enabled

Due to the limitation of Amazon RDS, we cannot replicate from a multi-tenant database.

Setup instructions

Enable archive log mode

To enable archive log mode, you’ll need to enable automated backups. This change will take effect upon the next database restart.Once this is enabled, we recommend you to set the log retention to at least 24 hours.

-- We recommend setting the log retention to at least 24 hours.
EXECUTE rdsadmin.rdsadmin_util.set_configuration('archivelog retention hours', 24);
COMMIT;

Enable supplemental logging

How to create a service account

CREATE USER ARTIE_USER IDENTIFIED BY PASSWORD;

CREATE TABLESPACE ARTIE_LOGMINER_TBS DATAFILE SIZE 25M AUTOEXTEND ON MAXSIZE UNLIMITED;
ALTER USER ARTIE_USER DEFAULT TABLESPACE ARTIE_LOGMINER_TBS;
ALTER USER ARTIE_USER QUOTA UNLIMITED ON ARTIE_LOGMINER_TBS;
GRANT CREATE SESSION TO ARTIE_USER;

-- Grant access to LogMiner
GRANT LOGMINING TO ARTIE_USER; 

-- Flashback for backfilling
GRANT FLASHBACK ANY TABLE TO ARTIE_USER; 
GRANT SELECT ANY TRANSACTION TO ARTIE_USER; 

-- Required to read and write to the data dictionary to track schema history
GRANT SELECT_CATALOG_ROLE TO ARTIE_USER; 
GRANT EXECUTE_CATALOG_ROLE TO ARTIE_USER; 

-- We'll need this to create a table for managing internal log buffers (LGWR)
GRANT CREATE TABLE TO ARTIE_USER; 
GRANT CREATE SEQUENCE TO ARTIE_USER; 

-- Read access to system tables (redo, archive and current transaction logs)
EXECUTE rdsadmin.rdsadmin_util.grant_sys_object('V_$DATABASE','ARTIE_USER','SELECT'); 
EXECUTE rdsadmin.rdsadmin_util.grant_sys_object('V_$LOG','ARTIE_USER','SELECT'); 
EXECUTE rdsadmin.rdsadmin_util.grant_sys_object('V_$LOG_HISTORY','ARTIE_USER','SELECT'); 
EXECUTE rdsadmin.rdsadmin_util.grant_sys_object('V_$LOGMNR_LOGS','ARTIE_USER','SELECT'); 
EXECUTE rdsadmin.rdsadmin_util.grant_sys_object('V_$LOGMNR_CONTENTS','ARTIE_USER','SELECT'); 
EXECUTE rdsadmin.rdsadmin_util.grant_sys_object('V_$LOGMNR_PARAMETERS','ARTIE_USER','SELECT'); 
EXECUTE rdsadmin.rdsadmin_util.grant_sys_object('V_$LOGFILE','ARTIE_USER','SELECT'); 
EXECUTE rdsadmin.rdsadmin_util.grant_sys_object('V_$ARCHIVED_LOG','ARTIE_USER','SELECT'); 
EXECUTE rdsadmin.rdsadmin_util.grant_sys_object('V_$ARCHIVE_DEST_STATUS','ARTIE_USER','SELECT'); 
EXECUTE rdsadmin.rdsadmin_util.grant_sys_object('V_$TRANSACTION','ARTIE_USER','SELECT');

-- Grant access to the service account to query the tables.
-- GRANT SELECT ON {schema}.{table} TO ARTIE_USER;
GRANT SELECT ANY TABLE TO ARTIE_USER;

Home

Concepts

Connectors

Tables

Monitoring

Artie Dashboard

Legal

Required settings

Setup instructions

Home

Concepts

Connectors

Tables

Monitoring

Artie Dashboard

Legal

​Required settings

​Setup instructions

Required settings

Setup instructions