Strategies for Backing up and Restoring Oracle Autonomous Data Warehouse

To ensure effective backup and recovery of your Oracle Autonomous Data Warehouse, it’s important for you understand how each object was originally created and populated. By accounting for these origins, you can design a backup strategy that captures all critical components of your data warehouse.

Oracle Autonomous Data Warehouse objects are typically created in one of the following ways:

  • Oracle Fusion Data Intelligence Pre-built Pipelines

    Objects are automatically created and populated by the Oracle Fusion Data Intelligence's standard, pre-built data pipelines. These objects don’t require separate backups. If you need to restore, use the Reset the Data Warehouse option to restore the objects created by pre-built data pipelines.

  • User-Defined Configurations

    Objects are generated through Oracle Fusion Data Intelligence’s built-in configuration options (for example, data augmentations or custom user-defined configurations). These objects also don’t require separate backups. If you need to restore, use the Reset and Reload the Data Source option to restore the user defined configurations.

  • Manual Methods

    Objects that are created or populated manually, such as through direct database interactions (for example, PL/SQL scripts, query editors) or Extract, Transform, and Load (ETL) tools. These objects require backup. Oracle recommends you use Oracle Data Pump to backup up and restore these objects.

When backing up and restoring the Oracle Autonomous Data Warehouse objects to another instance, follow these manual processes.

Area Artifact Bundles Manual Backup and Restore Strategy
Custom database objects
  • Custom database schemas and all objects within the custom schema
  • Custom objects within OAX_USER schema
 No Yes See Backing Up and Restoring Oracle Autonomous Data Warehouse Objects and Data mentioned later in this table.
Database objects created from Oracle Fusion Data Intelligence Console configurations Database objects created or updated by data pipeline No Yes Reset the Data Warehouse
Database objects created from Oracle Fusion Data Intelligence Console configurations Database objects created or updated by data augmentation No Yes Reset and Reload the Data Source
Database objects created from Oracle Fusion Data Intelligence Console configurations Database objects created or updated by custom data configurations (such as Configurable Account Analysis and Fusion Accounting Hub) No Yes Advanced Configurations
Database objects created from Oracle Fusion Data Intelligence Console configurations Database objects created or updated by the Frequent Data Refresh process No Yes Schedule Frequent Data Refreshes