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

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