How To Clone an Existing Autonomous Database?

Hello,

I will describe how to clone an existing Autonomous Database using the Oracle Cloud Infrastructure Console. You can use the cloning feature to create a point-in-time copy of your Autonomous Database for purposes such as testing or development.
There are 2wo types of Autonomous Database clones:
The full-clone option: It creates a database that includes the metadata and data from the source database.
The metadata-clone option: It creates a database that includes only the metadata from the source database.
You can use a running database to create a clone. For databases running on shared Exadata infrastructure, you can also use a backup as the source of your clone. When using a backup, you can select a listed backup to clone from, or create a point-in-time clone. Point-in-time clones contain all data up to a specified timestamp. The specified timestamp must be in the past.

Let me do a clone of an Autonomous Database to shared Exadata infrastructure

1- Open the navigation menu. Under Database, click Autonomous Transaction Processing or Autonomous Data Warehouse.
2- If you are not already in the correct compartment, then choose one from the Compartment drop-down in the List Scope section that contains the database you want to clone.
3- In the list of Autonomous Databases, click the display name of the database you want to clone.
4- Go to Actions, and then click Create Clone.

5- In the Create Autonomous Database Clone dialog, select the following:
Clone Type: Select the type of clone you want to create. Choose either Full Clone or Metadata Clone.
Clone Source: The clone source selection allows you to specify whether the clone is created from a running database or from a database backup. Select one of the following options:
Clone from running database: Creates a clone of a running database as it exists at the current moment.
Clone from a backup: Creates a clone from a database backup. If you choose this option, select one of the following options:
Specify a timestamp: Creates a point-in-time clone.
Select from a list of backups: Creates a clone using all data from the specified backup. To limit your list of backups to a specific date range, enter the starting date in the From field and the ending date in the To field.

Important Note: You must select a backup that is at least 2 hours old, or the clone operation will fail.

Database Information
Compartment:Your current compartment is the default selection.
Display Name: A user-friendly description or other information that helps you easily identify the resource. The display name does not have to be unique, and you can change it whenever you like. Avoid entering confidential information.
Database Name: The database name must consist of letters and numbers only, starting with a letter. The maximum length is 14 characters. Avoid entering confidential information.

Choose database version: Select a database version from the available versions.
CPU Core Count: You can enable up to 128 cores for your Autonomous Database. The actual number of available cores is subject to your tenancy’s service limits.
Auto Scaling: allows Autonomous Databaseto automatically increase the number of CPU cores by up to three times the assigned CPU core count value, depending on demand for processing.

Administrator Credential:Set the password for the Autonomous Database Admin user by entering a password that meets the following criteria. You use this password when accessing the Autonomous Database service console and when using an SQL client tool.

License Type
The type of license you want to use for the Autonomous Transaction Processing database. Your choice affects metering for billing. You have the following options:
My Organization Already Owns Oracle Database Software Licenses: This choice is used for the Bring Your Own License (BYOL) license type. If you choose this option, make sure you have proper entitlements to use for new service instances that you create.
Subscribe to New Database Software Licenses and the Database Cloud Service: This is used for the License Included license type. With this choice, the cost of the cloud service includes a license for the Database service.

6- Finally Click Create Autonomous Database Clone at the bottom of page.
7- The Console displays the details page for the new clone of your database and the service begins provisioning the Autonomous Database.

After a few minutes, our new clone autonomous database will be ready.

How To Scale Up/Down an Autonomous Database?

Hello,

I will describe how to scale your Autonomous Data Warehouse on demand by adding CPU cores or storage capacity.

1- Open the Oracle Cloud Infrastructure console
2- From the Oracle Cloud Infrastructure left navigation list click Autonomous Database.
3- On the Autonomous Databases page select an Autonomous Database instance from the links under the Name column.
4- From the Details page click Scale Up/Down

5- On the Scale Up/Down dialog box, select the change in resources for your scale request.
Click up arrow to select a value for CPU Core Count.
Click up arrow to select a value for Storage (TB).

Here if you want to enable auto scaling, select Auto Scaling. Select auto scaling to allow the system to automatically use up to three times more CPU and IO resources to meet workload demand, compared to the database operating with auto scaling disabled.

6- Click Update to change your resources.
7- the Lifecycle State changes to Scaling in Progress.

To see the average number of OCPUs used during an hour you can use the “Number of OCPUs allocated” graph on the Overview page on the Autonomous Data Warehouse service console.

Starting, Stopping, Restarting and Terminating an Autonomous Database

Hello,
In this blog post I will describe the necessary steps to start/stop/terminate an Autonomous Database.

