Blogs

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

Tuesday, 21 June 2016
Hits: 6239

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

Trending #Tags

Search Blogs

Archived Posts