Administering your Oracle DB instance - Amazon Relational Database Service

Administering your Oracle DB instance

Following are the common management tasks you perform with an Amazon RDS DB instance. Some tasks are the same for all RDS DB instances. Other tasks are specific to RDS for Oracle.

The following tasks are common to all RDS databases, but Oracle has special considerations. For example, connect to an Oracle Database using the Oracle clients SQL*Plus and SQL Developer.

Task area Relevant documentation

Instance Classes, Storage, and PIOPS

If you are creating a production instance, learn how instance classes, storage types, and Provisioned IOPS work in Amazon RDS.

RDS for Oracle instance classes

Amazon RDS storage types

Multi-AZ Deployments

A production DB instance should use Multi-AZ deployments. Multi-AZ deployments provide increased availability, data durability, and fault tolerance for DB instances.

Multi-AZ deployments for high availability

Amazon Virtual Private Cloud (VPC)

If your AWS account has a default VPC, then your DB instance is automatically created inside the default VPC. If your account doesn't have a default VPC, and you want the DB instance in a VPC, create the VPC and subnet groups before you create the instance.

Determining whether you are using the EC2-VPC or EC2-Classic platform

Working with a DB instance in a VPC

Security Groups

By default, DB instances use a firewall that prevents access. Make sure you create a security group with the correct IP addresses and network configuration to access the DB instance. The security group you create depends on which Amazon EC2 platform your DB instance is on, and whether you will access your DB instance from an Amazon EC2 instance.

In general, if your DB instance is on the EC2-Classic platform, you should create a DB security group. Also, if your instance is on the EC2-VPC platform, you should create a VPC security group.

Determining whether you are using the EC2-VPC or EC2-Classic platform

Controlling access with security groups

Parameter Groups

If your DB instance is going to require specific database parameters, you should create a parameter group before you create the DB instance.

Working with DB parameter groups

Option Groups

If your DB instance will require specific database options, you should create an option group before you create the DB instance.

Adding options to Oracle DB instances

Connecting to Your DB Instance

After creating a security group and associating it to a DB instance, you can connect to the DB instance using any standard SQL client application such as Oracle SQL*Plus.

Connecting to your Oracle DB instance

Backup and Restore

You can configure your DB instance to take automated backups, or take manual snapshots, and then restore instances from the backups or snapshots.

Backing up and restoring an Amazon RDS DB instance

Monitoring

You can monitor an Oracle DB instance by using CloudWatch Amazon RDS metrics, events, and enhanced monitoring.

Viewing DB instance metrics

Viewing Amazon RDS events

Log Files

You can access the log files for your Oracle DB instance.

Working with Amazon RDS database log files

Following, you can find a description for Amazon RDS–specific implementations of common DBA tasks for RDS Oracle. To deliver a managed service experience, Amazon RDS doesn't provide shell access to DB instances, and restricts access to certain system procedures and tables that require advanced privileges. In many of the tasks, you run the rdsadmin package, which is an Amazon RDS–specific tool that enables you to administer your database.

The following are common DBA tasks for DB instances running Oracle:

  • Diagnostic tasks

    Listing incidents

    Amazon RDS method: rdsadmin.rdsadmin_adrci_util.list_adrci_incidents

    Oracle method: ADRCI command show incident

    Listing problems

    Amazon RDS method: rdsadmin.rdsadmin_adrci_util.list_adrci_problem

    Oracle method: ADRCI command show problem

    Creating incident packages

    Amazon RDS method: rdsadmin.rdsadmin_adrci_util.create_adrci_package

    Oracle method: ADRCI command ips create package

    Showing trace files

    Amazon RDS method: rdsadmin.rdsadmin_adrci_util.show_adrci_tracefile

    Oracle method: ADRCI command show tracefile

You can also use Amazon RDS procedures for Amazon S3 integration with Oracle and for running OEM Management Agent database tasks. For more information, see Amazon S3 integration and Performing database tasks with the Management Agent.