User`s guide

Recovering Databases
6-2 Oracle Database Installation and Administration Guide
2. To ensure that all Oracle database files are synchronized at the time of the backup,
shut down Oracle database using SQL*Plus.
3. Back up all database files and log files using the BS2000 ARCHIVE utility or the
BS2000
/COPY-FILE command. You should always back up all files at the same
time.
4. Restart Oracle Database using SQL*Plus.
6.1.2 Online Backup
You can perform an online backup of the database or individual tablespaces by using
either:
■ the BS2000 ARCHIVE utility together with Oracle Database INSTALL.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 indi
vidual tablespaces, you must
ensure that the
ARCHIVE utility can back up open files.
The following BS2000 command ensures that
ARCHIVE can back up all open files:
/START-PROGRAM $ORAC1120.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 withou
t 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:
1. Enter the following command:
SQL> ALTER TABLESPACE name BEGIN BACKUP;
2. Back up the files of the tablespace using the BS2000 utility ARCHIVE utility.
Ensure that the OLS parameter of ARCHIVE is set to
YES .
3. Enter the following command:
SQL> ALTER TABLESPACE name END BACKUP;
Note: The preceding SQL*Plus commands operate on tablespaces,
while the
ARCHIVE utility operates on data files.
6.2 Recovering Databases
An Oracle Database can be restored offline from backups, using the following steps:
1. Copy all the database files and the log files from the backup. You may use the
BS2000
ARCHIVE utility or the BS2000 /COPY-FILE command. Files must be restored
with their original name.