Full Restore and Point-In-Time Recovery (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Full Restore and Point-In-Time Recovery

Use

You can use this function to fully restore and then recover your Oracle database to a specified point in time (PIT). You normally use this function when there has been a logical error – that is, a user or software error – and you want to recover the database to the point immediately before the error. In this way, you minimize lost data.

Prerequisites

We recommend you to:

Perform a full offline or online backup. If the database is running, use SAP tools, otherwise use operating system tools.

Back up all offline redo log files using BRARCHIVE. For more information, see -a|-archive.

It must be possible to set the database to status mount or open.
You must have the following data available:

The BRBACKUP logs and the BRARCHIVE logs

The data file backups

All offline redo log files between the data backup and the chosen PIT

Features

This graphic is explained in the accompanying text

Activities

You select a full online or offline backup. SAPDBA uses the BRBACKUP summary log file back<DBSID>.log and the corresponding detail logs to find the correct backups.

You enter the recovery end-point.

You select the required offline redo log files. SAPDBA uses the entries in the BRARCHIVE summary log file, arch<SID>.log to find the correct files.

SAPDBA indicates whether your intended recovery is permitted. It rejects the recovery if:

No full backup has been specified or it could not find the required offline redo log files.

The period of your intended recovery contains a tablespace reorganization with data files.

The selected backup is dated before the last time the database was opened using the resetlogs option.

SAPDBA saves the current online redo log files and a control file to a subdirectory of sapreorg.

SAPDBA calls BRRESTORE to restore all data files from the backup medium. If a tablespace was extended at the time of the recovery, it also restores the control files.

SAPDBA calls BRRESTORE to restore the offline redo log files.

Using the recovery script, SAPDBA recovers the database to the required PIT.

SAPDBA opens the database using the resetlogs option and prompts you to perform a backup.

You perform a database backup.

Example

Here are two typical scenarios in which you can use full restore and PIT recovery:

Logical Error

This graphic is explained in the accompanying text

Logical Error with Preceding Structure Change

This graphic is explained in the accompanying text