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 as a level-0 backup, 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 as level 0. 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 an incremental level-0 backup.

See also:

backup_mode

-m|-mode

RMAN Backup Strategies