Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Performing common database tasks for Oracle DB instances

Following, you can find how to perform certain common DBA tasks related to databases on your Amazon RDS DB instances running Oracle. To deliver a managed service experience, Amazon RDS doesn't provide shell access to DB instances. Amazon RDS also restricts access to some system procedures and tables that require advanced privileges.

Checkpointing a database

To checkpoint the database, use the Amazon RDS procedure rdsadmin.rdsadmin_util.checkpoint. The checkpoint procedure has no parameters.

The following example checkpoints the database.

EXEC rdsadmin.rdsadmin_util.checkpoint;

Setting distributed recovery

To set distributed recovery, use the Amazon RDS procedures rdsadmin.rdsadmin_util.enable_distr_recovery and disable_distr_recovery. The procedures have no parameters.

The following example enables distributed recovery.

EXEC rdsadmin.rdsadmin_util.enable_distr_recovery;

The following example disables distributed recovery.

EXEC rdsadmin.rdsadmin_util.disable_distr_recovery;

Purging the recycle bin

When you drop a table, your Oracle database doesn't immediately remove its storage space. The database renames the table and places it and any associated objects in a recycle bin. Purging the recycle bin removes these items and releases their storage space.

To purge the entire recycle bin, use the Amazon RDS procedure rdsadmin.rdsadmin_util.purge_dba_recyclebin. However, this procedure can't purge the recycle bin of SYS and RDSADMIN objects. If you need to purge these objects, contact Amazon Support.

The following example purges the entire recycle bin.

EXEC rdsadmin.rdsadmin_util.purge_dba_recyclebin;