Recovery Catalog Views, 21 of 25

RC_REDO_THREAD

This view lists data about all redo threads for all incarnations of the database.

Column	Datatype	NULL	Description
DB_KEY	NUMBER	NOT NULL	The primary key for the target database. Use this column to form a join with almost any other catalog view.
DBINC_KEY	NUMBER	NOT NULL	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)	NOT NULL	The DB_NAME of the database incarnation to which this record belongs.
THREAD#	NUMBER	NOT NULL	The redo thread number for the database incarnation.
STATUS	VARCHAR2(1)	NOT NULL	The status of the redo thread: D (disabled), E (enabled), or O (open).
SEQUENCE#	NUMBER	NOT NULL	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 SCN of the last disabled thread.
DISABLE_TIME	DATE		The time of the last disabled thread.