301 views
in RMAN by ACE (20,920 points)

1 Answer

by ACE (20,920 points)

The primary reasons for making incremental backups part of your strategy are:

  • Faster daily backups if block change tracking is enabled (see "Using Block Change Tracking to Improve Incremental Backup Performance")

  • Ability to roll forward data file image copies, thereby reducing recovery time and avoiding repeated full backups.

  • Less bandwidth consumption when backing up over a network.

  • Improved performance when the aggregate tape bandwidth for tape write I/Os is much less than the aggregate disk bandwidth for disk read I/Os.

  • Possibility of recovering changes to objects created with the NOLOGGING option.

    For example, direct load inserts do not create redo log entries, so their changes cannot be reproduced with media recovery. Direct load inserts do change data blocks, however, and these blocks are captured by incremental backups.

  • Synchronize a physical standby database with the primary database. You can use the RMAN BACKUP INCREMENTAL FROM SCN command to create a backup on the primary database that starts at the current SCN of the standby database, which you can then use to roll forward the standby database.

Categories

...