Setting Point In Time and Tablespaces for Recovery

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

Context

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

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

Procedure

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

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

Choose Continue to continue processing with the selected PIT.
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.