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

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:
   • If using P6 PPM r8.4 or earlier releases:  before_import_8x.sql
   • If using P6 PPM r15.1 or later releases:  before_imp_15x.sql
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