You can use the Oracle Import utility to restore CA Harvest SCM to the time of the export. If you want to restore the CA Harvest SCM data to the same database using the same Oracle user name, first drop and then recreate the Oracle user. SQL scripts for this purpose are provided in SCM\Database.
Important! Before you drop the user, verify that you have a good export dump file. Shut down CA Harvest SCM before you proceed.
DropUser.sql drops the user. Use it as follows:
sqlplus DBA name/DBA password @DropUser.sql name_of_user_to_be_dropped output_log_file_name
creatusr.sql creates the Oracle user for CA Harvest SCM, grants it the necessary rights, and assigns it quota in tablespaces. Execute creatusr.sql as follows:
sqlplus DBA name/DBA password @creatusr.sql name_of_user_to_be_created password_for_the_user HARVESTMETA HARVESTBLOB HARVESTINDEX temporary_data_tablespace_name rollback_data_tablespace_name output_log_file_name
To restore data to the user, import using the following parameters:
USERID = name/password of the user FILE = exported dump file name LOG = name of file for storing import messages FULL = Y
|
Copyright © 2013 CA.
All rights reserved.
|
|