RE: [SPAM] unnrecoverable change #

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Thu, 17 Nov 2005 10:57:41 -0500
Message-ID: <AA29A27627F842409E1D18FB19CDCF2705B96D37@AABO-EXCHANGE02.bos.il.pqe>

It means that a segment in FILE# 6 has had data blocks loaded in unrecoverable or nologging mode, at that SCN (the unrecoverable_change#). If you have not backed up that data file since that SCN, you would not be able to completely recover from a media recovery. The affected blocks would be corrupt, even after recovery, since the changes to those blocks are not in the redo stream.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeffrey Beckstrom Sent: Thursday, November 17, 2005 8:55 AM To: oracle-l_at_freelists.org; oracle-db-l_at_Groups.ITtoolbox.com; ORACLE-L_at_IC.SUNYSB.EDU; oracledba_at_LazyDBA.com; oracle-rdbms_at_yahoogroups.com
Subject: [SPAM] unnrecoverable change #
Importance: Low

What does this mean????
SQL> select * from v$datafile where UNRECOVERABLE_CHANGE# <>0; FILE# CREATION_CHANGE# CREATION_ TS# RFILE# STATUS ENABLED

---------- ---------------- --------- ---------- ---------- -------

CHECKPOINT_CHANGE# CHECKPOIN UNRECOVERABLE_CHANGE# UNRECOVER LAST_CHANGE#

------------------ --------- --------------------- ---------

LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE# ONLINE_TI BYTES BLOCKS --------- --------------- -------------- --------- ---------- ----------

CREATE_BYTES BLOCK_SIZE
------------ ----------
NAME

PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME

6 10519 08-JAN-99 3 6 ONLINE READ WRITE 2809106041 16-NOV-05 867539955 29-NOV-04 700381928 700381929 12-JUN-04 1677721600 204800 0 8192
F:\OR15\AP_INDEX_A.DBS
0 8192
UNKNOWN

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 17 2005 - 11:03:12 CST