HP A.06.11 User Manual

Page 78

Advertising
background image

1.

Shut down the database cleanly.

A clean shutdown means that the database is not shut down using the ABORT
option.

2.

Mount the database if you are backing it up using RMAN.

3.

Back up all datafiles, control files and, optionally, parameter files.

4.

Restart the database in the normal online mode.

Oracle online

As opposed to an offline backup, an online backup is performed when a database
is open.

The backup of an open database is inconsistent, because portions of the database
are being modified and written to disk while the backup is progressing. Such changes
to the database are entered into the online redo logs as well. A database running
in the ARCHIVELOG mode enables the archiving of the online redo logs. In the case
of a restore, this feature is essential to bring a database to a consistent state as part
of the entire restore process.

When using an online backup, the following must be done in order to bring the
database to a consistent state:

1.

Restore the database files (which are inconsistent) to disk.

2.

Perform database recovery, which requires applying the Archived Redo Logs.
This is an Oracle operation.

An Oracle online database backup can be performed using the Oracle RMAN utility
or Data Protector GUI. In the latter case, Data Protector creates and executes the
RMAN script automatically based on data entered in the Data Protector GUI. During
an Oracle online backup, the Oracle target database is open, while tablespaces,
datafiles, control files, and archived redo logs are being backed up.

The database must operate in the ARCHIVELOG mode so that the current Online
Redo Logs are archived to the Archived Redo Logs.

IMPORTANT:

Before you run an Oracle online backup, make sure that the database is really operating
in ARCHIVELOG mode. This can be done on the Oracle server system by starting SQL*Plus
and issuing the following command:

archive log list;

Integrating Oracle and Data Protector

78

Advertising