Entering content frameFunction documentation RMAN Backup Strategies Locate the document in its SAP Library structure

Use

The decision on whether to use the Oracle Recovery Manager (RMAN) and with which backup library, depends largely on the strategy that you use to back up your data. The best strategy depends on:

Features

The following table summarizes the main features of backup with RMAN:
 

Normal backups

Full backup
(level 0)

Incremental backup
(level 1)

With

RMAN
  • To tape device with the SAP Backup Library
  • To local disk without backup library
  • To appropriate media with external backup library

    • Without

    RMAN
    • To local or remote tape devices, local or remote disks with BRBACKUP
    • Backup with external tool and BACKINT

    Note

    You can not use RMAN to make a normal backup to a remote disk, even with a backup library.
    • To local or remote tape devices, local or remote disks with BRBACKUP followed by cataloging
    • Backup with external tool and BACKINT followed by cataloging

    Not possible

    Note

    For more information on the backup types referred to above, see:

    You can also back up the offline redo log files with RMAN.

    Incremental Backup Strategies with RMAN

    You can perform incremental backups of the database with RMAN and BRBACKUP. RMAN offers the following types of incremental backup:

    The integration of RMAN into BRBACKUP is restricted to cumulative incremental backups at level 1. This means that, in the event of a recovery, only one incremental backup at the most has to be applied. In contrast to a full backup, an incremental backup only backs up the changes that have been made since the last full backup. This significantly reduces the amount of backup data. Therefore, we recommend this strategy particularly for large databases.

    An incremental backup always requires an earlier full backup, that is, a level-0 backup. When RMAN backs up the database, it backs up all Oracle database blocks that have already been used. A subsequent incremental level-1 database backup backs up all Oracle database blocks that have changed since the last full backup. Changes to the whole database are taken into account.

    Incremental backups at level 1 can only be made with RMAN. However, a full backup can also be made with BRBACKUP or with an external backup tool using BACKINT. In this case, BRBACKUP automatically catalogs the backup as a level-0 backup.

    This graphic is explained in the accompanying text

    You might not see a reduction in backup time by making an incremental backup. The reason is that it might take as much time to check whether a block has been used or changed as to simply back it up. This means that you only see a significant time reduction when the relatively low throughput of the tape devices is the reason for a long backup.

    Recommendation

    Using the incremental backup strategy, we recommend you to set a lock period for the tapes of at least 28 days, so that several generations of full backups are available. The offline redo log files must cover the period up to the oldest full backup – that is, both sets of tapes must have the same lock period – and must also be backed up daily.

    After structural changes to the database, you can make incremental backups with RMAN and BRBACKUP. This is not possible with RMAN on its own. For more information, see RMAN Incremental Backups After Structural Changes.

    Activities

    This is a possible incremental backup scenario:

    The tools used to implement this backup strategy depend on your specific requirements for backup media, volume of data, and so on.

    For more information on incremental backups, see the Oracle documentation.

    Leaving content frame