Setting Point In Time and Tablespaces for Recovery 

Use

You use this procedure to specify the:

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

¡        Database PIT recovery

¡        Tablespace PIT recovery

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

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

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)

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

·        You can specify tablespaces by one of the following:

¡        SAP owner of the tablespaces

¡        Individual tablespace names

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.

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
SAP owners 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 ~ SAP owners for recovery (sap_owner) ............... []

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

 

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

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