Administering your RDS for Oracle DB instance
Following are the common management tasks that you perform with an RDS for Oracle 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 Database has special considerations. For example, you 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. |
|
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. |
Configuring and managing a Multi-AZ deployment for Amazon RDS |
Amazon VPC If your Amazon account has a default virtual private cloud (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. |
|
Security groups By default, DB instances use a firewall that prevents access. Make sure that you create a security group with the correct IP addresses and network configuration to access the DB instance. |
|
Parameter groups If your DB instance is going to require specific database parameters, create a parameter group before you create the DB instance. |
|
Option groups If your DB instance requires specific database options, create an option group before you create the DB instance. |
|
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. |
|
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. |
|
Monitoring You can monitor an Oracle DB instance by using CloudWatch Amazon RDS metrics, events, and enhanced monitoring. |
|
Log files You can access the log files for your Oracle DB instance. |
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. Also, RDS 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:
-
Amazon RDS method:
rdsadmin.rdsadmin_util.disconnect
Oracle method:
alter system disconnect session
Amazon RDS method:
rdsadmin.rdsadmin_util.kill
Oracle method:
alter system kill session
Amazon RDS method:
rdsadmin.rdsadmin_util.cancel
Oracle method:
alter system cancel sql
Amazon RDS method:
rdsadmin.rdsadmin_util.restricted_session
Oracle method:
alter system enable restricted session
Amazon RDS method:
rdsadmin.rdsadmin_util.flush_shared_pool
Oracle method:
alter system flush shared_pool
Amazon RDS method:
rdsadmin.rdsadmin_util.flush_buffer_cache
Oracle method:
alter system flush buffer_cache
Amazon RDS method:
rdsadmin.rdsadmin_util.grant_sys_object
Oracle method:
grant
Amazon RDS method:
rdsadmin.rdsadmin_util.revoke_sys_object
Oracle method:
revoke
Amazon RDS method:
rdsadmin.rdsadmin_util.create_sys_x$_view
Oracle method:
CREATE VIEW
Amazon RDS method:
grant
Amazon RDS method:
rdsadmin.rdsadmin_password_verify.create_verify_function
Amazon RDS method:
rdsadmin.rdsadmin_password_verify.create_passthrough_verify_fcn
—
Amazon RDS method:
rdsadmin.rdsadmin_util.list_allowed_system_events
Oracle method: —
Amazon RDS method:
rdsadmin.rdsadmin_util.set_allowed_system_events
Oracle method:
ALTER SYSTEM SET EVENTS
'set_event_clause'
Amazon RDS method:
rdsadmin.rdsadmin_util.list_set_system_events
Oracle method:
ALTER SESSION SET EVENTS 'IMMEDIATE EVENTDUMP(SYSTEM)'
Amazon RDS method:
rdsadmin.rdsadmin_util.unset_system_event
Oracle method:
ALTER SYSTEM SET EVENTS
'unset_event_clause'
-
Amazon RDS method:
rdsadmin.rdsadmin_util.rename_global_name
Oracle method:
alter database rename
Amazon RDS method:
create tablespace
Oracle method:
alter database
Amazon RDS method:
rdsadmin.rdsadmin_util.alter_default_tablespace
Oracle method:
alter database default tablespace
Amazon RDS method:
rdsadmin.rdsadmin_util.alter_default_temp_tablespace
Oracle method:
alter database default temporary tablespace
Amazon RDS method:
rdsadmin.rdsadmin_util.create_inst_store_tmp_tblspace
Oracle method:
create temporary tablespace
Amazon RDS method:
rdsadmin.rdsadmin_util.checkpoint
Oracle method:
alter system checkpoint
Amazon RDS method:
rdsadmin.rdsadmin_util.enable_distr_recovery
Oracle method:
alter system enable distributed recovery
Amazon RDS method:
rdsadmin.rdsadmin_util.alter_db_time_zone
Oracle method:
alter database set time_zone
—
Generating performance reports with Automatic Workload Repository (AWR)
Amazon RDS method:
rdsadmin.rdsadmin_diagnostic_util
proceduresOracle method:
dbms_workload_repository
package—
Amazon RDS method:
rdsadmin.rdsadmin_util.alter_default_edition
Oracle method:
alter database default edition
Amazon RDS method:
rdsadmin.rdsadmin_master_util.audit_all_sys_aud_table
Oracle method:
audit
Amazon RDS method:
rdsadmin.rdsadmin_master_util.noaudit_all_sys_aud_table
Oracle method:
noaudit
Amazon RDS method:
rdsadmin.rdsadmin_dbms_repair.online_index_clean
Oracle method:
dbms_repair.online_index_clean
Amazon RDS method: Several
rdsadmin.rdsadmin_dbms_repair
proceduresOracle method:
dbms_repair
packageAmazon RDS method:
rdsadmin.rdsadmin_util.resize_temp_tablespace
,rdsadmin.rdsadmin_util.resize_tempfile
, orrdsadmin.rdsadmin_util.autoextend_tempfile
proceduresrdsadmin.rdsadmin_util.resize_datafile
orrdsadmin.rdsadmin_util.autoextend_datafile
procedureOracle method: —
Amazon RDS method:
EXEC rdsadmin.rdsadmin_util.purge_dba_recyclebin
Oracle method:
purge dba_recyclebin
Amazon RDS method:
EXEC rdsadmin.rdsadmin_util.dbms_redact_upd_full_rdct_val
Oracle method:
exec dbms_redact.UPDATE_FULL_REDACTION_VALUES
-
Amazon RDS method:
rdsadmin.rdsadmin_util.force_logging
Oracle method:
alter database force logging
Amazon RDS method:
rdsadmin.rdsadmin_util.alter_supplemental_logging
Oracle method:
alter database add supplemental log
Amazon RDS method:
rdsadmin.rdsadmin_util.switch_logfile
Oracle method:
alter system switch logfile
Amazon RDS method:
rdsadmin.rdsadmin_util.add_logfile
Amazon RDS method:
rdsadmin.rdsadmin_util.drop_logfile
—
Amazon RDS method:
rdsadmin.rdsadmin_util.set_configuration
Amazon RDS method:
rdsadmin.rdsadmin_archive_log_download.download_log_with_seqnum
Amazon RDS method:
rdsadmin.rdsadmin_archive_log_download.download_logs_in_seqnum_range
Amazon RDS method:
rdsadmin.rdsadmin_master_util.create_archivelog_dir
Amazon RDS method:
rdsadmin.rdsadmin_master_util.create_onlinelog_dir
-
Amazon RDS method:
rdsadmin_rman_util.
procedure
Oracle method:
RMAN VALIDATE
Amazon RDS method:
rdsadmin_rman_util.
procedure
Oracle method:
ALTER DATABASE
Amazon RDS method:
rdsadmin_rman_util.crosscheck_archivelog
Oracle method:
RMAN BACKUP
Amazon RDS method:
rdsadmin_rman_util.
procedure
Oracle method:
RMAN BACKUP
Amazon RDS method:
rdsadmin_rman_util.backup_database_full
Oracle method:
RMAN BACKUP
Amazon RDS method:
rdsadmin_rman_util.backup_database_incremental
Oracle method:
RMAN BACKUP
Amazon RDS method:
rdsadmin_rman_util.backup_database_tablespace
Oracle method:
RMAN BACKUP
-
Amazon RDS method:
dbms_scheduler.set_attribute
Oracle method:
dbms_scheduler.set_attribute
Amazon RDS method:
dbms_scheduler.set_attribute
Oracle method:
dbms_scheduler.set_attribute
Amazon RDS method:
dbms_scheduler.set_scheduler_attribute
Oracle method:
dbms_scheduler.set_scheduler_attribute
Amazon RDS method:
rdsadmin.rdsadmin_dbms_scheduler.disable
Oracle method:
dbms_scheduler.disable
Amazon RDS method:
rdsadmin.rdsadmin_dbms_scheduler.enable
Oracle method:
dbms_scheduler.enable
Modifying the Oracle Scheduler repeat interval for jobs of CALENDAR type
Amazon RDS method:
rdsadmin.rdsadmin_dbms_scheduler.set_attribute
Oracle method:
dbms_scheduler.set_attribute
Modifying the Oracle Scheduler repeat interval for jobs of NAMED type
Amazon RDS method:
rdsadmin.rdsadmin_dbms_scheduler.set_attribute
Oracle method:
dbms_scheduler.set_attribute
Amazon RDS method:
rdsadmin.rdsadmin_dbms_scheduler.set_no_commit_flag
Oracle method:
dbms_isched.set_no_commit_flag
-
Amazon RDS method:
rdsadmin.rdsadmin_adrci_util.list_adrci_incidents
Oracle method: ADRCI command
show incident
Amazon RDS method:
rdsadmin.rdsadmin_adrci_util.list_adrci_problem
Oracle method: ADRCI command
show problem
Amazon RDS method:
rdsadmin.rdsadmin_adrci_util.create_adrci_package
Oracle method: ADRCI command
ips create package
Amazon RDS method:
rdsadmin.rdsadmin_adrci_util.show_adrci_tracefile
Oracle method: ADRCI command
show tracefile
-
Creating and dropping directories in the main data storage space
Amazon RDS method:
rdsadmin.rdsadmin_util.create_directory
Oracle method:
CREATE DIRECTORY
Amazon RDS method:
rdsadmin.rdsadmin_util.drop_directory
Oracle method:
DROP DIRECTORY
Amazon RDS method:
rdsadmin.rds_file_util.listdir
Oracle method: —
Amazon RDS method:
rdsadmin.rds_file_util.read_text_file
Oracle method: —
Amazon RDS method:
rdsadmin.rds_file_util.read_text_file
orrdsadmin.tracefile_listing
Oracle method:
opatch
Amazon RDS method:
rdsadmin.rdsadmin_util.advisor_task_set_parameter
Oracle method: Various stored package procedures
Amazon RDS method:
rdsadmin.rdsadmin_util.advisor_task_drop
Oracle method: —
Amazon RDS method:
rdsadmin.rdsadmin_util.dbms_stats_init
Oracle method: —
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 Administering the Management Agent.