User guide

5-7
Cisco Media Gateway Manager 5.0 User Guide
OL-5461-02
Chapter 5 Maintaining an Efficient Network
How Do I Manage the Database?
5.1.2 Importing and Exporting Data to and from the Oracle Database
Use the Oracle Export utility to write data from an Oracle database to an operating system file in binary
format. The file is stored outside the database and read to another Oracle database by using the Import
utility. For more information about using Oracle Import and Export utilities, refer to the Oracle9i
Utilities document. Alternatively, use the Oracle Enterprise Manager to import and export data.
The Export utility provides a simple way to transfer data objects between Oracle databases. The Export
utility extracts the object definitions and table data from an Oracle database and stores them in an Oracle
binary-format export dump file located on disk or on tape.
The export dump file is sent by using FTP—or, if on tape, physically transported—to a different site. By
using the Import utility, the export dump file is transferred between databases that reside on machines
not connected through a network.
Note Only the Oracle Import utility can read export dump files.
5.1.3 Backing Up and Restoring the Database
This section describes how to back up and restore Cisco MGM data and how to use basic Oracle backup
and recovery tools:
• 5.1.3.1 Overview of the Oracle Logical Backup
• 5.1.3.2 Oracle Export Utility
• 5.1.3.3 Performing a Logical Backup (Export)
• 5.1.3.4 Oracle Import Utility
• 5.1.3.5 Restoring with a Logical Backup (Import)
• 5.1.3.6 Backing Up the Database
• 5.1.3.7 Restoring the Database
• 5.1.3.8 Configuring Manual NE Backup Parameters
This section also explains the structure of /opt/CiscoMGMServer, a directory that is created
automatically when you install Cisco MGM 5.0.
Note The default directory /opt/CiscoMGMServer may have been changed during installation of the
Cisco MGM server.
Cisco MGM uses an Oracle database. It is recommended that you protect your data by backing it up
regularly. Backups can be stored on a local or network-mounted, disk-based file system; on a local tape
drive; or on a remote tape drive.
Commercially available tools for Oracle and system-level backup include:
• Legato Networker (or “Solstice Backup” when purchased from Sun Microsystems)
• VERITAS NetBackup
• BMC Software SQL Backtrack
• GNU Oraback.sh