Show TOC

Procedure documentationRestoring Control Files Locate this document in the navigation structure

 

You restore the control files when using BRRECOVER to perform:

For a whole database reset, you also restore the offline redo log files, but only if you selected an online consistent backup.

Note Note

Whereas a whole database reset always restores the control files, a database PIT recovery only restores them if they:

  • Are missing

  • Do not match the selected backup

End of the note.

This procedure calls BRRESTORE to restore the control files and - if required for whole database reset - the offline redo log files.

Prerequisites

You can repeat this phase if a BRRESTORE call has failed.

See Example below for the contents of the log file.

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

    Files for restore (mode)

    -m|-mode 0[,archive_logs]

    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.

    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 or the keyword archive_logs. The files for restore varies:

    • For the control files restore, a dummy file ID, 0, is used.

    • For the restore of offline redo log files from an online consistent backup (only relevant for whole database reset, as described above), the keyword archive_logs is used.

    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 Logs with BR*Tools.

Example

The control file restore runs in a similar way to the example shown in Restoring Data Files.