0 Replies Last post: Dec 20, 2011 6:07 PM by Community Admin  
Novice 44 posts since
Mar 30, 2009
Currently Being Moderated

Dec 20, 2011 6:07 PM

Oracle Agile PLM Exporting the Database

For maximum data security, you should use a cold backup. You can import the Agile schema DMP file whenever you need to restore a database or replicate it on another computer with the exception of file content index synchronization because of its dependence on the file system.

 

Exporting the Agile Schema from Oracle.

 

To export only the Agile schema on Windows:

1. Ensure all users are logged off before shutting down the application server.

2. Open a command prompt, and type in C:

cd \oracle\admin\<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

4. To export the database, run the following batch file:

  • For traditional export: agile9exp.bat
  • For Oracle Data Pump export: agile9expdp.bat

 

To export the Agile schema on UNIX:

1. Ensure all users are logged off before shutting down the application server.

2. Change to the Agile scripts directory $ cd $ORACLE_BASE/admin/$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

4. To export the database, run the following batch file:

  • For traditional export:

$ chmod u+x agile9exp.sh

$ ./agile9exp.sh

  • For Oracle Data Pump export:

$ chmod u+x agile9expdp.sh

$ ./agile9expdp.sh

 

The database export takes awhile.  When it is complete, open the log file and see if the export was successful.  You can copy the successful export of expdat.dmp to another secure share (or computer) as a backup.

 



More Like This

  • Retrieving data ...