Thursday, July 29, 2010 22:36

Backup repository by oracle tools

Tagged with:
Posted by ukoom on Saturday, March 21, 2009, 9:36
This news item was posted in Team category and has 0 Comments so far.

Backup the original repository by Oracle exp tool.

Change directory to <Backup_Folder> and backup < Target_Repository >

Use the following commands:

exp userid=< Target_Repository_Owner >@<Oracle_DB> file=<Target_Repositor >.dmp log=<Target_Repository>_exp.log

Backout the repository

If you have sufficient privilege,

1.         Use script: <Documentum_65SP1_Base>/dba/config/<Target_Repository>/dm_DeleteTableSpace.sql to drop tablespace;

2.         Use script:

<Documentum_65SP1_Base>/dba/config/<Target_Repository>/dm_CreateTableSpace.sql to re-create tablespace;

3.         Re-create the repository by Oracle imp tool.

Change directory to <Backup_Folder> and import the < Target_Repository >

Use the following command:

imp userid=< Target_Repository_Owner >@< Oracle_DB> file=<Target_Repositor>.dmp log=<Target_Repository>_exp.log fromuser=< Target_Repository_Owner >

Related Posts

Leave a Reply

You can leave a response, or trackback from your own site.