Red Hat Training

A Red Hat training course is available for Red Hat Satelitte

8.4. Using RHN DB Control

RHN Satellite Server with Embedded Database requires a utility for managing that database. Red Hat provides just such a tool: RHN DB Control. This command line utility allows you to do everything from make, verify, and restore backups to obtain database status and restart it when necessary. You must be the oracle user to invoke RHN DB Control. To begin, switch to the oracle user:
su - oracle
Next, issue the following command:
db-control option

8.4.1. DB Control Options

RHN DB Control offers many command line options. To use them, as oracle insert the option and the appropriate value, if needed, after the db-control command.

Table 8.1. RHN DB Control Options

Option Description
help Lists these db-control options with additional details.
backup DIRNAME Backs up the database to the directory specified.
examine DIRNAME Examines the contents of a backup directory. Returns the timestamp of backup creation and reports on its contents.
extend Increase the RHN Oracle tablespace
report Reports on current usage of database space.
restore DIRNAME Restores the database from backup kept in DIRNAME. Database must be stopped for this command to run successfully.
start Starts the database instance. This can also be accomplished by issuing the service rhn-database start command as root.
status Shows the current status of the database, either "running" or "offline".
stop Stops the database instance. This can also be accomplished by issuing the service rhn-database stop command as root.
tablesizes Show space report for each table
verify DIRNAME Verifies the contents of the backup kept in DIRNAME. This command checks the md5sums of each of the files kept in the backup.