Backing up the Harvest database
Article ID: 428079
Updated On:
Products
Issue/Introduction
What is the proper method for making a complete backup of the Harvest database?
Environment
Harvest Software Change Manager
Resolution
Before backing up, please be sure all users have logged out and the Harvest broker and HServers are shut down.
Linux Example (logged in as the user that owns the SCM software folder and processes):
bkrd -shutdown
pgrep rtserver | xargs kill
ps -ef | grep 'hserver\|bkrd\|rtserver'
Windows Example (from command prompt window):
bkrd -shutdown=all
(or you can go to Control Panel -> Administrative Tools -> Services and stop the CA SCM Broker Service)
rtserver -stop_all
(or you can go to Task Manager and kill the rtserver.exe process from there)
For an Oracle server, cd to Oracle’s dpdump folder and dump the Harvest database schema to a dump file
Example:
expdp <user-name>/<password> SCHEMAS=harvest DUMPFILE=harvest.dmp LOGFILE=harvest-exp.log
(On Linux you should be logged in as the “oracle” user; user-name should be Oracle system level user for example "system")
With newer versions of Oracle there is also an option (in the case where the database is not being moved, but just backed up) to take a "flashpoint" of the database, allowing to rollback to that point if needed.
For a SQL Server database, log in to SQL Server Management Studio. Expand the Databases node, right-click on the harvest database, and select Tasks -> Back Up…
On the Backup Database window ensure the correct database is selected, the Backup type is “Full,” the Backup component is “Database”, the Backup option is “Disk,” and a valid folder location and the name is selected for your database backup file. Click OK.
You will get a message that the backup has been completed successfully.
Additional Information
Feedback
