Skip Headers

Oracle9i Recovery Manager Reference
Release 2 (9.2)

Part Number A96565-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

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

Recovery Catalog Views, 16 of 28


RC_DATAFILE

This view lists information about all datafiles registered in the recovery catalog. It corresponds to the V$DATAFILE view. A datafile is shown as dropped if its tablespace was dropped.

Column Datatype Description

DB_KEY

NUMBER

The primary key for the target database.

DBINC_KEY

NUMBER

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

DB_NAME

VARCHAR2(8)

The DB_NAME of the database incarnation to which this record belongs.

TS#

NUMBER

The number of the tablespace to which the datafile belongs. The TS# may exist multiple times in the same incarnation if the tablespace is dropped and re-created.

TABLESPACE_NAME

VARCHAR2(30)

The tablespace name. The name may exist multiple times in the same incarnation if the tablespace is dropped and re-created.

FILE#

NUMBER

The absolute file number of the datafile. The same datafile number may exist multiple times in the same incarnation if the datafile is dropped and re-created.

CREATION_CHANGE#

NUMBER

The SCN at datafile creation.

CREATION_TIME

DATE

The time of datafile creation.

DROP_CHANGE#

NUMBER

The SCN recorded when the datafile was dropped. If a new datafile with the same file number is discovered then the DROP_CHANGE# is set to CREATION_CHANGE# for the datafile; otherwise the value is set to RC_CHECKPOINT.CKP_SCN.

DROP_TIME

DATE

The time when the datafile was dropped. If a new datafile with the same file number is discovered then the DROP_TIME is set to CREATION_TIME for the datafile; otherwise the value is set to RC_CHECKPOINT.CKP_TIME.

BYTES

NUMBER

The size of the datafile in bytes.

BLOCKS

NUMBER

The size of the datafile in blocks.

BLOCK_SIZE

NUMBER

The size of the data blocks in btyes.

NAME

VARCHAR2(1024)

The datafile filename.

STOP_CHANGE#

NUMBER

For offline or read-only datafiles, the SCN value such that no changes in the redo stream at an equal or greater SCN apply to this file.

STOP_TIME

DATE

For offline normal or read-only datafiles, the time beyond which there are no changes in the redo stream that apply to this datafile.

READ_ONLY

NUMBER

1 if the file is read-only; otherwise 0.

RFILE#

NUMBER

The relative file number of this datafile within its tablespace.

INCLUDED_IN_DATABASE_BACKUP

VARCHAR2(3)

Indicates whether this tablespace is included in whole database backups: YES or NO. The NO value occurs only if CONFIGURE EXCLUDE was run on the tablespace that owns this datafile.

AUX_NAME

VARCHAR2(1024)

Indicates the auxiliary name for the datafile as set by CONFIGURE AUXNAME.


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

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback