Backup Content Configuration Properties for Amazon RDS Instances

Based on the database type selected while configuring the instance, under Connection details, enter the following information:

Database Type

Backup Content properties

Amazon Aurora MySQL

  • From the Credential list, select a saved credential or add a new credential.

  • To specify the endpoint, in the Endpoint box, enter the name of the endpoint to connect to the database instance.

    The endpoint value is automatically discovered and displayed, based on the instance you previously selected. By default, the discovered endpoint is the cluster endpoint and is used for both read-only access (backups) and write access (restores). For more information, refer to the Amazon Aurora endpoint connections documentation.

    Note

    For Amazon Aurora Global Database cluster, enter the endpoint name of the global writer.

Amazon Aurora PostgreSQL

  • From the Credential list, select a saved credential. You can also add a new credential.

  • In the Maintenance DB box, type the name of the system database that is used as the maintenance database.

  • In the Endpoint box, type the name of the endpoint to connect to the database instance.

    The endpoint value is automatically discovered and displayed, based on the instance you previously selected. By default, the discovered endpoint is the cluster endpoint and is used for both read-only access (backups) and write access (restores). For more information, refer to the Amazon Aurora endpoint connections documentation.

    Note

    For Amazon Aurora Global Database cluster, enter the endpoint name of the global writer.

MariaDB

  • From the Credential list, select a saved credential. You can also add a new credential.

  • To specify the endpoint, in the Endpoint box type the endpoint to connect to the database instance in the format <ip/host>:<port>.

MySQL

  • From the Credential list, select a saved credential or add a new credential.

  • In the Endpoint box, type the name of the endpoint to connect to the database instance.

    Note

    For Multi-AZ DB cluster, enter the endpoint name of the cluster with writer access.

PostgreSQL

  • From the Credential list, select a saved credential. You can also add a new credential.

  • In the Maintenance DB box, type the name of the system database that is used as the maintenance database.

  • In the Endpoint box, type the name of the endpoint to connect to the database instance.

    Note

    For Multi-AZ DB cluster, enter the endpoint name of the cluster with writer access.

SQL Server

  • In the S3 bucket name box, enter the name of an S3 bucket in the AWS account, for temporarily staging the data.

    Use a pre-created S3 bucket on the RDS instance.

  • From the SQL server authentication list, select an existing credential or new credential for the SQL server.

    Steps to add new credential
    1. Click the add button add/plus button - gray - no border.

      The Add credential dialog box appears.

    2. The Account type, Database type, and Credential Vault are selected by default.

    3. In the Credential name box, enter the name for the credential.

    4. In the Username box, enter the user name to access the application.

    5. In the Password box, type the password to access the application.

    6. In the Description box, enter a description of the credentials.

    7. Click SAVE.

    Note

    To use an Active Directory (AD) account for the backup, configure an Active Directory admin for that instance on the Amazon AWS portal. The AD account must be a local administrator on the access node and along with all permissions for a non-master user must have a “Create any database” securable permission on the RDS SQL instance. You must enter the user details in user_name@domain_name format. You can provide the AD account credentials in the SQL Agent Authentication tab at the agent level or in the Accounts tab at the instance level. The AD account credentials are honored only when the server admin is not set at both the agent and instance levels.

  • To specify a custom port to be used for the instance, in the Port box, type the port number.

Oracle

  • In the Connect string box, select the existing credentials or add new credentials.

    Steps to add a credential
    1. Click the + icon beside the credentials list.

      The Add Credential dialog box appears.

    2. In the Credential name box, enter a unique name to access the credential.

    3. Under Connect string, enter the following details to access the Oracle server.

      • In the User name box, type the user name to access the RDS application.

      • In the Password box, type the password to access the RDS application.

      • In the Service name box, enter the Oracle service name.

    4. In the Description box, enter a brief description for the credential.

    5. Click Save.

  • To use SSL for the connection, move the Use SSL toggle key to the right and type the port number.

    TLS 1.2 is supported.

  • Does not apply to Use hosted infrastructure option: If you want to use Amazon EFS as the RMAN staging location, move the Enable EFS integration toggle key to the right, and then configure the following:

    1. In EFS ID, enter the ID of the EFS file system to mount to the RDS Oracle instance.

    2. In EFS Path, enter the directory path on the EFS file system where RMAN backup files will be stored.

    3. In EFS Mount Point, specify the mount location used by the integration to write RMAN backup files.

    4. Based on the mount point provided above, enable or disable the Access Point EFS Path toggle key to indicate whether an EFS access point is being used.

  • If you want use Amazon S3 as the RMAN staging location, in the S3 bucket box, enter the target S3 bucket name.

For more information on the prerequisites for integrating Amazon S3 or EFS, see Configuration for Amazon RDS for Oracle.

×

Loading...