We are asked quite a bit how to export and move the Agile PLM database. Knowing how to back up the database is a great way to provide fallback measures should any configuration changes have adverse affects or as a means of inexpensive backup (provided it is copied off of the machine. If this is your means of backup, do not forget about your vault. The database holds meta data, not file content!
Here are the instructions from the Agile PLM Database Installation Guide:
1. Ensure that all users are logged off before shutting down the application server.
Note The following commands use the D drive. If you have installed agile9300db or Oracle on another drive, specify that drive letter.
2. Open a Command Prompt window, and type the following:
d:
cd oracleadmin<Oracle SID>create<agile schema user>
3. Check export parameters in the .par file.
- For traditional export: agile9exp.par
- For Oracle Data Pump export: agile9expdp.par
These parameters are described in Export Parameters on page 49.
4. To export the database, run the following batch file:
- For traditional export: agile9exp.bat
- For Oracle Data Pump export: agile9expdp.bat
View the Oracle Agile PLM Database Installation Guide for Agile PLM 9.3.0.2