Restoring an existing database on Windows

  1. Make sure that the database environment is healthy. Check the existing database, the database server that hosts the existing database, and the computer that hosts the database server.
  2. On the computer that hosts the Enforce Server, navigate to
    Start > All Programs > Administrative Tools > Services
    . This navigation opens the Windows Services menu.
  3. From the Windows Services menu, stop all Symantec Data Loss Prevention services in the following order:
    • SymantecDLPDetectionServerService
      (on the computer or computers hosting a detection server)
    • SymantecDLPDetectionServerControllerService
      (on the computer hosting the Enforce Server)
    • SymantecDLPIncidentPersisterService
      (on the computer hosting the Enforce Server)
    • SymantecDLPManagerService
      (on the computer hosting the Enforce Server)
    • SymantecDLPNotifierService
      (on the computer hosting the Enforce Server)
  4. On the computer that hosts the database, stop all of the Oracle services.
  5. Copy the contents of the
    \Program Files\Symantec\DataLossPrevention\SymantecDLP_Backup_Files\Database
    directory to the
    %ORACLE_BASE%\oradata\protect
    directory (for example,
    C:\oracle\oradata\protect
    ) on the computer that hosts the new database. The information about the computers and directories is located on the Recovery Information Worksheet.
  6. To open Oracle SQL*Plus, navigate to
    Windows > Start > All Programs > Oracle - OraDb
    <ver>
    _home1 > Application Development > SQL Plus
    . This navigation assumes the default locations from the Oracle installation process.
    This process is described in the
    Symantec Data Loss Prevention
    Installation Guide
    .
  7. At the
    SQL>
    command prompt, to connect as the sysdba user, enter:
    connect sys\
    password
    as sysdba
    where
    password
    is the
    SYS
    password.
    See the
    Symantec Data Loss Prevention
    Installation Guide
    .
  8. At the
    SQL>
    prompt, enter:
    startup