V11 SP8
Loading...

Getting Started - Documentum iDataAgent (SQL) Restore

Table of Contents

Overview

As restoring your backup data is very crucial, it is recommended that you perform a simple restore operation immediately after your first full backup to understand the process. The following sections explains the steps for performing simple browse and restore operations.

Prior to running your first restore operation, ensure the following:

  • Verify that the CommServe, MediaAgent and media library are powered on.
  • You have successfully done a backup of the data to be restored.
  • Verify that the media from which you wish to perform the restore is available in the CommCell. Use the List Media feature to identify the media required by the restore operation.
  • Always ensure that sufficient space has been allocated for the restore.

Restores can be run on-demand or can be scheduled to be run at a later point of time.

What Gets Restored

The Documentum iDataAgent restores up the following types of data:

  • Storage Areas
  • User selected database

Running a Restore from the CommCell Console

The restore operation can be done using one of the following methods:

  • File-level Browse and Restore, which is useful when you want to restore documents.
  • Component-level Browse and Restore, when you want to restore components of a Documentum Repository (database, storage area, or full-text indexes).

For this first simple restore, let us perform an in-place restore of documents and components of a Documentum Repository.

Documentum File Browse and Restore

This type of Browse and Restore is geared towards end-users and illustrates performing a basic browse and restore of documents:

  1. From the CommCell Browser, to browse and restore documents, select one of the following methods:
    • From the CommCell Browser, navigate to Client Computers | <Client> | Documentum.
    • Right-click the <Instance>, point to All Tasks, and then click Browse and Restore.

    • From the CommCell Browser, navigate to Client Computers | <Client> | Documentum | <Instance>.
    • Right-click the default subclient and click Browse and Restore.

  2. Select the Documentum View check box and specify a subclient (such as default) that contains documents.
  3. Click View Content.

  4. In the right pane of the Browse window, click the <Instance> and select all the entities.

    Click Recover All Selected.

  5. From the Restore Options for All Selected Items dialog box, specify the following:
    1. Select the name of the source client computer in the Destination Client from the list.
    2. By default Restore to same folder check box is selected to perform an in-place restore.
      • Clear  the Restore to same folder check box and type the path in Specify Documentum Destination Folder Path for an out-of-place restore.
    3. Select Create Entities in Repository check box to check the documents into the Documentum Repository.
    4. In Specify Destination Path for Storage Area Files, enter the file system path on the destination computer to which the files will be restored. Typically, this would be a system path on the Primary Content Server. Click one of the following:
      • Current Active Version to check the file in with the same version number that is currently active in Documentum.
      • Next Minor Version to check the restored file to the next Minor Version. For example, if the restored document was a Minor version (e.g., 1.2), it will be check it into the next Minor version (e.g., 1.3). If the restored document is a Major version (e.g., 2.0), it will be checked into the next Minor version (e.g., 2.1).
      • Next Major Version to check-in the file to the next major version. For example, if the restored document was a Major version (e.g., 2.0), it will check it into the next Major version (e.g., 3.0). If the restored document was a Minor version (e.g., 1.2), it will check it into the next Major version (e.g., 2.0).
    5. In When Storage Area File Exists, by default Skip is selected to specify that if an item is selected for restore and that item already exists, it will not be restored.
      • Click Unconditional Overwrite to specify if the restored data is to be unconditionally written to the specified location.
    6. Select Impersonate User check box and type the username, password and confirm password to specify the DB2 user account used by the system to perform restore operations for this instance.
    7. Click OK.
  6. Click the Job Initiation tab.

    Select Immediate to run the job immediately.

    Click OK.

  7. You can monitor the progress of the restore job in the Job Controller window of the CommCell Console.
  8. Once the restore job is complete, right-click the defaultBackupSet , point to View, and then click Restore History.
  9. Click OK.
  10. You can right-click the job and view the following details:
    • View Restore Items

      You can view them as Successful, Failed, Skipped or All.

    • View Job Details
    • View Events of the restore job
    • View Log files of the restore job

Component-Level Browse and Restore

This type of Browse and Restore is geared towards administrators and illustrates performing a basic browse and restore of all components of a Documentum Repository (database, storage area, or full-text indexes).

