Show TOC

Procedure documentationPerforming Flashback Database

 

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

Prerequisites

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

    Note Note

    Some offline redo log 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.

Procedure

  1. If required, change the default options for Oracle to automatically apply the offline redo log files:

    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

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

    Profile for brtools (brtools)

    -p|-profile

    BACKINT/Mount profile (parfile)

    -r|-parfile

    Database user/password (user)

    -u|-user

    Destination directory (dest_dir)

    -a|-archive = <rest_dest>

    Confirmation mode (confirm)

    -c|-confirm

    Additional output (output)

    -o|-output

    Message language (language)

    -l|-language

  3. Choose Continue.

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

  5. Choose Continue.

    BRRECOVER performs flashback database.

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