Oracle Cloud Infrastructure Documentation

Managing Autonomous Database Resources

After provisioning any OracleDB@GCP resource, you can use the Google Cloud console for a limited set of management functions. Some functions and features require use of the OCI console for management or implementation.

Common Management Functions from the Google Cloud Console

The following management functions are available for all resources from the Google Cloud console for that resource.

Access the resource console

  1. From the Google Cloud console, select Oracle Database@Google Cloud application.
  2. You have two options. One, from the left menu, select Autonomous Database. Two, from the center panel, select the EXPLORE AUTONOMOUS DATABASE button.
  3. If the console lists and manages several resources, select the resource type at the top of the console.

List status for Autonomous Databases

  1. Follow the steps to Access the resource console.
  2. Resources will be shown in the list as Succeeded, Failed, or Provisioning.
  3. Access the specifics of that resource by selecting the link in the Display Name field in the table.

Provision a new Autonomous Database

  1. Follow the steps to Access the resource console.
  2. Select the + Create icon at the top of the console.
  3. Follow the provisioning flow for Provisioning an Autonomous Database.

Refresh the console's info for Autonomous Databases

  1. Follow the steps to Access the resource console.
  2. Select the Refresh icon at the top of the console.
  3. Wait for the console to reload.

Start/stop/restart an Autonomous Database

  1. Follow the steps to List status for all Autonomous Databases.
  2. Access the specific Autonomous Database by selecting the link in the Display Name field in the table.
  3. If the Autonomous Database is stopped, there will be a START icon at the top of the page. Select the START icon to start the Autonomous Database.
  4. If the Autonomous Database is started, there will be STOP and RESTART icons at the top of the page. Select the STOP icon to stop the Autonomous Database. Select the RESTART icon to stop the Autonomous Database.
  5. Whether you are starting, stopping, or restarting an Autonomous Database, a modal window appears asking you to confirm your action. You can CANCEL your action, or select START, STOP, or RESTART to perform that action.

Remove an Autonomous Database

  1. Follow the steps to Access the resource console.
  2. You can remove a single Autonomous Database from the console by selecting the vertical elipsis on the right side of the table. Once you have selected the resource(s) to remove, you can then select the Delete icon.
List the backups for an Autonomous Database
Note

There are two (2) types of backups. Auto backup backups are created based on the backup settings selected when provisioning an Autonomous Database. Long-term backup backups are specifically created and can be retained for a minimum of three (3) months and a maximum of ten (10) years.
  1. Follow the steps to Access the resource console.
  2. Access the specific Autonomous Database by selecting the link in the Display Name field in the table.
  3. Select the BACKUPS tab.
  4. In the Backups section, you will see the list with timestamps for the available backups.

Create a Long-term backup

  1. Follow the steps to List the backups for an Autonomous Database.
  2. Select the link to the Autonomous Database from the Display Name field in the table.
  3. Select the BACKUPS tab.
  4. In the Backups section, you will see the list with timestamps for the available backups.
  5. Select the CREATE LONG-TERM BACKUP icon at the top of the list of available backups.
  6. The Create long-term backup modal window opens.
  7. Set the Retention period values, including Years (365 days), Months (30 days), and Days. These values must be more than the minimum of three (3) months and less than the maximum of ten (10) years.
  8. If you want to create a schedule for long-term backups, select the Schedule long-term backup checkbox.
    1. Select the Date and Time for the first long-term backup to start.
    2. Select the Repeat value that is appropriate for your long-term backup.
  9. Select the SAVE button to save your long-term backup schedule, or the CANCEL button to return without saving the schedule.

Manage Auto backup Settings

  1. Follow the steps to List the backups for an Autonomous Database.
  2. Select the link to the Autonomous Database from the Display Name field in the table.
  3. Select the BACKUPS tab.
  4. In the Backups section, you will see the list with timestamps for the available backups.
  5. Select the EDIT button for the Automatic backup retention period.
  6. Select the new Backup retention period in days from 1 to 60 days.
  7. Select the SAVE button to save your long-term backup schedule, or the CANCEL button to return without saving the schedule.

Access the OCI console

  1. Follow the steps to Access the resource console.
  2. Select the link to the Autonomous Database from the Display Name field in the table.
  3. Select the MANAGE IN OCI icon at the top of the details page.
  4. Manage the resource from within the OCI console.

Perform a connectivity test

  1. Follow the steps to Access the OCI console.
  2. Navigate to the Autonomous Database Details page.
  3. Select the Database Connection.
  4. Select the Download wallet button.
  5. Open Oracle SQL Developer. If you don't have SQL Developer installed, download SQL Developer and install.
  6. Within SQL Developer, open a new connection with the following information.
    1. Name - Enter a name of your choice used to save your connection.
    2. Username - Enter ADMIN.
    3. Password - Enter the password used when creating the Autonomous Database.
    4. Role - Select default.
    5. Save Password - Select the box if you security rules allow. If not, you will need to enter the PDB password every time you use this connection in SQL Developer.
    6. Connection Type - Select Cloud Wallet.
    7. Configuration File - Select Browse, and select the wallet you downloaded.
    8. Select the Test button. The Status at the bottom of the connections list, should show as Success. If the connection is not a success, the wallet is out of date, or the ADB is not currently running.
    9. Select the Save button.
    10. Select the Connect button.

Support for OracleDB@GCP

  1. Follow the steps to Access the OCI console.
  2. From the OCI console, there are two ways to access support resources.
    1. At the top of the page, select the Help (?) icon at the top-right of the menu bar.
    2. On the right-side of the page, select the floating Support icon. NOTE: This icon can be moved by the user, and the precise horizontal location can vary from user to user.
  3. You have several support options from here, including documentation, requesting help via chat, visiting the Support Center, posting a question to a forum, submitting feedback, requesting a limit increase, and creating a support request.
  4. If you need to create a support request, select that option.
  5. The support request page will auto-populate with information needed by Oracle Support Services, including resource name, resource OCID, service group, service, and several other items dependent upon the specific OracleDB@GCP resource.
  6. Select the support option from the following options:
    1. Critical outage for critical production system outage or a critical business function is unavailable or unstable. You or an alternate contact must be available to work this issue 24x7 if needed.
    2. Significant impairment for critical system or a business function experiencing severe loss of service. Operations can continue in a restricted manner. You or an alternate contact are available to work this issue during normal business hours.
    3. Technical issue where functionality, errors, or a performance issue impact some operations.
    4. General guidance where a product or service usage question, product or service setup, or documentation clarification is needed.
  7. Select the Create Support Request button.
  8. The support ticket is created. This ticket can be monitored within the OCI console or via My Oracle Support (MOS).