Selecting Database Backups
Use
You select BRBACKUP database backups when using BRRECOVER to perform:
· Database point-in-time (PIT) recovery
· Tablespace point-in-time (PIT) recovery
· Restore of individual backup files
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 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.
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.
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
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.
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