Architecture

Actions

1. Backup of the RDS database to Oracle directory, which is located on internal RDS server

2. Copy the backup to S3 bucket

3. Mount the S3 bucket as a directory on the staging host

4. Mount Accelario disk to the staging server

5. Restore from the mounted directory to staging Oracle instance (the instance is located on Accelario disk that was mounted in action 4)

6. Create standard VDB

Prerequisites

1. RDS Oracle database

2. Staging EC2 Linux server with Oracle Database software installed - same version as the RDS database

Preparations

1. Anchor
   create_s3_bucket create_s3_bucket

   Create a Standard S3 Bucket with a one folder inside.
   In our example, we created a bucket rds-ora19 with folder ora19-folder
   

...

• Set Archive Log retention.
  Check current value:

  Code Block
  language sql
  set serveroutput on EXEC rdsadmin.rdsadmin_util.show_configuration;

• If the value is under 48 – set it to 48

  Code Block
  language sql
  begin   rdsadmin.rdsadmin_util.set_configuration(      name  => 'archivelog retention hours',                       value => '48'); end; /

• Enable Force Logging.

  Code Block
  exec rdsadmin.rdsadmin_util.force_logging(p_enable => true);​

• Enable Block Change Tracking – optionally, but highly recommended

  Code Block
  exec rdsadmin.rdsadmin_rman_util.enable_block_change_tracking;​

Source/Staging host config

1. Install s3fs on Staging Server.

   Code Block
   yum install epel-release yum install s3fs-fuse

...