Users Guide

Oracle Backup/Restore | Oracle Database Management
OMNM 6.5.3 Installation Guide 173
You may encounter an ORACLE 2291 error when using command line imp.
For example:
. importing table "RCC_TASK_USAGE_ENTITY"
IMP-00019: row rejected due to ORACLE error 2291
IMP-00003: ORACLE error 2291 encountered
ORA-02291: integrity constraint (REDCELL.FKE609020E14863754) violated -
parent key not found
The workaround for this is to find the foreign key reference table and import the parent table first
then re-import the problematic table. For example:
imp system/ companyName fromuser=netmgr touser=netmgr ignore=y
constraints=n
file=netmgr_17012013.dmp tables=rcc_task_usage_entity
NOTE:
There is no substitute for having a DBA. Such an administrator could tell you how Oracle has improved on
its previous import/export utility with RMAN and Data Pump. Oracle’s manuals explain the use of these
utilities.
On-line/Off-line Backup (OS)
You can back up your database using Operating System (OS) commands along with Oracle system
views. Although OS backups allow database recovery, the recovery process may be more complex
than using RMAN. We recommend OS backups as an interim backup strategy until RMAN is in
place.
A cold backup is a backup performed when the database is completely shut down. A hot backup is
one performed when the database is open and possibly in use. An Instance is a synonym for an
Oracle database.
Off-line backups, or cold backups, require database shutdown before making a backup. Restored
cold backups resolve any kind of database failure, as long as the backed up files are intact.
On-line backups, or hot backups, do not require database shutdown. Active transactions can be
running while the backup occurs. On-line backups can recover from many failures, but some types
of failures may require restoring to an off-line backup and then recovering from there. See the
Oracle manuals for instructions about how to do hot and cold backups.
Oracle Export/Import (Oracle utilities)
Oracle's export and import utilities back up the data contained within an Oracle database. The
RMAN/OS Oracle backups back up the entire database at the datafile/tablespace level whereas
export/import backup/restore at the user/table level. An export is a good supplement to any of the
above backups.
Oracle's export/import can backup/restore a Database (all users), a particular user, or a set of tables.
See Oracle’s manuals for details about Oracle’s Export and Import.