To ensure consistent restores, it is recommended to shutdown the Documentum Repository and the database in an appropriate mode before restoring.

  1. From the CommCell Browser, to browse and restore documents, select one of the following methods:
    • From the CommCell Browser, navigate to Client Computers | <Client> | Documentum.
    • Right-click the <Instance>, point to All Tasks, and then click Browse and Restore.

    • From the CommCell Browser, navigate to Client Computers | <Client> | Documentum | <Instance>.
    • Right-click the default subclient and click Browse and Restore.

  2. Click View Content.

  3. Expand the Documentum and select the components such as Storage Area, Full-Text Index and Database to be restored.

    For the first restore job, select any folder with smaller data size.

    Click Recover All Selected.

  4. By default, Overwrite Files and Overwrite if file on media is newer is selected to overwrite all backed up storage areas.
  5. By default, Restore to same folder is selected to restore the storage area to the same folder.

  6. Click the Job Initiation tab.

    Select Immediate to run the job immediately.

    Click OK.

  7. You can monitor the progress of the restore job in the Job Controller window of the CommCell Console.
  8. Once the restore job is complete, right-click the defaultBackupSet , point to View, and then click Restore History.
  9. Click OK.
  10. You can right-click the job and view the following details:
    • View Restore Items

      You can view them as Successful, Failed, Skipped or All.

    • View Job Details
    • View Events of the restore job
    • View Log files of the restore job

Running a Restore Using the Workflow

Note: Workflows must be deployed before they can be executed. For instructions on deploying a workflow, see Deploying a Workflow.

  1. From the CommCell Browser, go to Workflows.

    The Workflows window appears in the pane on the right.

  2. Right-click the SQL Restore Workflow and click All Tasks > Execute.

    The SQL Restore Workflow Options dialog box is displayed.

  3. From the Run workflow on list, select the engine to use to execute the workflow.
  4. Provide values for the workflow inputs. The following table provides examples of data you can enter in each box:
    Workflow input Description Example
    SQL Client Name of the SQL Agent client. DBSERVE52
    SQL Instance Name of the SQL instance configured on the SQL Agent client. dbserve52
    SQLDestClient Name of the SQL Agent client where the database has to be restore.

    If restore is performed on the same machine, specify the same name as the SQL Client. If the restore is performed on a different machine, specify a different name than the SQL Client.

    DOCMSSQL
    SQLDestInstance Name of the destination SQL instance. DOCMSSQL\SQLEXPRESS
    DocClient Name of the Documentum Agent client. DBSERVE52
    DocInstance Name of the instance configured on the Documentum Agent client. dctmsql
    DocDestClient Name of the Documentum Agent client where the database has to be restore.

    If restore is performed on the same machine, specify the same name as the DocClient. If the restore is performed on a different machine, specify a different name than the DocClient.

    dbserve50
    DocDestInstance Name of the destination Documentum instance. dctmrep
    SQLDatabase Name of the SQL database that has to be restored. DM_DOCUSQL_DOCBASE2
    SQLDBRestoreToTime End time of the SQL database backup job. 9-3-2015 15:42:28
    inPlace Select the check box if you are performing an In-Place restore.

    Do not select it if you are performing an Out-of-Place restore.

    NA
    DocSAoutplacePath Destination path for Documentum Storage Area file restore. E:\temp
    MSSQLDBnameforoutrestore SQL database name for Out-of-Place restore. DM_DOCUSQL_DOCBASE2_NEW
    MSSQLDBoutplacePath Destination path for SQL database restore. C:\workflow_out\DM_DOCUSQL_DOCBASE2.mdf
    MSSQLLOGnameforoutrestore SQL database log name for Out-of-Place restore. DM_DOCUSQL_DOCBASE2_log
    MSSQLLOGoutplacePath Destination path for SQL database log restore. C:\workflow_out\DM_DOCUSQL_DOCBASE2_log.mdf
  5. Click OK. You can track the progress of the job from the Job Controller window of the CommCell console. Once the restore job is complete, right-click the defaultBackupSet , point to View, and then click Restore History.

Note: You can restore the SQL database components using the workflow or the SQL Server Agent.