60
Chapter 8. Maintenance
Option
Description
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.
Table 8-1. RHN DB Control Options
8.4.2. Backing up the Database
Red Hat recommends performing nightly backups of the Embedded Database and moving
the resulting directory to another system via NFS, SCP, FTP, etc. Preferably, this backup
system resides off-site. To conduct a backup, shut down the database and related services
first by issuing the following commands in this order as root:
service httpd stop
service taskomatic stop
service rhn-database stop
Then switch to the oracle user and issue this command to initiate the backup: