Creating a New Database on Windows

Create a new database then copy the contents of the backup database to the new database.
  1. If you have not co-located the database and the database server, make sure that each is in a healthy state.
  2. This step assumes that the drive structure of the new database is the same as the drive structure of the old database. Perform the following tasks in the order presented:
    • Copy the contents of the
      \SymantecDLP_Backup_Files\Database
      directory to the
      \oracle\product\19.3.0.0\oradata\protect
      directory on the computer that hosts the new database. The information about the computers and directories is located on the Recovery Information Worksheet.
    • 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.
    • At the
      SQL>
      command prompt, to connect as the sysdba user, enter
      connect sys/
      password
      @protect as sysdba
      Where
      password
      is the password created for single- and two-tier installations.
    • At the
      SQL>
      prompt, enter
      startup
  3. If the drive structure of the new database is different from the drive of the old database, perform the following tasks in the order presented:
    • Edit the
      inittemp.ora
      file in the
      \SymantecDLP_Backup_Files\Recovery_Aid
      directory to reflect the drive structure of the new database. The information about this computer is in the Recovery Information Worksheet.
      The following parameters might need to be modified to accommodate differences in directory structure:
      *.background_dump_dest *.control_files *.core_dump_dest *.user_dump_dest
    • Rename the edited
      inittemp.ora
      file to
      initprotect.ora
      .
    • Copy the
      initprotect.ora
      file to the
      $ORACLE_HOME\database
      directory on the computer that hosts the new database.
    • Copy the contents of the
      \SymantecDLP_Backup_Files\Database
      directory to the
      \oracle\product\19.3.0.0\oradata\protect
      directory on the computer that hosts the new database. The information about this computer is in the Recovery Information Worksheet.
    • On the computer that hosts the new database, open Oracle SQL*Plus. Navigate to
      Windows > Start > All Programs > Oracle - OraDb19g_home1 > Application Development > SQL Plus
      .
      This navigation assumes that the default locations were accepted during the Oracle installation process. See Creating the Symantec Data Loss Prevention database on Windows for additional details.
    • At the
      SQL>
      command prompt, to connect as the sysdba user, enter:
      connect sys/
      password
      @protect as sysdba
      Where
      password
      is the password created for single- and two-tier installations.
    • At the
      SQL>
      prompt, enter:
      create spfile from pfile='%ORACLE_HOME%\database\ initprotect.ora';
    • To shut down, enter:
      shutdown
    • To start, enter:
      startup