Restoring Control Files  

Use

You restore the control files when using BRRECOVER to perform:

·        Database point-in-time (PIT) recovery

·        Whole database reset

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

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

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.

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.

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