How to backup and restore Primavera P6 Oracle Express (XE) database

How to backup:

From the command prompt (go to ‘Start’ > ‘Run’ > type ‘cmd’ and click ‘OK’) using the format below

exp system/<password>@XE full=y file=<path>\xedump.dmp log=<path>\exp_xedump.log

Where:

  • <password> is the password you used when you installed P6 Standalone or Oracle XE manually.
  • <path> is the complete path to the folder where the log file and database backup dmp file are to be created (Example: file=C:\PrimaveraP6\backups\xedump.dmp log=C:\PrimaveraP6\backups\xedump.log)

Notes:

  • Be sure to remove any < > used in the above examples
  • Backup command example:  exp system/mypassword@XE full=y file=C:\PrimaveraP6\backups\xedump.dmp log=C:\PrimaveraP6\backups\exp_xedump.log
  • If any of the paths contain spaces they should be enclosed in single quotes. EX: log=’C:\My directory that has a space\exp_xedump.log’

How to restore:

From the command prompt (go to ‘Start’ > ‘Run’ > type ‘cmd’ and click ‘OK’) using the format below

imp userid=system/<password>@xe file=<path>\xedump.dmp commit=y buffer=8000000 fromuser=(admprm$pm,privprm$pm,pubprm$pm,bgjob$pm) touser=(admprm$pm,privprm$pm,pubprm$pm,bgjob$pm) log=<path>\imp_xedump.log

 

Where:

  • <password> is the password you used when you installed P6 Standalone or Oracle XE manually
  • <path> is the complete path to the folder where the existing database backup dmp file is located and where the log file will be created. (For example: file=C:\PrimaveraP6\backups\xedump.dmp log=C:\PrimaveraP6\backups\xedump_import.log)
    • If any of the paths contain spaces they should be enclosed in single quotes. EX: log=’C:\My directory that has a space\imp_xedump.log’

Note:

When importing using the import ‘touser’ option, the database users specified must already exist in the target database into which you’re importing the data.

To check whether these users exist or not:

  1. Open a new command prompt window (go to ‘Start’ > ‘Run’ > type ‘cmd’ and click ‘OK’)
  2. In the command prompt window, type: “sqlplus system/<password>@xe”
    where <password> is the password you used when you installed P6 Standalone or Oracle XE manually
  3. At the SQL> prompt, type: “select username from dba_users;”
  4. Check for the P6 schema users in the list of current database users

To create these users if the do not already exist, use the following steps:

  1. Download one of the following scripts:
  2. Review the before_import.sql script and make necessary modifications for your environment (such as tablespace locations)
  3. Open a new command prompt window (go to ‘Start’ > ‘Run’ > type ‘cmd’ and click ‘OK’)
  4. In the command prompt window, type: “sqlplus sys/<password>@xe as sysdba”
    where <password> is the password you used when you installed P6 Standalone or Oracle XE manually
  5. At the SQL> prompt, type: “@<path>\<filename>”
    where <path> is the complete path to the script and <filename> is the name of file.  Example, @C:\temp\before_import_8x.sql
Advertisements

Author: doduykhuong

Chief Planning Engineer. Scheduler. Oracle Primavera P6 Certified Specialist. Provide Primavera P6, Microsoft Project Tips & Tricks

6 thoughts on “How to backup and restore Primavera P6 Oracle Express (XE) database”

  1. Un f’in believable. This is a software for which you have to pay £60+ per month per user and all you get is a f’in dumb software from 80s! I’m really speechless. Thanks to Microsoft who still couldn’t bring their MSP to similar level in terms of proper scheduling / planning.

    Oracle – you are a total disgrace to the IT world. I’m hoping to see the day new generation software developers will sweep you and your ancient software from existence.

  2. I facing problem right now. Where the laptop issue by company the motherboard shock-circuit, lucky the hard disk still in good shape and can access using external hard disk casing.

    Can you send to me the procedure how to copy all data including Primavera P6 schedule from the existing hard disk (the damage laptop) to new laptop which I already install Primavera P6 Ver. 8.3.2 & Oracle XE 10g.

  3. Hi,

    I received error that exp is not recognized as an internal or external command, operable program or batch file

    Please help me on above mentioned error

  4. Nothing happens when I try this command. The folder I created for backup is also empty. It would be great if you could post screenshots or a small video tutorial.

  5. It is really awesome, I tried everything but only this method worked. Thank you very much Mr.Doduykhuong for such help.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s