Performing Flashback Database

You use this procedure when using BRRECOVER to perform flashback database during:

BRRECOVER first remounts – that is, closes and again mounts – the database to refresh the views V$DATAFILE, V$RECOVER_FILE, and V$RECOVERY_STATUS.
BRRECOVER checks whether there are any data files not online. If so, it recommends to set them online.
BRRECOVER displays a list of the redo log files to be automatically applied by Oracle during the flashback database, as in the following example:

Example
Archivelog files to apply for complete recovery

Pos. Seq. Status Apply From Disk Tape Util Rman Stage

1 - 11 in_arch yes arch

2 - 12 in_arch yes arch

3 - 13 in_arch yes arch

4 - 14 in_arch yes arch

5 - 15 redo_arch yes redo

6 - 16 redo_arch yes redo

7 - 17 in_redo yes redo

End of the example.

Note

Some files might be present on multiple media sources. For example, a file might be present on disk and on tape. BRRECOVER normally uses the most accessible version of the file, unless you specify otherwise. In this example, it would use the disk version of the file.

End of the note.

Menu Entry	Meaning
First sequence number (first_seq)	First offline redo log to apply
Last sequence number (last_seq)	Last offline redo log to apply

If a restore is necessary, set the required options:

Menu Entry	Equivalent BRRESTORE Command Options
BRRESTORE profile (profile)	-p\|-profile
Profile for cpio (prof_cpio)	-p\|-profile
Profile for dd (prof_dd)	-p\|-profile
Profile for rman (prof_rman)	-p\|-profile
Profile for rman_dd (prof_rman_dd)	-p\|-profile
Profile for rman_set (prof_rman_set)	-p\|-profile
BACKINT/Mount profile (parfile)	-r\|-parfile
Database user/password (user)	-u\|-user
Destination directory (dest_dir)	-a\|-archive = <rest_dir>
Confirmation mode (confirm)	-c\|-confirm
Additional output (output)	-o\|-output
Message language (language)	-l\|-language

If required, alter the Database flashback target for the flashback:

Menu Entry	Equivalent BRRECOVER Command Options
Database flashback target (target)	-o\|-rpt\|-point
Database flashback command (command)	The SQL command that is to be executed using the current settings. For more information, see your Oracle SQL documentation.

For whole database reset, you can change the restore point.

For database point-in-time recovery, you can change the timestamp.

Choose Continue.
BRRECOVER performs flashback database.
Check the results in the BRRESTORE and BRRECOVER logs. The detail log r<encoded timestamp>.rsa displays the progress for restoring the offline redo log files.
For more information on how to view the logs, see Showing Logs with BR*Tools.