RE: [SPAM] unnrecoverable change #
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <JBECKSTROM@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>, <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>, <ORACLE-L@xxxxxxxxxxxxx>, <oracledba@xxxxxxxxxxx>, <oracle-rdbms@xxxxxxxxxxxxxxx>
- Date: Thu, 17 Nov 2005 10:57:41 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jeffrey Beckstrom
Sent: Thursday, November 17, 2005 8:55 AM
To: oracle-l@xxxxxxxxxxxxx; oracle-db-l@xxxxxxxxxxxxxxxxxxxx;
ORACLE-L@xxxxxxxxxxxxx; oracledba@xxxxxxxxxxx;
oracle-rdbms@xxxxxxxxxxxxxxx
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
Other related posts:
- » RE: [SPAM] unnrecoverable change #
