Chapter 8. Maintenance
56
Option
Description
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
Note
Database statistics are collections of data that describe more details about the
database and the objects in the database. These statistics are used by the query
optimizer to choose the best execution plan for each SQL statement. Because the
objects in a database can be constantly changing, statistics must be regularly updated
so that they accurately describe these database objects. Statistics are maintained
automatically by Oracle. However, if your database has performance issues after a
significant amount of data changes, consider performing manual gathering of statistics.
Note
After deleting large amount of data, use the
segment-shrink
feature to reclaim
fragmented free space in an Oracle Database segment. The benefits of
segment-
shrink
are compaction of data that leads to better cache utilization and the
compacted data requires fewer blocks to be scanned in full table scans, which both
lead to better performance.
The segment shrink feature works only on newly created Oracle Database 10g Release
2 that comes with RHN Satellite Server 5.2.0. Due to different default database settings
in Oracle Database 9i this feature does not work on databases that were upgraded
from previous RHN Satellite Server releases.
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 command as root:
service rhn-satellite stop
Then switch to the oracle user and issue this command to initiate the backup:
db-control backup
DIRNAME
Backup files are stored in the directory specified. Note that this is a cold backup; the database must be
stopped before running this command. This process takes several minutes. The first backup is a good
indicator of how long subsequent backups will take.
Once the backup is complete, return to root user mode and restart the database and related services
with the following command:
Содержание NETWORK SATELLITE 5.2 - CHANNEL MANAGEMENT
Страница 1: ...Red Hat Network Satellite 5 2 Installation Guide Red Hat Network Satellite ...
Страница 18: ...14 ...
Страница 21: ...Satellite Proxy Vertically Tiered Topology 17 Figure 3 3 Satellite Proxy Vertically Tiered Topology ...
Страница 22: ...18 ...
Страница 36: ...32 ...
Страница 50: ...46 ...
Страница 56: ...52 ...
Страница 71: ...67 Appendix B Revision History Revision History Revision 1 0 ...
Страница 72: ...68 ...