Oracle Cloud Infrastructure Documentation

Managing an Autonomous Data Warehouse

This topic describes the infrastructure management tasks for Autonomous Data Warehouses that you complete using the Oracle Cloud Infrastructure Console or the API. Note that some database management tasks not covered here are performed using the Autonomous Data Warehouse service console.

Prerequisites

To perform the management tasks in this topic, you must be given the required type of access in a An IAM document that specifies who has what type of access to your resources. It is used in different ways: to mean an individual statement written in the policy language; to mean a collection of statements in a single, named "policy" document (which has an Oracle Cloud ID (OCID) assigned to it); and to mean the overall body of policies your organization uses to control access to resources. written by an administrator, whether you're using the Console or the REST API with an SDK, CLI, or other tool. If you try to perform an action and get a message that you don’t have permission or are unauthorized, confirm with your administrator the type of access you've been granted and which A collection of related resources that can be accessed only by certain groups that have been given permission by an administrator in your organization. you should work in. See Authentication and Authorization for more information on user authorizations for the Oracle Cloud Infrastructure Database service.

Using the Oracle Cloud Infrastructure Console

You can perform basic administrative tasks for Autonomous Data Warehouses in the Oracle Cloud Infrastructure Console including stopping, starting, and scaling your warehouses. You can also use the Console to back up or to restore the database.

To set the Admin password
To scale the CPU core count or storage of an Autonomous Data Warehouse
To stop or start an Autonomous Data Warehouse
To terminate an Autonomous Data Warehouse
To check the lifecycle state of your Autonomous Data Warehouse
To manage tags for your Autonomous Data Warehouse
To access the Autonomous Data Warehouse Service Console

Using the API

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.

Use these API operations to manage Autonomous Data Warehouse databases:

For More Information