Show TOC

Procedure documentationSelecting Database Backups Locate this document in the navigation structure

 

You select BRBACKUP database backups when using BRRECOVER to perform:

Prerequisites

  • BRRECOVER only displays backups that finished with a return code of 0 or 1. The exception to this is for restore of individual backup files, where all backups are displayed.

  • BRRECOVER displays complete, incremental, and partial backups.

  • BRRECOVER also displays flashback database and restore points.

  • BRRECOVER recommends the most recent successful backup as a default for the recovery. Unless you select another backup, it uses this for the recovery.

  • For a complete database recovery, a database PIT recovery, or a tablespace PIT recovery, you can select multiple partial backups. BRRECOVER processes these intelligently. That is, it automatically detects overlapping partial backups and uses only the latest available data files.

  • For whole database reset, BRRECOVER does not display partial backups for selection.

  • For restore of individual backup files, you can only select one backup. In this case, BRRECOVER also displays backups with errors. If you are applying an incremental backup, BRRECOVER only displays incremental backups.

See Example below for the contents of the log file.

Procedure

  1. If required, select a backup that is different from the default recommended by BRRECOVER.

    Note Note

    For whole database reset, you can only select the following types of database backup:

    • Complete offline

    • Complete online consistent

    • Incremental offline

    • Incremental online consistent

    For more information, see Database Backup Types.

    End of the note.

  2. Choose Continue to continue processing with the selected backup.

    For complete or PIT recovery, BRRECOVER roughly checks the availability of offline redo log – that is, archivelog – files in the BRARCHIVE summary log file, depending on the device type used for the backup:

    • Tape or BACKINT

    • Disk

    • Stage (remote disk)

    If the files are unavailable, BRRECOVER issues a warning. You can continue if you are sure that either of the following is true:

    • You can find the required offline redo log files

    • The offline redo log files will not be required

      Note Note

      BRRECOVER identifies files that were added during or (only for PIT) after the selected backup. For example, a tablespace might have been extended during an online backup. Such files are not contained in the backup but they might need to be recreated.

      This does not apply to complete database recovery and restore individual backup files.

      End of the note.

  3. Check the results in the BRRECOVER detail log, v<encoded timestamp>.<ext>.

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

Example

This example shows the contents of the BRRECOVER detail log file for this procedure.

Database backups for complete database recovery

Pos. Log Start Type Mode Device Rc

1 = bdjwhckx.ffd 2003-01-29 17.30.51 offline full disk 0

2 - bdjwhadu.fft 2003-01-29 17.05.14 offline full tape 1

3 - bdjwgyrq.fff 2003-01-29 16.48.42 offline full util_onl 0

4 - bdjwgwtj.fnt 2003-01-29 16.26.55 onl_cons full tape 0

5 - bdjwgvvh.fnf 2003-01-29 16.16.29 onl_cons full util_onl 0