Show TOC

Procedure documentationSetting Point In Time and Tablespaces for Recovery Locate this document in the navigation structure

 

You use this procedure to specify the:

  • Point in time (PIT) when using BRRECOVER to perform one of the following:

  • Tablespaces to be recovered when using BRRECOVER to perform a tablespace PIT recovery

    Note Note

    You can use this to select tablespaces from a single component if you are running Multiple Components in One Database (MCOD).

    End of the note.

Prerequisites

  • You can specify the PIT as one of the following:

    • A normal point in time, using the time stamp (that is, date, hours, minutes, and seconds)

    • An Oracle system change number (SCN)

    • An Oracle log sequence number (SEQ)

      Note Note

      BRRECOVER translates a normal point in time or an SCN into the corresponding sequence number (SEQ) of the last Oracle log to be applied.

      End of the note.

  • You can specify tablespaces by one of the following:

    • SAP owner of the tablespaces

    • Individual tablespace names

      Note Note

      To select tablespaces from a single component if you are running Multiple Components in One Database (MCOD), enter the SAP owner of the tablespaces in the component that you want to recover. Each component has a different SAP owner.

      End of the note.

See Example below for the contents of the log file.

Procedure

  1. To set the point in time for the recovery, enter one of the following:

    Menu Entry

    Equivalent BRRECOVER Command Option

    Database instance of archivelog thread (instance)

    -j|-ins|-instance

    Last archivelog sequence to apply (last_seq)

    -n|-seq|-sequence

    Last system change number to apply (last_scn)

    -g|-scn|-change

    End point-in-time for recovery (end_pit)

    -n|-pit|-time

  2. If you are performing a tablespace PIT recovery, enter one of the following:

    Menu Entry

    Equivalent BRRECOVER Command Option

    Database owner for recovery (owner)

    -w|-own|-owner

    Tablespaces for recovery (tablespace)

    -a|-tsp|-tablespace

  3. Choose Continue to continue processing with the selected PIT.

  4. 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, using a tablespace PIT recovery.

BR0657I Input menu 107 - please check/enter input values

------------------------------------------------------------------

Options for tablespace point-in-time recovery of database GC2

1 # Database instance of archivelog thread (instance) . []

2 ~ Last archivelog sequence to apply (last_seq) ...... []

3 ~ Last system change number to apply (last_scn) ..... []

4 ~ End point-in-time for recovery (end_pit) .......... []

5 ~ Database owner for recovery (sap_owner) ........... []

6 ~ Tablespaces for recovery (tablespace) ............. []

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

------------------------------------------------------------------