Show TOC

Checking the Status of TablespacesLocate this document in the navigation structure

Prerequisites

  • BRRECOVER checks that all files are online. This is normally true if the database is open.

  • BRRECOVER identifies which data files need to be recovered, based on the tablespaces that you selected earlier.

  • BRRECOVER checks if the tablespaces that you selected and the other data tablespaces are separate self-contained groups. This means that it checks whether there are references such as indexes or constraints that point from members of a group to members outside this group. If so, you cannot continue with the recovery.

BRRECOVER writes the results of the status check to the BRRECOVER detail log file.

Context

You check the status of tablespaces when using BRRECOVER to perform Tablespace Point-In-Time Recovery. After you have selected the tablespaces to recover, this procedure identifies the corresponding database files.

Procedure


  1. Check the display and continue with the tablespace recovery.

  2. Check the results in the BRRECOVER detail log, v<encoded timestamp>.tpt.

    For more information on how to view the logs, see Showing Profiles and Logs with BR*Tools.