Managing Autonomous Container Databases
Learn how you can create, view, move, change backup policies, manage maintenance schedules, and perform other Oracle Autonomous Container Database management.
An Autonomous Container Database resource provides a container for your Autonomous Databases. You can create multiple Autonomous Container Database resources in a single Autonomous Exadata VM Cluster resource, but you must create at least one before you can create any Autonomous Databases.
- Create an Autonomous Container Database
- View a List of Autonomous Container Databases
- View Details of an Autonomous Container Database
- Schedule a Quarterly Maintenance Update
- Rotate CDB Encryption Key
- Change the Backup Retention Policy of an Autonomous Container Database
- Change the Maintenance Schedule of an Autonomous Container Database
- Restart an Autonomous Container Database
- Move an Autonomous Container Database to Another Compartment
- Terminate an Autonomous Container Database
- Using the API to Manage Autonomous Container Databases
Parent topic: Autonomous Database on Exadata Cloud@Customer
Create an Autonomous Container Database
You can create Autonomous Container Databases (ACD) with the 23ai database software version only on Autonomous Exadata VM Clusters (AVMC) created on or after May 28, 2024, with the appropriate Tags. See 23ai Database Software Version Tag Requirements for details.
Related Topics
Parent topic: Managing Autonomous Container Databases
View a List of Autonomous Container Databases
- View the List of Autonomous Container Databases in an Autonomous Exadata VM Cluster
- View the List of Autonomous Container Databases in a Compartment
Parent topic: Managing Autonomous Container Databases
View the List of Autonomous Container Databases in an Autonomous Exadata VM Cluster
Parent topic: View a List of Autonomous Container Databases
View the List of Autonomous Container Databases in a Compartment
- Open the navigation menu. Under Oracle Database, click Exadata Database Service on Cloud@Customer.
- Click Autonomous Container Databases.
- Under List Scope, select a compartment from the Compartment drop-down list.
Parent topic: View a List of Autonomous Container Databases
View Details of an Autonomous Container Database
Parent topic: Managing Autonomous Container Databases
Update Autonomous Container Database Maintenance Preferences
Parent topic: View Details of an Autonomous Container Database
Schedule a Quarterly Maintenance Update
You can schedule a one-time maintenance activity to update time zone file for an Autonomous Container Database. For ACDs with Oracle Home version prior to the latest release, you can also choose to update to the latest RU along with the time-zone file update in this schedule.
For on-demand maintenance updates with a time-zone file update, the standby ACD will be patched 3 days before the primary ACD in autonomous Data Guard-enabled ACDs.
Parent topic: Managing Autonomous Container Databases
Rotate CDB Encryption Key
Follow these steps to rotate the TDE Master key. On key rotation, the ACD life cycle goes through the regular updating state and returns to available.
You can rotate the TDE Master key as many times as you want. The new TDE Master Key is stored in the same wallet in which the previous key was stored. Rotating the TDE Master Key leads to the new key being generated in OKV and assigned to this database. You can view all of the keys in OKV.
You can rotate both Oracle-managed and customer-managed encryption keys.
- Open the navigation menu. Under Oracle Database, click Exadata Cloud@Customer.
- Click Autonomous Container Databases.
- In the list of Autonomous Container Databases, click the display name of the database you wish to view details.
- On the Autonomous Container Database Details page, click Rotate Encryption Key.
- On the Rotate Encryption Key dialog, click Rotate Encryption Key.
Parent topic: Managing Autonomous Container Databases
Change the Backup Retention Policy of an Autonomous Container Database
By default, database backups are retained for 30 days if you have chosen Object Storage or NFS as a backup destination. You have the option of retaining backups for 7, 15, 30, or 60 days. If you have chosen Local storage as a backup destination, then by default, database backups are retained for a maximum of 7 days. If you have chosen Recovery Appliance as a backup destination, then you cannot update the backup retention policy.
The current backup retention policy for an Autonomous Container Database is displayed on the Autonomous Container Database details page.
- Open the navigation menu. Under Oracle Database, click Exadata Database Service on Cloud@Customer.
- Click Autonomous Container Databases.
- In the list of Autonomous Container Databases, click the display name of the container database you are interested in.
- On the Autonomous Container Database details page, under Backup, click the Edit link in the Backup retention policy field.
- Specify a backup retention period from the list of choices.
- Click Update.
Parent topic: Managing Autonomous Container Databases
Change the Maintenance Schedule of an Autonomous Container Database
Parent topic: Managing Autonomous Container Databases
Restart an Autonomous Container Database
Follow these steps to restart an autonomous container database on an Oracle Exadata Database Service on Cloud@Customer system.
The restart of an autonomous container database occurs in a rolling fashion, first stopping and starting one of the container database's database instances and then stopping and starting its other database instance.
You cannot restart an autonomous container database if a backup is in progress on any of its autonomous databases.
Parent topic: Managing Autonomous Container Databases
Move an Autonomous Container Database to Another Compartment
- To move an autonomous container database you must have the right to manage it in its current compartment and in the compartment you are moving it to.
- As soon as you move an autonomous container database to a different compartment, the policies that govern the new compartment apply immediately and affect access to the autonomous container database. Therefore, both your and other Oracle Cloud users' access to it may change, depending on the policies governing the user account's access to resources. For example, a user may lose the ability to create autonomous databases in the autonomous container database, given its new compartment.
- Open the navigation menu. Under Oracle Database, click Exadata Database Service on Cloud@Customer.
- Click Autonomous Container Databases.
- In the list of Autonomous Container Databases, click the display name of the container database you wish to move.
- Click Move Resource.
- Select the new compartment.
- Click Move Resource.
Parent topic: Managing Autonomous Container Databases
Terminate an Autonomous Container Database
You must terminate all Autonomous Databases within a container database before you can terminate the container database itself.
- Open the navigation menu. Under Oracle Database, click Exadata Database Service on Cloud@Customer.
- Click Autonomous Container Databases.
- In the list of Autonomous Container Databases, click the display name of the infrastructure resource you are interested in.
- Click Terminate.
- In the confirmation dialog, type the name of the Autonomous Container Database, and then click Terminate Autonomous Container Database.
Parent topic: Managing Autonomous Container Databases
Using the API to Manage Autonomous Container Databases
For information about using the API and signing requests, see REST APIs and Security Credentials. For information about SDKs, see Software Development Kits and Command Line Interface.
The following table lists the REST API endpoints to manage Autonomous Container Databases.
Operation | REST API Endpoint |
---|---|
Create an Autonomous Container Database |
|
View a list of Autonomous Container Databases |
|
View details of an Autonomous Container Database |
|
Change the backup retention policy of an Autonomous Container Database |
|
Change the maintenance schedule of an Autonomous Container Database |
|
Restart an Autonomous Container Database |
|
Move an Autonomous Container Database to another compartment |
|
Rotate an Autonomous Container Database key |
|
Terminate an Autonomous Container Database |
|
Get the resource usage statistics of an Autonomous Container Database |
Parent topic: Managing Autonomous Container Databases