Restoring and Applying an Incremental Backup 

Use

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.

Prerequisites

·        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.

Procedure

...

       1.      Set the required options:

Menu Entry	Equivalent BRRESTORE Command Option
BRRESTORE profile (profile)	-p|-profile
BRBACKUP run (backup)	-b|-backup|b1|backup1
Restore device type (device)	-d|-device
BACKINT/Mount profile (parfile)	-r|-parfile
Database user/password (user)	-u|-user
Files for restore (mode)	-m|-mode incr
Confirmation mode (confirm)	-c|-confirm
Query mode (query)	-q|-query
Compression mode (compress)	-k|-compress
Additional output (output)	-o|-output
Message language (language)	-l|-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.