Restoring and Applying an Incremental Backup


You use this procedure when using BRRECOVER to perform:

·        Complete database recovery

·        Database point-in-time (PIT) recovery

·        Tablespace point-in-time (PIT) recovery

·        Whole database reset

·        Restore of Individual Backup Files with BR*Tools

This procedure calls BRRESTORE to restore and apply incremental backups only if you specified this when you selected a database backup.


·        BRRECOVER lets you repeat this phase if there is an error.

·        BRRECOVER checks whether there are any data files not online. If so, it recommends to set them online.



       1.      Set the required options:

Menu Entry

Equivalent BRRESTORE

Command Option

BRRESTORE profile (profile)


BRBACKUP run (backup)


Restore device type (device)


BACKINT/Mount profile (parfile)


Database user/password (user)


Files for restore (mode)

-m|-mode incr

Confirmation mode (confirm)


Query mode (query)


Compression mode (compress)


Additional output (output)


Message language (language)


BRRESTORE command line (command)

This shows you the BRRESTORE command that is to be executed using the current settings.

Restore device type (device) is taken from the device type used for the selected backup.

       2.      To start the apply and restore with the selected options, choose Continue.

       3.      Check the results in the BRRESTORE logs:

Ў        The summary log rest<DBSID>.log displays the return code.

Ў        The detail log r<encoded timestamp>.<ext> displays the progress.

For more information on how to view the logs, see Showing Logs with BR*Tools.