Skip to main content
Setting up Oracle database instance for Amazon RDS Custom
Updated over 4 months ago

Overview

Druva extends its backup and restore solution for Oracle databases over Amazon RDS Custom. You can now do away with exhaustive administration tasks such as provisioning, scaling, patching, and so on, and simply focus on backup and restore of your databases. All you need to do is create your database instance for Amazon RDS Custom and get going with your backup and recovery operations!

Creating and connecting to a database instance for Amazon RDS Custom

Perform the following steps to create a database instance for Amazon RDS custom:

  1. Log in to the AWS Management Console as an administrator.

  2. From the top navigation bar, in the search box, search for RDS and select Dashboard.

    RDS.png
  3. On the Dashboard, in the right pane, click Create database.

    rds_custom_2.png
  4. On the Create database page, do the following:

    1. In the Choose a database creation method section, select Standard create.

    2. In the Engine options section:

      1. Select the Engine type as Oracle.

      2. Select the Database management type as Amazon RDS Custom.

        rds_custom_3.png
  5. In the Edition field, retain the default value Oracle Enterprise Edition.

  6. From the Version drop down, select the Oracle Enterprise Edition version as 19c. This is also referred to as the custom engine version.

  7. In the Templates, select the template that matches your requirement.
    ​

    rds_custom_5.png
  8. In the Settings section:

    1. Provide the database instance name.

    2. In the Credential Settings section provide the user ID and password for the master user. You can either automatically generate a password by selecting the Auto generate a password checkbox or set the password manually by providing.
      ​

      rds_custom_6.png
  9. In the Storage section, provide storage requirements for your database instance such as storage type, size in Gigabytes, and so on.

    rds_custom_7.png
  10. In the Connectivity section, provide your Virtual Private Network (VPC) details such as VPC name, subnet group, access details, VPC security group details, and so on. You can select an existing VPC security group or create a new one.


    ❗ Important

    You cannot change VPC settings once the database is created.


    VPCSecurityGroup.png
  11. In the Database authentication section, select how you want to authenticate your database.

  12. In the Additional configuration section, provide information such as the database option, backup settings, encryption details, and so on.

  13. To encrypt your database instance, select Enable Encryption checkbox. Alternatively, you can select the Permissions profile in IAM.

  14. If you select the Enable Encryption checkbox, select AWS KMS Key from the drop-down.

    rds_custom_10.png

    A KMS key ID gets generated.

  15. The database instance automatically defaults to Full Automation.

    rds_custom_11.png
  16. In the Additional configuration section, provide details such as the database name, whether you want to enable automated backups, retention period for the backups, and the backup window.

    rds_custom_12.png
  17. (Optional) To protect your database from accidental deletions, select the Enable deletion protection checkbox.

    rds_custom_13.png
  18. Click Create database.
    You can see the newly created database as the DB identifier by clicking Databases in the left navigation pane.

    rds_custom_14.png

Next Steps

Perform the following steps to install the Hybrid Workloads agent for backup and restore:

  1. Once the database is created, pause the database. To pause the database:

    1. In the left navigation pane, go to Databases and select the database name from the database list.

    2. In the RDS Custom automation mode section,do the following:

      1. Select Paused.

      2. Specify the pause duration.

        rds_custom_15.png
  2. Login to your RDS custom virtual machine with your ssh key and deploy the Hybrid Workloads agent. For more information, see Install the agent and register Oracle Server.
    You need to scp the rpm to your RDS Custom vm in AWS EC2 and then load the rpm as the root you may sudo to root. The unix UID and GID of the Oracle database is rdsdb on an AWS RDS Custom vm.

  3. Use the following commands to install the rpm and stop and start the agent:

rpm -ivh druva-phoenix-oracle-client-5.1.0-170463.x86_64.rpm

systemctl stop PhoenixOracle

systemctl start PhoenixOracle

systemctl status PhoenixOracle


❗ Important

Before performing restore, make sure you disable the maintenance script on the oracle server, otherwise you will not be able to shutdown the instance and perform the recovery.


The agent is now activated. You can now backup and restore your Oracle databases and also monitor the respective jobs. For more information, see Backup and Restore Oracle Databases Direct to Cloud.

Did this answer your question?