[20161111File Space Bitmap Block修复机制

[20161111]File Space Bitmap Block修复机制.txt

--前几天在测试File Space Bitmap Block时执行了，execute dbms_space_admin.TABLESPACE_REBUILD_BITMAPS('SUGAR')
--这样位图区全部设置为1,显示都是F。它的修复机制不是非常清楚，今天做一些深入的探究。

--继续重复昨天的测试。

1.环境：
SCOTT@book> @ &r/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

CREATE TABLESPACE SUGAR DATAFILE
  '/mnt/ramdisk/book/sugar01.dbf' SIZE 40M AUTOEXTEND ON NEXT 16M MAXSIZE UNLIMITED
LOGGING
ONLINE
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;

create table t1 tablespace sugar as select rownum id ,lpad('A',32,'A') name from dual connect by level<=1e5;
--建立大小5M的表。

create table t2 tablespace sugar as select rownum id ,lpad('B',32,'B') name from dual connect by level<=2e5;
create table t3 tablespace sugar as select rownum id ,lpad('C',32,'C') name from dual connect by level<=2e5;
alter system checkpoint;

2.转储位图区信息：

SYS@book> execute dbms_space_admin.tablespace_dump_bitmaps('SUGAR');
PL/SQL procedure successfully completed.

Header Control:
RelFno: 6, Unit: 8, Size: 5120, Flag: 9
AutoExtend: YES, Increment: 2048, MaxSize: 4194302
Initial Area: 126, Tail: 5119, First: 400, Free: 224
Deallocation scn: 925704.0
Header Opcode:
Save: No Pending Op
File Space Bitmap Block:
BitMap Control:
RelFno: 6, BeginBlock: 128, Flag: 0, First: 400, Free: 63088
FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFF000000000000 0000000000000000
0000000000000000 0000000000000000 0000000000000000 0000000000000000
0000000000000000 0000000000000000 0000000000000000 0000000000000000
0000000000000000 0000000000000000 0000000000000000 0000000000000000
0000000000000000 0000000000000000 0000000000000000 0000000000000000

$ bvi -b 24576 -s 8192 /mnt/ramdisk/book/sugar01.dbf
00006000  1E A2 00 00 03 00 80 01 25 DC 5F 00 00 00 01 04 5B B1 00 00 06 00 00 00 80 00 00 00 00 00 00 00 ........%._.....[...............
00006020  90 01 00 00 70 F6 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 FF FF FF FF FF FF FF FF ....p...........................
00006040  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
00006060  FF FF FF FF FF FF FF FF FF FF 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
00006080  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
000060A0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
000060C0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................

-- 偏移 60 后仅仅 10个 FF。

--关闭数据库重新启动，并且dba 6,3 全部FF变为00.注意其他不动，注意要重新计算检查和。

BBED> sum
Check value for File 6, Block 3:
current = 0xb15b, required = 0x4ea4

BBED> sum apply dba 6,3
Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y
Check value for File 6, Block 3:
current = 0x4ea4, required = 0x4ea4

--启动数据库。
SYS@book> @ &r/bh 6 3
no rows selected

--可以发现现在该数据块没有在数据缓存中。

3.分析执行过程：

SYS@book> @ &r/spid

       SID    SERIAL# SPID       PID  P_SERIAL# C50
---------- ---------- ------ ------- ---------- --------------------------------------------------
       232          7 5574        21          4 alter system kill session '232,7' immediate;

--打开另外终端执行：
$ strace -f -p 5574 -o /tmp/map.txt

--切换回去：
SYS@book> execute dbms_space_admin.TABLESPACE_REBUILD_BITMAPS('SUGAR');
PL/SQL procedure successfully completed.

$ bvi -b 24576 -s 8192 /mnt/ramdisk/book/sugar01.dbf
00006000  1E A2 00 00 03 00 80 01 B7 D6 5F 00 00 00 02 04 44 41 00 00 06 00 00 00 80 00 00 00 00 00 00 00 .........._.....DA..............
00006020  00 F8 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 FF FF FF FF FF FF FF FF ................................
00006040  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
00006060  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
00006080  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
000060A0  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
000060C0  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
000060E0  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
00006100  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
00006120  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
00006140  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
00006160  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
00006180  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
000061A0  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
000061C0  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
000061E0  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
00006200  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
00006220  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
00006240  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
00006260  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
00006280  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
000062A0  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
000062C0  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
000062E0  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................

--你可以发现数据文件的位图区块里面全是F。表示已经使用，而实际上你检查对应的内存块：

SYS@book> @ &r/bh 6 3
HLADDR              DBARFIL     DBABLK      CLASS CLASS_TYPE         STATE             TCH CR_SCN_BAS CR_SCN_WRP CR_UBA_FIL CR_UBA_BLK CR_UBA_SEQ BA               OBJECT_NAME
---------------- ---------- ---------- ---------- ------------------ ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------------- --------------------
0000000084B84748          6          3         12 bitmap index block free                0          0          0          0          0          0 00000000756A8000
0000000084B84748          6          3         12 bitmap index block xcur                1          0          0          0          0          0 00000000756AA000

--STATE=xcur BA=00000000756AA000
--你可以发现FF从32+24=56 开始，56 = 0x38

SYS@book> oradebug setmypid
Statement processed.

SYS@book> oradebug peek 0x00000000756AA000 16
[0756AA000, 0756AA010) = 0000A21E 01800003 005FDC25 00010000

--00006000  1E A2 00 00 03 00 80 01 B7 D6 5F 00 00 00 02 04 44 41 00 00 06 00 00 00 80 00 00 00 00 00 00 00 .........._.....DA..............
                        ~~~~~~~~~~~
--大小头对调可以发现的dba地址一致。

SYS@book> oradebug peek 0x00000000756AA038 16
[0756AA038, 0756AA048) = FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF
--全是FF

SYS@book> oradebug peek 0x00000000756AA060 16
[0756AA060, 0756AA070) = FFFFFFFF FFFFFFFF 0000FFFF 00000000

SYS@book> oradebug peek 0x00000000756AA100 16
[0756AA100, 0756AA110) = 00000000 00000000 00000000 00000000

--而偏移量0x100= 256，全都是00.也就是内存中的数据块是正确，由此可以推出他的恢复机制，先修改数据块设置FF，读取到缓存中然
--后扫描分析数据块，在内存数据块中标识那些块使用了。

--如果你发出alter system checkpoint，这样内存的信息写到数据文件中，结果就是正确的。

SYS@book> alter system checkpoint;
System altered.

SYS@book> @ &r/bh 6 3
old  23:   dbarfil = &1 and
new  23:   dbarfil = 6 and
old  24:   dbablk = &2
new  24:   dbablk = 3
HLADDR              DBARFIL     DBABLK      CLASS CLASS_TYPE         STATE             TCH CR_SCN_BAS CR_SCN_WRP CR_UBA_FIL CR_UBA_BLK CR_UBA_SEQ BA               OBJECT_NAME
---------------- ---------- ---------- ---------- ------------------ ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------------- --------------------
0000000084B84748          6          3         12 bitmap index block free                0          0          0          0          0          0 00000000756A8000
0000000084B84748          6          3         12 bitmap index block xcur                1          0          0          0          0          0 00000000756AA000

$ bvi -b 24576 -s 8192 /mnt/ramdisk/book/sugar01.dbf
00006000  1E A2 00 00 03 00 80 01 25 DC 5F 00 00 00 01 04 5B B1 00 00 06 00 00 00 80 00 00 00 00 00 00 00 ........%._.....[...............
00006020  90 01 00 00 70 F6 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 FF FF FF FF FF FF FF FF ....p...........................
00006040  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
00006060  FF FF FF FF FF FF FF FF FF FF 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
00006080  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
000060A0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
000060C0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
000060E0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................

--可以发现已经修复了。根本不需要担心开始全部写入FF，标识全部使用，实际上内存对应的数据块是正确的。

4.深入分析：

--检查跟踪文件
# ls -l /proc/5574/fd
total 0
lr-x------ 1 oracle oinstall 64 2016-11-11 10:52:23 0 -> /dev/null
l-wx------ 1 oracle oinstall 64 2016-11-11 10:52:23 1 -> /dev/null
l-wx------ 1 oracle oinstall 64 2016-11-11 10:52:23 12 -> pipe:[19152388]
l-wx------ 1 oracle oinstall 64 2016-11-11 10:52:23 2 -> /dev/null
lrwx------ 1 oracle oinstall 64 2016-11-11 10:54:01 256 -> /mnt/ramdisk/book/sugar01.dbf
lrwx------ 1 oracle oinstall 64 2016-11-11 10:54:01 258 -> /mnt/ramdisk/book/system01.dbf
lr-x------ 1 oracle oinstall 64 2016-11-11 10:52:23 3 -> /dev/null
lr-x------ 1 oracle oinstall 64 2016-11-11 10:52:23 4 -> /u01/app/oracle/product/11.2.0.4/dbhome_1/rdbms/mesg/oraus.msb
lr-x------ 1 oracle oinstall 64 2016-11-11 10:52:23 5 -> /proc/5574/fd
lr-x------ 1 oracle oinstall 64 2016-11-11 10:52:23 6 -> /dev/zero
lrwx------ 1 oracle oinstall 64 2016-11-11 10:52:23 7 -> /u01/app/oracle/admin/book/adump/book_ora_5574_20161111105146035812143795.aud
lr-x------ 1 oracle oinstall 64 2016-11-11 10:52:23 9 -> pipe:[19152387]

$ grep write /tmp/map.txt
5197  write(12, "\0\265\0\0\6\0\0\0\0\0\10\6\0\274\333_\0\0\0\0\0\10\0\0\0\0\0\0\0\0\0\0"..., 181) = 181
5197  write(12, "\0\21\0\0\6\0\0\0\0\0\t\1\0\0\0\0\0", 17) = 17
--写很少，不知道什么回事。

$ grep pread /tmp/map.txt
5197  pread(258, "\6\242\0\0008\17@\0\271v\16\0\0\0\1\6v\225\0\0\1\0\0\0\10\0\0\0\270v\16\0"..., 32768, 31916032) = 32768
5197  pread(258, "\6\242\0\0\363\26@\0\2544\0\0\0\0\2\4\36\202\0\0\1\0\0\0\10\0\0\0\2544\0\0"..., 24576, 48128000) = 24576
5197  pread(258, "\6\242\0\0\361\35@\0\353@\0\0\0\0\2\4\r\301\0\0\1\0\0\0\10\0\0\0\353@\0\0"..., 8192, 62791680) = 8192
5197  pread(258, "\6\242\0\0s5@\0\231@\3\0\0\0\3\4\211\305\0\0\1\0\6\0\10\0\0\0\231@\3\0"..., 8192, 112091136) = 8192
5197  pread(258, "\6\242\0\0u5@\0\255\266\1\0\0\0\1\6\215\221\0\0\1\0\0\0\10\0\0\0\237\266\1\0"..., 16384, 112107520) = 16384
5197  pread(258, "\6\242\0\0pm@\0\313\327\2\0\0\0\1\6\205_\0\0\1\0 \0\10\0\0\0x\327\2\0"..., 8192, 229507072) = 8192
5197  pread(258, "\6\242\0\0rm@\0\261\341\2\0\0\0\1\6\317}\0\0\1\0\24\0\10\0\0\0006\341\2\0"..., 8192, 229523456) = 8192
5197  pread(258, "\6\242\0\0\246!A\0r+\16\0\0\0\1\6F\323\0\0\1\0\33\0\10\0\0\0\274*\16\0"..., 8192, 607436800) = 8192
5197  pread(258, "\6\242\0\0\252!A\0\223\26\17\0\0\0\1\6s\322\0\0\1\0@\0\10\0\0\0\222\26\17\0"..., 8192, 607469568) = 8192
5197  pread(258, "\6\242\0\0\254!A\0\264m\16\0\0\0\2\4k\6\0\0\1\0@\0\10\0\0\0\264m\16\0"..., 40960, 607485952) = 40960
5197  pread(263, "#\242\0\0\202\0\200\1-\320_\0\0\0\1\4\321\361\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 8192, 1064960) = 8192
5197  pread(263, "#\242\0\0\2\3\200\1v\320_\0\0\0\1\4\322\361\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 8192, 6307840) = 8192
5197  pread(263, "#\242\0\0\2\10\200\1\270\320_\0\0\0\1\4\321\361\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 8192, 16793600) = 8192
5197  pread(258, "\6\242\0\0\265!A\0l\224\16\0\0\0\3\0040\324\0\0\1\0\0\0\10\0\0\0l\224\16\0"..., 16384, 607559680) = 16384
5197  pread(263, "#\242\0\0\202\0\200\1-\320_\0\0\0\1\4\321\361\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 8192, 1064960) = 8192
5197  pread(258, "\6\242\0\0\36\v@\0\244\"\3\0\0\0\1\6\322\333\0\0\1\0\0\0\274\1\0\0\241\"\3\0"..., 8192, 23314432) = 8192
5197  pread(258, "\6\242\0\0\37\v@\0\244\"\3\0\0\0\1\6A\301\0\0\1\0\0\0\274\1\0\0\242\"\3\0"..., 8192, 23322624) = 8192
5197  pread(258, "\6\242\0\0\305\3@\0\2228\17\0\0\0\1\6\211+\0\0\2\0\0\0y\0\0\0\2168\17\0"..., 8192, 7905280) = 8192
5197  pread(258, "\6\242\0\0\253\3@\0\2228\17\0\0\0\1\6\375\316\0\0\1\0\36\0v\0\0\0\2168\17\0"..., 8192, 7692288) = 8192
5197  pread(263, "#\242\0\0\2\3\200\1v\320_\0\0\0\1\4\322\361\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 8192, 6307840) = 8192
5197  pread(263, "#\242\0\0\2\10\200\1\270\320_\0\0\0\1\4\321\361\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 8192, 16793600) = 8192

--先分析263句柄的情况：
$ grep pread /tmp/map.txt | grep '263,'
5197  pread(263, "#\242\0\0\202\0\200\1-\320_\0\0\0\1\4\321\361\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 8192, 1064960) = 8192
5197  pread(263, "#\242\0\0\2\3\200\1v\320_\0\0\0\1\4\322\361\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 8192, 6307840) = 8192
5197  pread(263, "#\242\0\0\2\10\200\1\270\320_\0\0\0\1\4\321\361\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 8192, 16793600) = 8192
5197  pread(263, "#\242\0\0\202\0\200\1-\320_\0\0\0\1\4\321\361\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 8192, 1064960) = 8192
5197  pread(263, "#\242\0\0\2\3\200\1v\320_\0\0\0\1\4\322\361\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 8192, 6307840) = 8192
5197  pread(263, "#\242\0\0\2\10\200\1\270\320_\0\0\0\1\4\321\361\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 8192, 16793600) = 8192

--1064960/8192=130
--6307840/8192=770
--16793600/8192=2050

SYS@book> select segment_name,header_file,header_block from dba_segments where owner='SCOTT' and header_file=6;
SEGMENT_NAME         HEADER_FILE HEADER_BLOCK
-------------------- ----------- ------------
T3                             6         2050
T2                             6          770
T1                             6          130

--正好是表T1,T2,T3的块头。也就是通过扫描表头，确定那些段使用了，回填位图区的信息。

5.做一个极端测试:

SYS@book> execute dbms_space_admin.TABLESPACE_REBUILD_BITMAPS('SUGAR');
PL/SQL procedure successfully completed.

SYS@book> shutdown abort
ORACLE instance shut down.

$ bvi -b 24576 -s 8192 /mnt/ramdisk/book/sugar01.dbf
00006000  1E A2 00 00 03 00 80 01 32 F5 5F 00 00 00 02 04 44 41 00 00 06 00 00 00 80 00 00 00 00 00 00 00 ........2._.....DA..............
00006020  00 F8 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 FF FF FF FF FF FF FF FF ................................
00006040  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
00006060  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
00006080  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
000060A0  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
000060C0  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
000060E0  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................

--可以发现是FF。然后重新启动数据库到mount状态。

SYS@book> startup mount
ORACLE instance started.

Total System Global Area  634732544 bytes
Fixed Size                  2255792 bytes
Variable Size             197133392 bytes
Database Buffers          427819008 bytes
Redo Buffers                7524352 bytes
Database mounted.

RMAN> backup datafile 6 format '/u01/backup/d6_1.bak' ;
Starting backup at 2016-11-11 11:11:08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=/mnt/ramdisk/book/sugar01.dbf
channel ORA_DISK_1: starting piece 1 at 2016-11-11 11:11:09
channel ORA_DISK_1: finished piece 1 at 2016-11-11 11:11:10
piece handle=/u01/backup/d6_1.bak tag=TAG20161111T111109 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2016-11-11 11:11:10

$ ls -l /u01/backup/d6_1.bak
-rw-r----- 1 oracle oinstall 26066944 2016-11-11 11:11:09 /u01/backup/d6_1.bak

$ ls -lh /u01/backup/d6_1.bak
-rw-r----- 1 oracle oinstall 25M 2016-11-11 11:11:09 /u01/backup/d6_1.bak

--大小26066944/1024/1024=24.859375M,可以发现备份并不依赖这个位图区扫描。

SYS@book> alter database open ;
Database altered.

SYS@book> @ &r/bh 6 3
HLADDR              DBARFIL     DBABLK      CLASS CLASS_TYPE         STATE             TCH CR_SCN_BAS CR_SCN_WRP CR_UBA_FIL CR_UBA_BLK CR_UBA_SEQ BA               OBJECT_NAME
---------------- ---------- ---------- ---------- ------------------ ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------------- --------------------
0000000084B84748          6          3         12 bitmap index block xcur                0          0          0          0          0          0 000000007A3C4000

SYS@book> alter system checkpoint;
System altered.

00006000  1E A2 00 00 03 00 80 01 32 F5 5F 00 00 00 02 04 44 41 00 00 06 00 00 00 80 00 00 00 00 00 00 00 ........2._.....DA..............
00006020  00 F8 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 FF FF FF FF FF FF FF FF ................................
00006040  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
00006060  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
00006080  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
000060A0  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
000060C0  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
000060E0  FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF ................................
--可以发现并没有修复位图区。

SYS@book> alter system checkpoint;
System altered.

SYS@book> oradebug setmypid
Statement processed.

SYS@book> oradebug peek 0x000000007A3C4100 16
[07A3C4100, 07A3C4110) = FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF

--从这里看也可以证明没有修复。

SCOTT@book> create table t4 tablespace sugar as select rownum id ,lpad('D',32,'D') name from dual connect by level<=1e5;
create table t4 tablespace sugar as select rownum id ,lpad('D',32,'D') name from dual connect by level<=1e5
                                                                                 *
ERROR at line 1:
ORA-00600: internal error code, arguments: [ktfbbssearch-9], [0], [624], [63488], [], [], [], [], [], [], [], []

--建表发现错误。

SYS@book> execute dbms_space_admin.TABLESPACE_REBUILD_BITMAPS('SUGAR');
PL/SQL procedure successfully completed.

SCOTT@book> create table t4 tablespace sugar as select rownum id ,lpad('D',32,'D') name from dual connect by level<=1e5;
Table created.

--OK，现在建表成功。

SCOTT@book> column PARTITION_NAME noprint
SCOTT@book> select * from dba_extents where owner=user and segment_name in ('T3','T4');
OWNER  SEGMENT_NAME SEGMENT_TYPE TABLESPACE_NAME  EXTENT_ID    FILE_ID   BLOCK_ID      BYTES     BLOCKS RELATIVE_FNO
------ ------------ ------------ --------------- ---------- ---------- ---------- ---------- ---------- ------------
SCOTT  T3           TABLE        SUGAR                    0          6       2048      65536          8            6
SCOTT  T3           TABLE        SUGAR                    1          6       2056      65536          8            6
....
SCOTT  T3           TABLE        SUGAR                   21          6       2816    1048576        128            6
SCOTT  T3           TABLE        SUGAR                   22          6       2944    1048576        128            6
SCOTT  T3           TABLE        SUGAR                   23          6       3072    1048576        128            6
SCOTT  T3           TABLE        SUGAR                   24          6       3200    1048576        128            6
SCOTT  T4           TABLE        SUGAR                    0          6       3328      65536          8            6
...
SCOTT  T4           TABLE        SUGAR                   17          6       3584    1048576        128            6
SCOTT  T4           TABLE        SUGAR                   18          6       3712    1048576        128            6
SCOTT  T4           TABLE        SUGAR                   19          6       3840    1048576        128            6
45 rows selected.

--t3,T4的空间是连续的。

--看来做后台数据维护最大的敌人是死机或者掉电。

时间： 2024-07-30 11:05:03

[20161111File Space Bitmap Block修复机制的相关文章

20161114File Space Bitmap Block修复机制2

[20161114]File Space Bitmap Block修复机制2.txt --前几天在测试File Space Bitmap Block时执行了,execute dbms_space_admin.TABLESPACE_REBUILD_BITMAPS('SUGAR') --这样位图区全部设置为1,显示都是F. --上次提到,execute dbms_space_admin.TABLESPACE_REBUILD_BITMAPS('SUGAR')会修改位图区全部设置为1,显示都是F. --

1108File Space Bitmap Block损坏能修复吗2

[20161108]File Space Bitmap Block损坏能修复吗? --这阵子做了数据文件的一些探究,还是回到File Space Bitmap Block损坏修复的问题. --链接http://www.itpub.net/thread-2071023-1-1.html提到File Space Bitmap Block损坏,问能修复吗? --通过我前面的测试,可以把空间设置为1.这样就可以解决这个问题,问题在在于相应的数据块如何构造. --实际上很简单我仅仅建立1个相同大小的数据文

1104File Space Bitmap Block损坏能修复吗

[20161104]File Space Bitmap Block损坏能修复吗?.txt -- 链接http://www.itpub.net/thread-2071023-1-1.html提到File Space Bitmap Block损坏,问能修复吗? 1.环境: SCOTT@book> @ &r/ver1 PORT_STRING                    VERSION        BANNER ------------------------------ -------

小而美的自我管理和修复机制

摘要: 借助微信,杭州微车队实现了不可思议的自我组织.协调.分工,这个自发的民间组织不属于任何一个商业机构,但是他们有序的自我管理能力令团队每个成员月收入至少提升了20%以上 借助微信,杭州微车队实现了不可思议的自我组织.协调.分工,这个自发的民间组织不属于任何一个商业机构,但是他们有序的自我管理能力令团队每个成员月收入至少提升了20%以上.今后或许会有越来越多类似的小而美组织的出现,移动互联网令去中心化的社会化协作变得更加高效. 周一下午4点多,邵展成在杭州机场出租车入口处静静地等待.几分钟前

测量block size 为8K ，自动分配的本地管理表空间的位图block一位能管理多少空间

从oracle8i起,oracle推出了本地管理表空间的来代替数据字典管理的表空间,数据字典管理表空间是用uet$,fet$这两个表来管理的,它们现在依然存在于数据库中,不过不起任何作用. SQL> select count(*) from uet$;   COUNT(*) ----------          0 SQL> select count(*) from fet$;   COUNT(*) ----------          0 下面来探究自动分配的本地管理表空间中一个bit

[20161107]关于数据文件位图区.txt

[20161107]关于数据文件位图区.txt --上个星期写一篇 [20161104]File Space Bitmap Block损坏能修复吗?.txt 链接:http://blog.itpub.net/267265/viewspace-2127826/       http://www.itpub.net/thread-2071023-1-1.html --里面提到 --正常数据文件第1块OS.第2块是文件头,第3块开始-128块是位图区. --我文件很小,估计在1块里面: --8192*

dump命令3——dump数据文件

转自网络: 1.dump数据文件头 就是datafile 的第1,第2个block,我们直接通过alter system dump datafile n block min 1 max 2;是得不到任何信息的,请看测试: SQL> alter system dump datafile 1 block min 1 block max 2; 系统已更改. 部分的DUMP文件内容 Start dump data blocks tsn: 0 file#: 1 minblk 1 maxblk 2 Bloc

[20171206]位图区一定在数据文件开头吗.txt

[20171206]位图区一定在数据文件开头吗.txt --//如果问你oracle数据文件的位图区位于数据文件开头部分吗?我想大家的回答一定,实际上在10g下未必,因为10g建立的数据文件. --//在数据区前面仅仅8块,第1块作为文件头,第2块作为位图区头,第3-8块(共6块)作为位图区,一般1个位图区块能容纳 --//(494+2)*32*4= 63488区,1个区=64K(对于SEGMENT SPACE MANAGEMENT AUTO). --//这样1个位图块可以容纳63488*64*

[20170412]op code列表.txt

[20170412]op code列表.txt 转载:http://www.itpub.net/thread-1517926-1-1.html --看redo转储,需要了解OP的含义,做一个记录: 附op code列表(来自网络): 格式:layer: opcode        LAYER的含义:                4 - Block Cleanout                5 - Transaction Management              10 - 索引操作