To Start an Autonomous Data Warehouse;

1- Select the Oracle Cloud Infrastructure left navigation list click Autonomous Data Warehouse.
2- On the Autonomous Databases page select an Autonomous Data Warehouse instance from the links under the Name column
3- On the Details page, from the More Actions drop-down list, select Start. Start is only shown for a stopped instance.

4- Click Start to confirm

To Stop an Autonomous Data Warehouse

1- Select the Oracle Cloud Infrastructure left navigation list click Autonomous Data Warehouse.
2- On the Autonomous Databases page select an Autonomous Data Warehouse instance from the links under the Name column.
3- On the Details page, from the More Actions drop-down list, select Stop.

4- Click Stop to confirm.

To Restart an Autonomous Data Warehouse

1- Select the Oracle Cloud Infrastructure left navigation list click Autonomous Data Warehouse.
2- On the Autonomous Databases page select an Autonomous Data Warehouse instance from the links under the Name column.
3- On the Details page, from the More Actions drop-down list, select Restart.

4- In the confirmation dialog, select Restart to confirm.

To Terminate an Autonomous Data Warehouse

Terminating an Autonomous Data Warehouse database permanently deletes the instance and removes all automatic backups. So you cannot recover a terminated database.

1- Select the Oracle Cloud Infrastructure left navigation list click Autonomous Data Warehouse.
2- On the Autonomous Databases page select an Autonomous Data Warehouse instance from the links under the Name column.
3- On the Details page, from the More Actions drop-down list, select Terminate.

4- On the Terminate Database page enter the database name to confirm that you want to terminate the database. And click Terminate Autonomous Database button.

How To Restore an Oracle Autonomous Database?

Hello,

In this blog post, I will describe how to restore an Autonomous Database from a backup using the Oracle Cloud Infrastructure Console. You can use any existing manual or automatic backup to restore your database, or you can restore and recover your database to any point in time in the 60-day retention period of your automatic backups. For point-in-time restores, you specify a timestamp, and your database decides which backup to use for the fastest restore/recovery.

1- Open the navigation menu. Under Database, click Autonomous Transaction Processing or Autonomous Data Warehouse.
2- Choose your Compartment.
3- In the list of Autonomous Databases, find the database that you wish to restore.
4- Click the name of the Autonomous Database to display the database details.
5- Click the Restore button to open the restore dialog.

5- Click Select Backup.
6- Specify the date range for a list of backups to display.
7- Click Restore.
8- In the Autonomous Database detail page you can monitor the status of restore operation.


9- Click “Restore Autonomous Database” link under Work Request.

10- You can see log messages of restore process.

Let me show the necessary steps of an Autonomous Database using point-in-time restore.

1- Open the navigation menu. Under Database, click Autonomous Transaction Processing or Autonomous Data Warehouse.
2- Choose your Compartment.
3- In the list of Autonomous Databases, find the database that you wish to restore.
4- Click the name of the Autonomous Database to display the database details.
5- Click the Restore button to open the restore dialog.
6- Click Specify Timestamp.
7- Enter a timestamp. Your Autonomous Database decides which backup to use for faster recovery. The timestamp input allows you to specify precision to the seconds level (YYYY-MM-DD HH:MM:SS GMT).

8- Click Restore.

Backing Up an Oracle Autonomous Database Manually

Hello,
In this blog post I will describe how to create manual backups of Autonomous Databases. You can use the Oracle Cloud Infrastructure Console. Oracle Cloud Infrastructure automatically backs up Autonomous Databases and retains these backups for 60 days. Automatic backups are weekly full backups and daily incremental backups. You can also create manual backups to supplement your automatic backups. Manual backups are stored in an Object Storage bucket that you create, and are retained for 60 days.

To see automatically taken backups
1- Open the navigation menu. Under Database, click Autonomous Transaction Processing or Autonomous Data Warehouse.
2- Choose your Compartment.
3- In the list of Autonomous Databases, find the database that you want to see backup.
4- Click Backups under Resources.

5- You can see all of backups.

6- Click Create Manual Backup.
7- In the Create Manual Backup dialog, enter a name for your backup. You must have an Object Storage bucket set up and configured to store manual backups.

Important! Please note that you must have an Object Storage bucket set up and configured to store manual backups. Please read this blog post to see how to setup Storage bucket

8- Click Create Manual Backup. Your backup may take several minustes/hours to complete, depending on the size of your database.

Optionally, you can check the state of your backup in the list of backups on the database details page.

Now, you can display manual backup files in the created bucket.