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
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.
| Option | Description |
|---|---|
help
|
Lists these db-control options with additional details.
|
backup
| Backs up the database to the directory specified. |
examine
| 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
| 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
| Verifies the contents of the backup kept in DIRNAME. This command checks the md5sums of each of the files kept in the backup. |