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.