Previous Topic: General Backup TasksNext Topic: Cold Backups

Database Guide › Database Backups › Backup Tasks for Oracle

Backup Tasks for Oracle

If you use Oracle as your database engine, the backup procedure has three steps. First, you must back up essential registry keys on your CMS. Second, you must set up a backup schedule for your Oracle database. Third, you must add the CA DataMinder data folder into your existing backup regime.

  1. Back up the master encryption key

    See the general backup tasks.

  2. Cold backups only: Suspend the CMS

    If you are running a cold backup, you must first suspend the CMS. See the next section for details. Note that we do not recommend this method.

  3. Back up your Oracle database

    Note: This section describes the basic procedure for backing up an Oracle database. Experienced Oracle administrators may prefer other methods for configuring backup jobs.

    1. In the Oracle DBA Studio, launch the Backup wizard and choose your backup strategy. This can be predefined, or you can define a custom strategy.
    2. Next define the backup frequency. A typical CA DataMinder database will be large and frequently updated, so we recommend that you choose a full back up of your CMS every week, with incremental backups every day.
    3. Specify what time the backups run. You can monitor the status of completed backup jobs in the Oracle Enterprise Manager Console.
    4. Specify the backup configuration. If you have already defined a custom backup configuration, you can choose that configuration now.
    5. Finally, choose the destination database for the backup job. In this case, submit the job to the CA DataMinder database.
  4. Back up your CA DataMinder data folder

    See the previous section, ‘Back up the Data folder: For all CMSs. This folder holds all the configuration data and captured data used by your CA DataMinder installation. We recommend you back up this folder a minimum of once a week, but a daily backup is preferential. By default, when you install CA DataMinder this folder is added as a Data subfolder in the installation folder, but you can rename it and locate it anywhere suitable on your network.’.

  5. Cold backups only

    Resume the CMS

More information:

Backup Tasks for SQL Server

General Backup Tasks

Cold Backups