Back Up and Restore

You might need to back up or restore Oracle Fusion Data Intelligence for several critical reasons, including business continuity, regulatory compliance or auditing, testing or development, and ensuring peace of mind.

Key scenarios for backup and restore:

  • Recovering from errors or unintended changes

    An effective backup and recovery plan considers all key components, including Oracle Cloud Infrastructure Identity and Access Management, Oracle Fusion Data Intelligence Console configurations, Oracle Analytics Cloud, and Oracle Autonomous Data Warehouse. This allows you to revert to a previous state that is free of errors and unintended changes across the solution stack.

  • Syncing test and development instances with production instance

    Backing up and restoring production data in test or development environments enables accurate replication for testing, development, or training. This approach allows you to experiment with new features, troubleshoot issues, or conduct training without impacting the production environment.

  • Cloning instances for disaster recovery (DR) or regional moves

    Backups are vital for rapid restoration after significant incidents such as natural disasters or major system failures. Maintaining a backup in another region enhances resilience against localized disasters or supports business needs for geographic relocation. This can be achieved through new subscriptions or an Additional Test Environment (ATE). See About Disaster Recovery.

  • Data loss prevention for custom objects and Autonomous Data Warehouse data

    Backing up data and custom objects stored in Oracle Autonomous Data Warehouse creates a reliable safety net. This protects your business from risks such as accidental deletions, overwrites, or unexpected disasters. See Custom Backup for Oracle Autonomous Data Warehouse.

Tools and features available to support the backup and restore operations for Oracle Fusion Data Intelligence:

  • Bundles

    Enables point-in-time snapshots of application artifacts, such as configurations and customizations, allowing easy backup and retrieval. See Bundle Your Application Artifacts.

  • Data Configuration Resets

    You have two options for reset:

    • Reset the Data Warehouse - Restore your data warehouse to a pre-built state. Resetting the data warehouse will lead to permanent deletion of all existing data. To resume data loading, you must reactivate all the functional areas; data will remain unavailable until the pipelines are complete.
    • Reset and Reload the Data Source - Reset and reload the data source to trigger a complete refresh, that will delete all your existing data and perform a full reload from the beginning, based on the defined initial extract date. This action applies to all active functional areas, augmentations, and custom data configurations.

  • Automatic Backups

    Oracle Autonomous Data Warehouse performs automated daily backups, ensuring ongoing data protection with minimal manual intervention. See Automated Backup for Oracle Autonomous Data Warehouse.

  • Data Pump

    Supports high-speed transfer of data and metadata between databases, facilitating both backup and migration activities. See Custom Backup for Oracle Autonomous Data Warehouse.

  • Manual Processes

    Involves capturing screenshots or manually exporting configuration data from the source system, an then manually entering or recreating in the target system. This method might be less efficient; however this method might be necessary for specific use cases or for supplementing the automated processes.

Refer to the backup and restore strategies for each component to facilitate your recovery should it be required. When backing up and restoring, utilize bundles when feasible. Perform the specified tasks manually for strategies where you can't use bundles to backup and restore.

Topics: