Oracle8i Recovery Manager User's Guide and Reference
Release 2 (8.1.6)

Part Number A76990-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Recovery Catalog Views, 12 of 25


RC_DATABASE

This view gives information about the databases registered in the recovery catalog. It corresponds to the V$DATABASE view.

Column   Datatype  NULL  Description 

DB_KEY 

NUMBER 

NOT NULL  

The primary key for the database. Use this column to form a join with almost any other catalog view. 

DBINC_KEY 

NUMBER 

 

The primary key for the current incarnation. Use this column to form a join with RC_DATABASE_INCARNATION. 

DBID 

NUMBER 

NOT NULL  

Unique identifier for the database obtained from V$DATABASE. 

NAME 

VARCHAR2(8) 

NOT NULL  

The DB_NAME of the database for the current incarnation. 

RESETLOGS_CHANGE# 

NUMBER 

NOT NULL  

The SCN of the most recent RESETLOGS operation when the record was created. 

RESETLOGS_TIME 

DATE 

NOT NULL  

The timestamp of the most recent RESETLOGS operation when the record was created. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index