Procedure documentationSetting Point In Time and Tablespaces for Recovery

 

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.

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)

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