Backing up a Production System

  1. Backing up a Production System
    1. Prerequisites
    2. Instructions
      1. 1. Locate Document Vault
      2. 2. Stop the Project.net application
        1. On WebLogic
        2. On Tomcat
      3. 3. Back up database
        1. For Oracle Enterprise
        2. Oracle XE
      4. 4. Backup Document Vault

The process of backing up a production installation of Project.net is fairly straightforward, with three main steps: turn off the application to prevent changes to the database during backup, backup the database tables, then backup the file store.

Prerequisites

  • Assumes Project.net has been deployed to a WebLogic server named PRM-1 and the database on an Oracle database server.
  • You will need to know the database server's hostname and the system password for the Project.net database instance.
  • The location of Project.net's document vault storage (see Step 1 below).
  • You will need your procedure for backing up the tables in a database.
  • A working copy of sqlplus. Normally, this is installed with the Oracle database, but if not, the Oracle instant client is sufficient.

Instructions

1. Locate Document Vault

If you do not know the location of the document vault storage complete this step, otherwise, skip to step 2.

  1. Log in to the Project.net server as a user with application administration priviledges.
  2. From the Personal Workspace, click "Application Space" on the lower left to enter the Application Administration interface.
  3. Select Manage / Doc Vault.
  4. Note the directory paths for each of the three Path to Repository Root.
  5. Log out of Project.net.

2. Stop the Project.net application

On WebLogic

  1. On your Project.net application server, start the Windows Services Monitor (Start / All Programs / Administrative Tools / Services).
  2. In the Windows Services console select the service named beasvc pnet_PRM-1.
    • This name will be different if you deployed Project.net on another WebLogic server than PRM-1
  3. Click the Stop the service link to the left.
  4. Confirm Project.net is no longer running by:
    1. Checking the Status column next to the beasvc pnet_PRM-1. It should say “Stopped” or the column will be blank.
    2. Attempting to open the Project.net login page from a browser will give a “Page not found” error.

On Tomcat

  1. cd CATALINA_HOME/bin/
  2. sh shutdown.sh

3. Back up database

On your database server, follow the procedures to back up the Project.net database tables for users pnet and pnet_user.

For Oracle Enterprise

To back up your database on Oracle Enterprise you need to open console windows and to run following two commands: 

exp userid=system/<system password>@<database name> file=pnet_dump_file_name.dmp owner=pnet
exp userid=system/<system password>@<database name> file=pnet_user_dump_file_name.dmp owner=pnet_user

Usernames used for those two commands are PNET/PNET_USER database users. You need to place proper passwords as well as database name.

Oracle XE

4. Backup Document Vault

Back up the contents of the document vault storage from Step 1.