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, 23 of 28


RC_REDO_THREAD

This view lists data about all redo threads for all incarnations of the database since the last catalog resynchronization. This view corresponds to V$THREAD.

Column Datatype Description

DB_KEY

NUMBER

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

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.

THREAD#

NUMBER

The redo thread number for the database incarnation.

STATUS

VARCHAR2(1)

The status of the redo thread: D (disabled), E (enabled), or O (open).

SEQUENCE#

NUMBER

The last allocated log sequence number.

ENABLE_CHANGE#

NUMBER

The SCN at which this thread was enabled.

ENABLE_TIME

DATE

The time at which this thread was enabled.

DISABLE_CHANGE#

NUMBER

The most recent SCN at which this thread was disabled. If the thread is still disabled, then no redo at or beyond this SCN exists for this thread. If the thread is now enabled, then no redo exists between the DISABLE_CHANGE# and the ENABLE_CHANGE# for this thread.

DISABLE_TIME

DATE

The most recent time at which this thread was disabled.


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