Restoring From a Backup
Use the Console or the command-line interface to restore from an existing backup to a new DB system in the same tenancy.
The backup of a paid DB system cannot be restored to an Always Free DB system. The backup of an Always Free DB system can be restored to:
- An Always Free DB system.
- A payable DB system in a paid or trial tenancy.
You cannot create a DB system that has the same IP address as a running DB system. If you want to use the same IP address, delete the running DB system. Also, you can let Oracle select an unused IP address from the subnet or define a new IP address for the new DB system using the IP address field on the Networking tab of the Advanced options. See Advanced Option: Connections.
When you create a new DB system from a backup, it retains the administrator credentials of the original DB system. When you restore an automatic, manual, final or operator backup, you restore the complete data of the original DB system in the same tenancy.
Using the Console
Use the Console to restore from an existing backup to a new DB system.
If you encounter
OutOfHostCapacity
work request error while creating a DB system
from a backup, see Resolving OutOfHostCapacity Error.
Using the CLI
Use the command-line interface to restore from a backup to a new DB system.
- A compartment, subnet, and backup OCID.
- The name of the availability domain.
- The administrator username and password for the parent DB system of the backup.
- A policy that permits you to create DB system in the compartment or tenancy.
- A properly configured CLI installation and the requisite SSH keys. See Command Line Interface.
- A properly configured VCN. See Creating a Virtual Cloud Network.
Related Topics
Supported Backup Restore Scenarios
HeatWave Service supports restoring a backup of a standalone or high availability DB system to a new DB system.
When you restore from standalone DB system to a high availability DB system, ensure the following:
- Primary keys exist on every table in the DB system.
- MySQL version is 8.0.24 or higher. You cannot enable high availability on earlier versions of MySQL.
Table 9-2 Supported Backup Restore Scenarios
Source | Target | Support |
---|---|---|
Standalone DB system |
|
Supported |
Standalone DB system with HeatWave cluster |
|
Supported - Only InnoDB data is restored. If the source has HeatWave Lakehouse enabled, the Lakehouse data is not restored. |
Standalone DB system with HeatWave cluster |
|
|
High availability DB system |
|
Supported |
High availability DB system with HeatWave cluster |
|
Supported - Only InnoDB data is restored. If the source has HeatWave Lakehouse enabled, the Lakehouse data is not restored. |
High availability DB system with HeatWave cluster |
|
|