[20190130]刪除tab$記錄的恢復.txt

--//網上提到許多刪除tab$的案例,主要原因在於沒有從官方正規渠道下載oracle版本,還有一些來自工具裡面帶有一些指令碼刪除tab$記錄.

--//首先我並不知道許多人的恢復方法,僅僅簡單提到恢復資料字典,我想到既然是刪除,反向的操作就是恢復.也就是恢復tab$記錄.

--//在我開始嘗試時,我發現遇到的問題比原來想像的要複雜.tab$是CLUSTER C_OBJ#的一個表.本身cluster table的結果就與普通

--//堆表的結構不一樣,還有可能遇到行連結和行遷移的情況.

--//這也是我最近許多帖子關於cluster table等方面的內容.

--//自己也嘗試恢復看看.

1.環境:

SCOTT@book> @ ver1

PORT_STRING VERSION BANNER

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

x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

SCOTT@book> column SQL_TEXT format a100

SCOTT@book> select * from (select * from SYS.BOOTSTRAP$ order by line#) where rownum<=5;

LINE# OBJ# SQL_TEXT

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

-1 -1 8.0.0.0.0

0 0 CREATE ROLLBACK SEGMENT SYSTEM STORAGE ( INITIAL 112K NEXT 56K MINEXTENTS 1 MAXEXTENTS 32765 OBJNO

0 EXTENTS (FILE 1 BLOCK 128))

2 2 CREATE CLUSTER C_OBJ#("OBJ#" NUMBER) PCTFREE 5 PCTUSED 40 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL

136K NEXT 200K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 OBJNO 2 EXTENTS (FILE 1 BLOCK 144))

SIZE 800

3 3 CREATE INDEX I_OBJ# ON CLUSTER C_OBJ# PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT

1024K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 OBJNO 3 EXTENTS (FILE 1 BLOCK 168))

4 4 CREATE TABLE TAB$("OBJ#" NUMBER NOT NULL,"DATAOBJ#" NUMBER,"TS#" NUMBER NOT NULL,"FILE#" NUMBER NOT

NULL,"BLOCK#" NUMBER NOT NULL,"BOBJ#" NUMBER,"TAB#" NUMBER,"COLS" NUMBER NOT NULL,"CLUCOLS" NUMBER,"

PCTFREE$" NUMBER NOT NULL,"PCTUSED$" NUMBER NOT NULL,"INITRANS" NUMBER NOT NULL,"MAXTRANS" NUMBER NO

T NULL,"FLAGS" NUMBER NOT NULL,"AUDIT$" VARCHAR2(38) NOT NULL,"ROWCNT" NUMBER,"BLKCNT" NUMBER,"EMPCN

T" NUMBER,"AVGSPC" NUMBER,"CHNCNT" NUMBER,"AVGRLN" NUMBER,"AVGSPC_FLB" NUMBER,"FLBCNT" NUMBER,"ANALY

ZETIME" DATE,"SAMPLESIZE" NUMBER,"DEGREE" NUMBER,"INSTANCES" NUMBER,"INTCOLS" NUMBER NOT NULL,"KERNE

LCOLS" NUMBER NOT NULL,"PROPERTY" NUMBER NOT NULL,"TRIGFLAG" NUMBER,"SPARE1" NUMBER,"SPARE2" NUMBER,

"SPARE3" NUMBER,"SPARE4" VARCHAR2(1000),"SPARE5" VARCHAR2(1000),"SPARE6" DATE) STORAGE ( OBJNO 4 TA

BNO 1) CLUSTER C_OBJ#(OBJ#)

--//sys.tab$表是cluster table C_OBJ#下的一個表.OBJ#=2

SELECT ROWNUM -1 rn , a.*

FROM ( SELECT *

FROM dba_objects

WHERE owner = 'SYS' AND data_object_id = 2

ORDER BY object_id) a;

RN OWNER OBJECT_NAME SUBOBJECT_ OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_TIME TIMESTAMP STATUS T G S NAMESPACE EDITION_NAME

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

0 SYS C_OBJ# 2 2 CLUSTER 2013-08-24 11:37:35 2013-08-24 11:37:35 2013-08-24:11:37:35 VALID N N N 5

1 SYS TAB$ 4 2 TABLE 2013-08-24 11:37:35 2013-08-24 11:47:37 2013-08-24:11:37:35 VALID N N N 1

2 SYS CLU$ 5 2 TABLE 2013-08-24 11:37:35 2013-08-24 11:37:35 2013-08-24:11:37:35 VALID N N N 1

3 SYS IND$ 19 2 TABLE 2013-08-24 11:37:35 2013-08-24 11:47:37 2013-08-24:11:37:35 VALID N N N 1

4 SYS ICOL$ 20 2 TABLE 2013-08-24 11:37:35 2013-08-24 11:47:37 2013-08-24:11:37:35 VALID N N N 1

5 SYS COL$ 21 2 TABLE 2013-08-24 11:37:35 2013-08-24 11:52:40 2013-08-24:11:37:35 VALID N N N 1

6 SYS LOB$ 80 2 TABLE 2013-08-24 11:37:36 2013-08-24 11:47:37 2013-08-24:11:37:36 VALID N N N 1

7 SYS COLTYPE$ 83 2 TABLE 2013-08-24 11:37:36 2013-08-24 11:47:37 2013-08-24:11:37:36 VALID N N N 1

8 SYS SUBCOLTYPE$ 86 2 TABLE 2013-08-24 11:37:36 2013-08-24 11:37:36 2013-08-24:11:37:36 VALID N N N 1

9 SYS NTAB$ 88 2 TABLE 2013-08-24 11:37:36 2013-08-24 11:37:36 2013-08-24:11:37:36 VALID N N N 1

10 SYS REFCON$ 92 2 TABLE 2013-08-24 11:37:36 2013-08-24 11:37:36 2013-08-24:11:37:36 VALID N N N 1

11 SYS OPQTYPE$ 95 2 TABLE 2013-08-24 11:37:36 2013-08-24 11:37:36 2013-08-24:11:37:36 VALID N N N 1

12 SYS ICOLDEP$ 114 2 TABLE 2013-08-24 11:37:36 2013-08-24 11:37:36 2013-08-24:11:37:36 VALID N N N 1

13 SYS VIEWTRCOL$ 174 2 TABLE 2013-08-24 11:37:36 2013-08-24 11:37:36 2013-08-24:11:37:36 VALID N N N 1

14 SYS LIBRARY$ 252 2 TABLE 2013-08-24 11:37:39 2013-08-24 11:37:39 2013-08-24:11:37:39 VALID N N N 1

15 SYS ASSEMBLY$ 253 2 TABLE 2013-08-24 11:37:39 2013-08-24 11:37:39 2013-08-24:11:37:39 VALID N N N 1

16 SYS ATTRCOL$ 512 2 TABLE 2013-08-24 11:37:43 2013-08-24 11:37:43 2013-08-24:11:37:43 VALID N N N 1

17 SYS TYPE_MISC$ 517 2 TABLE 2013-08-24 11:37:43 2013-08-24 11:37:43 2013-08-24:11:37:43 VALID N N N 1

18 rows selected.

--//可以發現tab$僅僅是cluster table中的1個.而是是第1個表(從0算起,0是cluster table)

2.如何tab$表被全部刪除,自然導致資料庫無法啟動:

--//如何修復呢?

--//CLUSTER C_OBJ#的段頭在dba 1,144.

SCOTT@book> select * from dba_extents where owner='SYS' and segment_name='C_OBJ#';

OWNER SEGMENT_NAME SEGMENT_TYPE TABLESPACE_NAME EXTENT_ID FILE_ID BLOCK_ID BYTES BLOCKS RELATIVE_FNO

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

SYS C_OBJ# CLUSTER SYSTEM 0 1 144 65536 8 1

SYS C_OBJ# CLUSTER SYSTEM 1 1 152 65536 8 1

SYS C_OBJ# CLUSTER SYSTEM 2 1 160 65536 8 1

SYS C_OBJ# CLUSTER SYSTEM 3 1 3336 65536 8 1

SYS C_OBJ# CLUSTER SYSTEM 4 1 4392 65536 8 1

SYS C_OBJ# CLUSTER SYSTEM 5 1 5424 65536 8 1

SYS C_OBJ# CLUSTER SYSTEM 6 1 6152 65536 8 1

SYS C_OBJ# CLUSTER SYSTEM 7 1 7264 65536 8 1

SYS C_OBJ# CLUSTER SYSTEM 8 1 7912 65536 8 1

SYS C_OBJ# CLUSTER SYSTEM 9 1 8464 65536 8 1

SYS C_OBJ# CLUSTER SYSTEM 10 1 8496 65536 8 1

SYS C_OBJ# CLUSTER SYSTEM 11 1 8520 65536 8 1

SYS C_OBJ# CLUSTER SYSTEM 12 1 8552 65536 8 1

SYS C_OBJ# CLUSTER SYSTEM 13 1 8560 65536 8 1

SYS C_OBJ# CLUSTER SYSTEM 14 1 8600 65536 8 1

SYS C_OBJ# CLUSTER SYSTEM 15 1 8624 65536 8 1

SYS C_OBJ# CLUSTER SYSTEM 16 1 8704 1048576 128 1

SYS C_OBJ# CLUSTER SYSTEM 17 1 9856 1048576 128 1

SYS C_OBJ# CLUSTER SYSTEM 18 1 13312 1048576 128 1

SYS C_OBJ# CLUSTER SYSTEM 19 1 17792 1048576 128 1

SYS C_OBJ# CLUSTER SYSTEM 20 1 22400 1048576 128 1

SYS C_OBJ# CLUSTER SYSTEM 21 1 31488 1048576 128 1

SYS C_OBJ# CLUSTER SYSTEM 22 1 65920 1048576 128 1

SYS C_OBJ# CLUSTER SYSTEM 23 1 73984 1048576 128 1

SYS C_OBJ# CLUSTER SYSTEM 24 1 77824 1048576 128 1

SYS C_OBJ# CLUSTER SYSTEM 25 1 86016 1048576 128 1

SYS C_OBJ# CLUSTER SYSTEM 26 1 94208 1048576 128 1

27 rows selected.

--//system的表空間是mssm,bbed可以檢視這種檔案的段頭.這些資訊記錄在

BBED> p /d dba 1,144 ktetb

struct ktetb[0], 8 bytes @108

ub4 ktetbdba @108 4194449

ub4 ktetbnbk @112 7

--//這裡不算段頭,記錄資料部分.僅僅佔7塊.

struct ktetb[1], 8 bytes @116

ub4 ktetbdba @116 4194456

ub4 ktetbnbk @120 8

struct ktetb[2], 8 bytes @124

ub4 ktetbdba @124 4194464

ub4 ktetbnbk @128 8

struct ktetb[3], 8 bytes @132

ub4 ktetbdba @132 4197640

ub4 ktetbnbk @136 8

struct ktetb[4], 8 bytes @140

ub4 ktetbdba @140 4198696

ub4 ktetbnbk @144 8

..

struct ktetb[25], 8 bytes @308

ub4 ktetbdba @308 4280320

ub4 ktetbnbk @312 128

struct ktetb[26], 8 bytes @316

ub4 ktetbdba @316 4288512

ub4 ktetbnbk @320 128

--//我程式中使用的別名如下:

$ alias zdate='date +'\''%Y/%m/%d %T'\'''

$ export RLWRAP=$(which rlwrap)

$ type rlbbed

rlbbed is a function

rlbbed ()

{

cd /home/oracle/bbed;

$RLWRAP -s 9999 -c -r -i -f /usr/local/share/rlwrap/bbed $ORACLE_HOME/bin/bbed parfile=bbed.par cmdfile=cmd.par

}

--//關於bbed配置看相關文件.我下面有一些程式碼使用cut直接取對應位置的資料,可能width(寬度)設定要與我指令碼保持一致.

$ cat cmd.par

set count 64

set width 160

$ cat bbed.par

blocksize=8192

listfile=$HOME/bbed/filelist.txt

mode=edit

PASSWORD=blockedit

SPOOL=Y

--//filelist.txt檔案透過select file#||' '||name c100 from v$dbfile order by file#;生成.

--//首先確定掃描那些塊的指令碼.

/bin/rm /home/oracle/zzz430/bbed/scan*.txt

cd /home/oracle/zzz430/bbed

echo "process 1 start : `zdate` scan dba 1,144 , create scan1.txt about ktetbdba,ktetbnbk"

high_water=`echo p /d dba 1,144 ktech.hwmark_ktech.blkno_ktehw | rlbbed | grep blkno_ktehw | cut -c60- | tr -d " " `

sed "\$s/ktetbnbk=.*$/ktetbnbk=$high_water/" scan1a.txt > scan1.txt

read -p "process 1 finish: `zdate`,enter continue..."

--//結果儲存scan1.txt

--//也就是從dba=4194449開始,掃描7塊. 從4194456開始,掃描8塊....如此到結束。

--//注意僅僅掃描到高水位下的塊.

3.分析掃描塊的情況:

BBED> set dba 4194449

DBA 0x00400091 (4194449 1,145)

BBED> p /d kdbt[1]

struct kdbt[1], 4 bytes @110

sb2 kdbtoffs @110 8

sb2 kdbtnrow @112 7

--//按照前面的查詢，僅僅kdbt[1]記錄相關表sys.tab$的記錄資訊，從偏移8(即*kdbr[8])開始,共有7條記錄.

BBED> x /rnnnnnnnnnnnnncnnnnnnnntnnnnnnnnnncct *kdbr[8]

rowdata[7430] @7884

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

flag@7884: 0x6c (KDRHFL, KDRHFF, KDRHFH, KDRHFC)

lock@7885: 0x00

cols@7886: 31

col 0[2] @7888: 2

col 1[1] @7891: 0

col 2[2] @7893: 1

col 3[3] @7896: 144

col 4[2] @7900: 2

col 5[2] @7903: 4

col 6[2] @7906: 14

col 7[2] @7909: 1

col 8[1] @7912: 0

col 9[1] @7914: 0

col 10[1] @7916: 0

col 11[1] @7918: 0

col 12[3] @7920: 529

col 13[38] @7924: --------------------------------------

col 14[3] @7963: 7789

col 15[3] @7967: 1442

col 16[1] @7971: 0

col 17[1] @7973: 0

col 18[1] @7975: 0

col 19[2] @7977: 32

col 20[1] @7980: 0

col 21[1] @7982: 0

col 22[7] @7984: 2017-02-03 22:00:18

col 23[3] @7992: 7789

col 24[0] @7996: *NULL*

col 25[0] @7997: *NULL*

col 26[2] @7998: 14

col 27[2] @8001: 14

col 28[3] @8004: 1024

col 29[1] @8008: 0

col 30[1] @8010: 0

..

BBED> x /rnnnnnnnnnnnnncnnnnnnnntnnnnnnnnnncct *kdbr[14]

rowdata[6684] @7138

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

flag@7138: 0x6c (KDRHFL, KDRHFF, KDRHFH, KDRHFC)

lock@7139: 0x02

cols@7140: 31

ckix@7141: 7

col 0[2] @7142: 2

col 1[1] @7145: 0

col 2[2] @7147: 1

col 3[3] @7150: 144

col 4[2] @7154: 2

col 5[2] @7157: 3

col 6[2] @7160: 34

col 7[2] @7163: 1

col 8[1] @7166: 0

col 9[1] @7168: 0

col 10[1] @7170: 0

col 11[1] @7172: 0

col 12[3] @7174: 529

col 13[38] @7178: --------------------------------------

col 14[3] @7217: 5066

col 15[3] @7221: 1442

col 16[1] @7225: 0

col 17[1] @7227: 0

col 18[1] @7229: 0

col 19[2] @7231: 91

col 20[1] @7234: 0

col 21[1] @7236: 0

col 22[7] @7238: 2017-02-22 22:00:13

col 23[3] @7246: 5066

col 24[0] @7250: *NULL*

col 25[0] @7251: *NULL*

col 26[2] @7252: 34

col 27[2] @7255: 34

col 28[3] @7258: 1024

col 29[1] @7262: 0

col 30[1] @7264: 0

--//獲取tab$的記錄偏移以及數量.使用scan2.sh指令碼.

echo "process 2 start : `zdate` scan block , get kdbtnrow,kdbtoffs ang grep kdbtnrow=0"

cat scan1.txt | while read i

do

eval $i

#echo $ktetbdba $ktetbnbk

for ((j=1; j<=$ktetbnbk ; j++))

do

echo -n "dba=$ktetbdba;" >> scan2a.txt

ktetbdba=$[ ktetbdba + 1 ]

#echo $ktetbdba

done

grep -v kdbtnrow=0 scan2a.txt > scan2.txt

read -p "process 2 finish: `zdate`,enter continue..."

..

--//生成scan2a.txt,過濾掉kdbtnrow=0.結果儲存scan2.txt

$ head scan2.txt

dba=4194449;kdbtoffs=8;kdbtnrow=7

dba=4194450;kdbtoffs=8;kdbtnrow=5

dba=4194451;kdbtoffs=9;kdbtnrow=6

dba=4194452;kdbtoffs=10;kdbtnrow=9

dba=4194453;kdbtoffs=10;kdbtnrow=10

dba=4194454;kdbtoffs=10;kdbtnrow=10

dba=4194455;kdbtoffs=10;kdbtnrow=10

dba=4194456;kdbtoffs=10;kdbtnrow=10

dba=4194457;kdbtoffs=10;kdbtnrow=10

dba=4194458;kdbtoffs=7;kdbtnrow=7

3.生成修改記錄flag偏移的指令碼:

echo "process 3 start : `zdate` scan block , create bbed'script scan3_bbed.txt for modify delete of flag and create scan4a.txt about block of ckix "

cat scan2.txt | while read i

do

eval $i

begin=$kdbtoffs

end=$[ kdbtoffs + kdbtnrow -1 ]

# echo $dba $kdbtoffs $kdbtnrow $begin $end

kdbr_size=`echo map dba $dba| rlbbed | grep "sb2 kdbr" | sed -e "s/^.*\[//" -e "s/].*$//" `

while [ $begin -le $end ]

do

kdbr_off=`echo p dba $dba offset 0 kdbr | rlbbed | grep "\[$begin\]" | cut -c55-`

if [ $kdbr_off -gt $kdbr_size ]

then

do

eval $k

#echo $dba $offset $value

value=`printf "0x%x" $(( value - 0x10 )) `

echo "assign /x dba $dba offset $offset = $value " >> scan3_bbed.txt

done

# if not found ckix@ and found flag=0x7c , then ckix_value=0, and do not process chained row.

echo "x /rx dba $dba *kdbr[$begin]" | rlbbed | grep "^ckix@" | sed -e "s/^ckix/dba=$dba;/" -e 's/@.*:/ckix_value=/' | tr -d " " >> scan4a.txt

echo "x /rx dba $dba *kdbr[$begin]" | rlbbed | egrep "^ckix@" > /dev/null

if [ $? -eq 1 ]

then

echo "x /rx dba $dba *kdbr[$begin]" | rlbbed | egrep "^^flag@.*: 0x7c" > /dev/null

if [ $? -eq 0 ]

then

echo "dba=$dba;ckix_value=0" >> scan4a.txt

fi

begin=$[ begin + 1 ]

done

read -p "process 3 finish: `zdate`,enter continue..."

--//記錄的偏移量如果小於kdbr_size,這些是覆蓋的記錄可能無法恢復,必須跳過.

--//注意僅僅過濾包含KDRHFD標識的記錄需要修改,生成修改偏移的指令碼儲存在scan3_bbed.txt.

--//修改flag 使用當前值減去 0x10.

--//並且儲存dba,ckix位置的指令碼在scan4a.txt,注意使用註解部分,僅僅過濾KDRHFD標誌的記錄.(寫指令碼時tab$記錄還沒有刪除)

--//注:如果過濾不存在ckix,使用ckix_value=0替代,如果存在行遷移,跳過不處理.

$ head scan3_bbed.txt

assign /x dba 4194449 offset 7884 = 0x5c

assign /x dba 4194449 offset 7756 = 0x5c

assign /x dba 4194449 offset 7632 = 0x5c

assign /x dba 4194449 offset 7512 = 0x5c

assign /x dba 4194449 offset 7388 = 0x5c

assign /x dba 4194449 offset 7266 = 0x5c

assign /x dba 4194449 offset 7138 = 0x5c

assign /x dba 4194450 offset 509 = 0x5c

assign /x dba 4194450 offset 7882 = 0x5c

assign /x dba 4194450 offset 7756 = 0x5c

--//注:實際上正常恢復大部分值是0x6c,刪除前是0x7c.

$ head scan4a.txt

dba=4194449;ckix_value=0

dba=4194449;ckix_value=1

dba=4194449;ckix_value=2

dba=4194449;ckix_value=4

dba=4194449;ckix_value=5

dba=4194449;ckix_value=6

dba=4194449;ckix_value=7

dba=4194450;ckix_value=1

dba=4194450;ckix_value=3

dba=4194450;ckix_value=4

4.修改mref_offset標識:

echo "process 4 start : `zdate` create bbed's scan4_bbed.txt for modify cluster of mref of value "

sort scan4a.txt | uniq > scan4b.txt

cat scan4b.txt | while read i

do

eval $i

#echo $dba $ckix_value

echo -n "dba=$dba;" >> scan4c.txt

done

sed -e 's/;$/;mref_offset=0;value=0/' -e 's/value=/valuek=/' scan4c.txt > scan4.txt

cat scan4.txt | while read i

do

eval $i

# echo $dba $kref_offset $valuek $mref_offset $value

if [ $mref_offset -eq 0 ]

then

mref_offset=$[ $kref_offset+ 2 ]

fi

valuem=$[ value + 1 ]

if [ $valuem -lt $valuek ]

then

echo "assign dba $dba offset $mref_offset = $valuem" >> scan4m_bbed.txt

else

echo "assign dba $dba offset $mref_offset = $valuek" >> scan4k_bbed.txt

fi

done

read -p "process 4 finish: `zdate`,enter continue..."

--//注:如果沒有mref表示的情況其值等於0.實際上這步可以不做修復.對於讀取tab$表沒有問題的.

--//不做,verify類似如下錯誤.

Block Checking: DBA = 4288536, Block Type = KTB-managed data block

data header at 0x7f865724125c

kdbchk: key comref count wrong

keyslot=8

Block 94232 failed with check code 6121

5.建立sum apply指令碼:

echo "process 5 start : create bbed's scan5_bbed.txt for sum apply"

sed -e 's/^dba=/sum apply dba /' -e 's/;.*$//' scan2.txt > scan5_bbed.txt

read -p "process 5 finish: `zdate`,enter continue..."

6.注意問題.

--//恢復記錄後,tab$的索引I_TAB1與表tab$存在不一致的情況.

SYS@book> select rowid,a.* from SYS.BOOTSTRAP$ a where a.sql_text like '%I_TAB1%';

ROWID LINE# OBJ# SQL_TEXT

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

AAAAA7AABAAAAILAAJ 33 33 CREATE INDEX I_TAB1 ON TAB$(BOBJ#) PCTFREE 10 INITRANS 2 MAX

TRANS 255 STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAX

EXTENTS 2147483645 PCTINCREASE 0 OBJNO 33 EXTENTS (FILE 1 BL

OCK 312))

--//必須禁用這個索引.

SYS@book> @ rowid AAAAA7AABAAAAILAAJ

OBJECT FILE BLOCK ROW ROWID_DBA DBA TEXT

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

59 1 523 9 0x40020B 1,523 alter system dump datafile 1 block 523 ;

BBED> x /rnnc dba 1,523 *kdbr[9]

rowdata[1269] @4910

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

flag@4910: 0x2c (KDRHFL, KDRHFF, KDRHFH)

lock@4911: 0x01

cols@4912: 3

col 0[2] @4913: 33

col 1[2] @4916: 33

col 2[189] @4919: CREATE INDEX I_TAB1 ON TAB$(BOBJ#) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483

645 PCTINCREASE 0 OBJNO 33 EXTENTS (FILE 1 BLOCK 312))

--//設定flag=3c,表示刪除.

assign /x dba 1,523 offset 4910= 0x3c

7.剩下的就是測試.但願OK.

--//太長,另外寫一篇blog具體操作過程.另外對於已經出問題的系統,可能要設定_system_trig_enabled=false,job_queue_processes=0啟動資料庫.可能還有一些

--//細節需要注意.

[20190130]刪除tab$記錄的恢復.txt

相關文章