User`s guide
6
Backing Up and Recovering a Database 6-1
6
Backing Up and Recovering a Database
This chapter supplements the generic Oracle Database documentation set with
information about backup and recovery.
Refer to the following Oracle manuals for detailed information about database backup
and recovery:
■ Oracle Database Concepts
■ Oracle Database Administrator's Guide
■ Oracle Database Backup and Recovery User's Guide
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.
Refer to Section 6.1.2, "Online Backup" for information about RMAN on BS2000.
6.1 Backing Up an Oracle Database
You can use one of the following methods to back up an Oracle Database.
■ Using BS2000 Utilities to Back Up an Oracle Database
■ Online Backup
6.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:
1. While the database is running, collect the names of all files, which make up Oracle
database. You can determine the names of the log and database files by entering
the following commands:
/START-PROGRAM $ORAC1120.SQLPLUS
* /NOLOG
SQL> CONNECT / AS SYSDBA
SQL> SELECT * FROM V$DATAFILE;
SQL> SELECT * FROM V$LOGFILE;