Backing Up and Restoring the Repository

Before upgrading the Oracle Data Miner repository or performing a database upgrade, you should perform a full backup of Oracle Data Miner, including ODMRSYS and the Oracle Data Miner user schemas.

Oracle Data Miner also provides scripts for backing up the workflow metadata in ODMRSYS without including the user schemas.

• Full Backup and Restore
  For Oracle Databases 11.2.0.4 and later, you can perform a full backup and restore of the Oracle Data Miner repository and user schema independently of a full database backup.
• Workflow Only Backup
  Oracle Data Miner provides a script for backing up the workflow metadata in the repository without including the objects in the users' schemas that are generated by the workflows.
• Workflow Only Restore
  You can restore workflows from the backup table created by createxmlworkflowsbackup2.
• Workflow Only Restore Examples
  This topic provides examples on selective workflow restore and full workflow restore.