Procedure documentationRestoring Data Files

 

You use this procedure when using BRRECOVER to perform:

This procedure calls BRRESTORE to restore files as follows:

Type of Recovery

What is Restored

Complete database recovery

Data files that BRRECOVER identified as missing in Checking the Status of Database Files

Database PIT recovery and whole database reset

All data files

Tablespace PIT recovery

Data files of the selected tablespaces plus the data files for the system and undo tablespaces

Restore individual backup files

  • For Restore files from BRBACKUP backup:

    Selected data files

  • For Apply incremental backup:

    Incremental backup save set

Prerequisites

  • BRRECOVER repeats this phase as required to restore all required files.

  • BRRECOVER avoids duplicate restores by logging which files it has already restored.

Procedure

  1. Set the required options:

    Menu Entry

    Equivalent BRRESTORE Command Option

    BRRESTORE profile (profile)

    -p|-profile

    BRBACKUP run (backup)

    -b|-backup|b1|backup1

    Fill-up previous restores (fillup)

    -f|-fillup

    Restore device type (device)

    -d|-device

    BACKINT/Mount profile (parfile)

    -r|-parfile

    Database user/password (user)

    -u|-user

    Restore destination (rest_dest)

    Only for restore individual backup files, option Restore files from BRBACKUP backup:

    -m|-mode = <rest_dest>

    Files for restore (mode)

    Confirmation mode (confirm)

    -c|-confirm

    Query mode (query)

    -q|-query

    Compression mode (compress)

    -k|-compress

    Parallel execution (execute)

    -e|-execute

    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.

    Note Note

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

    Files for restore (mode) refers to the Oracle file ID, a tablespace, or a keyword such as incr or all. The files for restore can vary, as described in the table above at the start of this procedure.

    End of the note.

  2. To start the 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>.rsb displays the progress.

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