Complete Backup (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Complete Backup

Definition

This section describes the different types of complete backup for the Oracle database.

SAP backup tools are integrated with the Oracle Recovery Manager (RMAN). You can use RMAN to make incremental backups. However, you cannot start an incremental backup without a preceding full backup.

Complete backup refers to one of the following:

Whole backup

Backs up all database files, but this backup is not cataloged, which means that you cannot use it as a reference backup for an incremental backup with RMAN. The syntax for a whole backup is as follows:

In profile init<DBSID>.sap: backup_mode = all

With BRBACKUP: brbackup -m all

Full backup

Backs up all database files. You can perform a full backup with or without RMAN. If you do not use RMAN, then RMAN is called separately to catalog the backup. This means that you can use this backup as a reference backup for an incremental backup with RMAN. The syntax for a full backup is:

In profile init<DBSID>.sap: backup_mode = full

With BRBACKUP: brbackup -m full

In the context of the Recovery Manager this backup is a level-0 backup.

See also:

backup_mode

-m|-mode

RMAN Backup Strategies