8 Backing Up and Recovering a Database
This chapter supplements the generic Oracle Database documentation set with information about backup and recovery. It includes the following topics:
Refer to the following Oracle manuals for detailed information about database backup and recovery:
You can choose among many methods and Oracle tools for backup and recovery. You may use the Import and Export Utilities for logical backup and recovery. For physical backup and recovery you may use Recovery Manager (RMAN) or operating system utilities.
This chapter describes some BS2000 specific issues if you apply user-managed backup and recovery with SQL*Plus and BS2000 utilities.
8.1 Backing Up an Oracle Database
You can use one of the following methods to back up an Oracle Database:
8.1.1 Using BS2000 Utilities to Back Up an Oracle Database
You can back up an Oracle database using BS2000 operating system utilities (for example, ARCHIVE
or the /COPY-FILE
command).
Use the following steps to back up an Oracle database:
8.1.2 Performing Online Backup
You can perform an online backup of the database or individual tablespaces by using either:
-
The BS2000
ARCHIVE
utility together with Oracle DatabaseINSTALL.C.OPNBACK
utility. -
The BS2000
PERCON
utility.
The ARCHIVE
method is faster, and is described in this section.
Before you can perform an online (hot) backup of individual tablespaces, you must ensure that the ARCHIVE
utility can back up open files.
The following BS2000 command ensures that ARCHIVE
can back up open files:
/START-EXECUTABLE $ORACINST.INSTALL.C.OPNBACK
*filename
The INSTALL.C.OPNBACK
utility calls the BS2000 macro CATAL
, which sets the OPNBACK
file attribute to YES
. For the CATAL
macro to work, the database must be shut down or the tablespace in question must be offline. You enter this command once for each file. For example, before adding it to a tablespace, not on the occasion of each backup.
You must never back up database files online without first setting the tablespace to backup mode. If you do not follow this step, then the resulting backup files are inconsistent. To perform an online backup of individual tablespaces or data files, use the following procedure:
Note:
The preceding SQL*Plus commands operate on tablespaces, while the ARCHIVE
utility operates on data files.
8.2 Restoring an Oracle Database
An Oracle Database can be restored offline from backups, using the following steps:
8.3 About Using the Recovery Manager
In addition to the BS2000 utilities, you can also use Oracle Recovery Manager (RMAN) to back up and restore a database.
See Also:
"Recovery Manager on BS2000" for more information