Recover Oracle Databases

Once you have protected your Oracle Databases, you can recover them from Cohesity DataProtect as a Service to their original or a new location.

To recover protected Oracle Databases:

  1. Go to Sources to set up your recovery task.

  2. Click into the Source name.

  3. Click the Recover icon.

  4. Select the Recovery Type:

    • Databases to recover an entire database.

    • Archive Logs to recover just the archive logs.

  5. Under Targets, select Alternate Database or Overwrite Original Database.

    1. For Alternate Database:

      • Oracle Host. Provide the hostname to which you want to restore the database.

      • Configure Channels:

        • System selects active node. Selecting this option auto-selects an active single-instance Oracle node and configures the number of RMAN channels for the database object. (Default)

        • Select specific node(s). If you select this option, you can choose the number of RMAN channels and the SBT library path to be used for the database object.

      • Recovery Options. Enter:

        • Restore Database Files to. Specify the path to an existing empty directory. The newly created database files will reside in this path.

          You can restore to an ASM path using this option. If you do, enter just the ASM volume name instead of the entire path. For example, if the restore path for ASM volume data1 is “+data1” and you enter the entire path, +data1/dbname, the restore task will fail.

        • Oracle Home. The ORACLE_HOME value for the host where the database is restored.

        • Base Directory. The directory for the restored database.

        • Target Database Name. The name for the target database to recover the database components and data files.

        • Enable Archive Log mode for the Database. Select the checkbox to enable redo log archiving on the recovered database.

        • BCT File Path. The BCT file path specifies the location where the block change tracking file will be created. If not provided, BCT is not enabled for the restored database.

        • Leave database in Recovery Mode. Select the checkbox if you do not want the recovered database to be opened.

        • Shell Environment. Configure your shell environment that executes the Cohesity DataProtect as a Service restore tasks. For example, define your TNS_ADMIN shell variable here to point to a different sqlnet.ora file for use as the restore target database. For TDE support, the wallet location for your restore target database might depend on a shell variable. Use this to specify your wallet location for restoring a backup taken from a TDE database.

        • Task Name. Change the default name of the recovery task.

    2. For Overwrite Original Database:

      • Leave database in Recovery Mode. Select the checkbox if you do not want the recovered database to be opened.

      • Shell Environment. Configure your shell environment that executes the restore tasks. For example, define your TNS_ADMIN shell variable here to point to a different sqlnet.ora file for use as the restore target database. For TDE support, the wallet location for your restore target database might depend on a shell variable. Use this to specify your wallet location for restoring a backup taken from a TDE database.

      • Task Name. Change the default name of the recovery task.

  6. Click Recover.