5-8
Cisco Media Gateway Manager 5.0 User Guide
OL-5461-02
Chapter 5 Maintaining an Efficient Network
How Do I Manage the Database?
Caution Whenever a back up is done, it must include both the database and all other Cisco MGM directories.
Likewise, whenever a restore is done, it must include both the database and all other Cisco MGM
directories.
5.1.3.1 Overview of the Oracle Logical Backup
It is recommended to backup the Oracle database using a logical backup. A logical backup involves
reading a set of database records and writing them to a file. These records are read independently of their
physical location. Oracle uses the Export (exp) and Import (imp) utilities to perform a logical database
backup.
A logical backup has the following advantages:
• Checks for corrupted data blocks and verifies database consistency
• Eliminates database fragmentation
• Allows incremental export and import to store only tables that have changed since the last export
• Is portable to another machine or database
A logical backup has the following disadvantages:
• Cannot recover transactions
• Takes longer than a physical backup
• Lacks referential integrity (export is done one table at a time)
5.1.3.2 Oracle Export Utility
The Oracle Export utility reads the database, including the data dictionary, and writes the output to a
binary file called an export dump file. The created file contains all of the commands necessary to recreate
the selected database objects.
The Oracle Export utility permits three types of exports:
• Complete—A full database export including the data dictionary for all tables
• Incremental—Includes all of the tables that have changed since the last full export
• Cumulative—Includes all of the tables that have changed since the last full cumulative or the last
full export
Note Exporting directly to a Network File System (NFS)-mounted file system is not recommended due to the
unusually large amount of data transfer required. The export dump file may be moved to an
NFS-mounted system after exporting to a local file system.
Tip Save the export dump file on a file system independent from the one used by the Cisco MGM database.
Comments to this Manuals