标签云
asm 恢复 asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 kfed MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2662 ORA-600 2663 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 ORACLE恢复 Oracle 恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (100)
- 数据库 (1,597)
- DB2 (22)
- MySQL (70)
- Oracle (1,463)
- Data Guard (49)
- EXADATA (7)
- GoldenGate (21)
- ORA-xxxxx (158)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (13)
- ORACLE 21C (3)
- Oracle ASM (65)
- Oracle Bug (7)
- Oracle RAC (47)
- Oracle 安全 (6)
- Oracle 开发 (27)
- Oracle 监听 (27)
- Oracle备份恢复 (530)
- Oracle安装升级 (84)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (75)
- PostgreSQL (17)
- PostgreSQL恢复 (5)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (36)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (19)
-
最近发表
- Oracle 19c/21c最新patch信息-202404
- PostgreSQL恢复系列:pg_filedump批量处理
- PostgreSQL部分主要字典信息
- PostgreSQL恢复系列:pg_filedump恢复字典构造
- PostgreSQL 16 源码安装
- ORA-00742 ORA-00312 恢复
- 数据库open成功后报ORA-00353 ORA-00354错误引起的一系列问题(本质ntfs文件系统异常)
- ORA-600 ktsiseginfo1故障
- ORA-00600: internal error code, arguments: [16703], [1403], [4] 原因
- 最近遇到几起ORA-600 16703故障(tab$被清空),请引起重视
- ORA-600 2662快速恢复之Patch scn工具
- TNS-12518: TNS:listener could not hand off client connection
- ora.storage无法启动报ORA-12514故障处理
- 断电引起文件scn异常数据库恢复
- ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
- .[hudsonL@cock.li].mkp勒索加密数据库完美恢复
- 模拟带库实现rman远程备份
- 又一例:ORA-600 kclchkblk_4和2662故障
- Oracle误删除数据文件恢复
- Oracle 19C 备库DML重定向—DML Redirection
月归档:三月 2013
非归档异常数据库rman备份
最近在数据库恢复中遇到一个案例:xx单位1.5T oracle 10.2.0.4(redhat 4.5),因为异常关闭操作系统,导致数据库不能启动,需要帮忙恢复。该数据库为非归档模式,使用裸设备,一个裸设备文件大小(35G),数据库文件大小4-30G都有,现在客户要求我们不能对现有环境进行任何操作,需要克隆一份数据库出来,然后在克隆的库上进行数据库恢复操作.数据库环境的克隆最好的方法就是使用rman来完成,但是该数据库为非归档模式,无法直接使用rman进行备份操作.最后采取dd的方式处理(需要注意dd文件大小为block_size*(v$datafile.blocks+1)+v$datafile.offset).因为不能使用rman的一条命令处理,心里一直不舒服,在家里实验,终于还是确定可以通过重建控制文件的方法来欺骗rman是归档模式,来实现rman完成类似工作.
数据库非非归档模式
SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production PL/SQL Release 11.2.0.3.0 - Production CORE 11.2.0.3.0 Production TNS for Linux: Version 11.2.0.3.0 - Production NLSRTL Version 11.2.0.3.0 - Production SQL> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination /u01/oracle/oradata/ora11g/archivelog Oldest online log sequence 7 Current log sequence 9
非归档模式尝试rman 备份
RMAN> backup database format '/u01/oracle/oradata/orall1g_%U'; Starting backup at 22-JAN-13 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=10 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set RMAN-03009: failure of backup command on ORA_DISK_1 channel at 01/22/2013 16:10:49 ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode continuing other job steps, job failed will not be re-run channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set including current SPFILE in backup set channel ORA_DISK_1: starting piece 1 at 22-JAN-13 channel ORA_DISK_1: finished piece 1 at 22-JAN-13 piece handle=/u01/oracle/oradata/orall1g_13o02k8a_1_1 tag=TAG20130122T161048 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ===========================================================
rman的backup or copy命令不能在非归档模式下执行
尝试修改数据库为归档模式
SQL> alter database archivelog; alter database archivelog * ERROR at line 1: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
数据库非正常关闭,不能修改归档模式
重建控制文件
SQL> alter database backup controlfile to trace as '/tmp/ctl'; Database altered. SQL> shutdown immediate ORA-01109: database not open Database dismounted. ORACLE instance shut down. --备份当前控制文件(保留控制文件现场) SQL> STARTUP NOMOUNT ORACLE instance started. Total System Global Area 313860096 bytes Fixed Size 1344652 bytes Variable Size 285215604 bytes Database Buffers 20971520 bytes Redo Buffers 6328320 bytes SQL> CREATE CONTROLFILE REUSE DATABASE "ORA11G" NORESETLOGS ARCHIVELOG 2 MAXLOGFILES 16 3 MAXLOGMEMBERS 3 4 MAXDATAFILES 100 5 MAXINSTANCES 8 6 MAXLOGHISTORY 292 7 LOGFILE 8 GROUP 1 '/u01/oracle/oradata/ora11g/redo01.log' SIZE 50M BLOCKSIZE 512, 9 GROUP 2 '/u01/oracle/oradata/ora11g/redo02.log' SIZE 50M BLOCKSIZE 512, 10 GROUP 3 '/u01/oracle/oradata/ora11g/redo03.log' SIZE 50M BLOCKSIZE 512 11 DATAFILE 12 '/u01/oracle/oradata/ora11g/system01.dbf', 13 '/u01/oracle/oradata/ora11g/sysaux01.dbf', 14 '/u01/oracle/oradata/ora11g/users01.dbf', 15 '/u01/oracle/oradata/ora11g/dbfs01.dbf', 16 '/u01/oracle/oradata/ora11g/tts_xifenfei02.dbf', 17 '/u01/oracle/oradata/ora11g/tts_xifenfei01.dbf', 18 '/u01/oracle/oradata/ora11g/system02.dbf', 19 '/u01/oracle/oradata/ora11g/czum01.dbf', 20 '/u01/oracle/oradata/ora11g/undotbs02.dbf' 21 CHARACTER SET ZHS16GBK 22 ; Control file created.
数据库已经变为归档模式
SQL> archive log list; Database log mode Archive Mode Automatic archival Disabled Archive destination /u01/oracle/oradata/ora11g/archivelog Oldest online log sequence 7 Next log sequence to archive 7 Current log sequence 9
归档模式尝试rman备份
RMAN> backup datafile 1 format '/u01/oracle/oradata/system01_%U'; Starting backup at 22-JAN-13 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00001 name=/u01/oracle/oradata/ora11g/system01.dbf channel ORA_DISK_1: starting piece 1 at 22-JAN-13 channel ORA_DISK_1: finished piece 1 at 22-JAN-13 piece handle=/u01/oracle/oradata/system01_02o02kl7_1_1 tag=TAG20130122T161742 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15 Finished backup at 22-JAN-13 RMAN-06497: WARNING: control file is not current, control file AUTOBACKUP skipped
因为现在的控制文件是新创建的,不能算是数据库的当前控制文件,所以未被rman自动备份(很好理解,重建控制文件后,我们做恢复都要使用using backup controlfile命令)
总结说明
1.数据库为非归档模式,不能使用rman的backup和copy命令来备份
2.因为数据库为非正常关闭不能直接修改为归档模式
3.通过重建控制文件修改数据库(注意备份)为归档模式实现rman正常备份
4.当rman备份好之后,使用原先控制文件替换现在控制文件
bbed模拟提交事务二之屏蔽smon回滚事务
在上一篇修改datablock itl(bbed模拟提交事务一之修改itl)的基础之上,本篇实现修改undo segment header中的相关事务槽信息,从而屏蔽数据库在重启或者进程异常的时候,smon的回滚操作,从而比较完美的实现了手工提交数据库事务
update table and uncommit(session 1)
SQL> select distinct 2 dbms_rowid.rowid_relative_fno(rowid) rel_fno, 3 dbms_rowid.rowid_block_number(rowid) block_no 4 from chf.t_xifenfei; REL_FNO BLOCK_NO ---------- ---------- 4 28 SQL> select * from chf.t_xifenfei; OBJECT_ID OBJECT_NAME ---------- -------------------- 20 xifenfei.com 44 xifenfei.com 28 xifenfei.com 15 xifenfei.com 29 xifenfei.com 3 xifenfei.com 25 xifenfei.com 39 xifenfei.com 51 xifenfei.com 26 xifenfei.com 17 xifenfei.com 13 xifenfei.com 9 xifenfei.com 41 xifenfei.com 48 I_CON1 38 I_OBJ3 7 I_TS# 53 I_CDEF4 19 IND$ 19 rows selected. SQL> update chf.t_xifenfei set object_name='orasos.com' where rownum<10; 9 rows updated. SQL> select * from chf.t_xifenfei; OBJECT_ID OBJECT_NAME ---------- -------------------- 20 orasos.com 44 orasos.com 28 orasos.com 15 orasos.com 29 orasos.com 3 orasos.com 25 orasos.com 39 orasos.com 51 orasos.com 26 xifenfei.com 17 xifenfei.com 13 xifenfei.com 9 xifenfei.com 41 xifenfei.com 48 I_CON1 38 I_OBJ3 7 I_TS# 53 I_CDEF4 19 IND$ 19 rows selected.
dump undo header(session 2)
SQL> alter system flush buffer_cache; System altered. SQL> alter system checkpoint; System altered. SQL> SELECT XIDUSN,XIDSLOT,XIDSQN,UBAFIL,UBABLK,UBASQN,UBAREC FROM v$transaction; XIDUSN XIDSLOT XIDSQN UBAFIL UBABLK UBASQN UBAREC ---------- ---------- ---------- ---------- ---------- ---------- ---------- 1 13 367 2 1126 362 32 SQL> alter system dump undo header "_SYSSMU1$"; System altered. index state cflags wrap# uel scn dba parent-xid nub stmt_num cmt ------------------------------------------------------------------------------------------------------------------ ………… 0x0c 9 0x00 0x016e 0x0029 0x0b2c.c02d1f6a 0x00800464 0x0000.000.00000000 0x00000001 0x00000000 1358813163 0x0d 10 0x80 0x016f 0x0002 0x0b2c.c02d7b15 0x00800466 0x0000.000.00000000 0x00000001 0x00000000 0 0x0e 9 0x00 0x016f 0x000f 0x0b2c.c02d2ae2 0x00800466 0x0000.000.00000000 0x00000001 0x00000000 1358820065 …………
通过结合dump undo header 中的TRN TBL的state为10的为active事务,然后结合scn/dba等信息,
来确定是哪条记录是需要我们修改.然后通过find命令快速定位到0x0d这条记录,然后进行修改
通过结合bbed的dump命令得出16进制数据分析得出如下结论
--index 0x0c 6e01 0000 64048000 6a1f2dc0 2c0b0000 09 00 2900 0000000000000000 00000000 01000000 ebd7fd50(1358813163注意存储顺序) --index 0x0d 6f01 wrap# 0000 66048000 dba 157b2dc0 2c0b0000 scn 0a state 80 cflags 0200 uel 0000000000000000 parent-xid 00000000 stmt_num 01000000 nub 00000000 cmt --index 0x0e 6f01 0000 66048000 e22a2dc0 2c0b0000 09 00 0f00 0000000000000000 00000000 01000000 e1f2fd50(1358820065)
bbed modify undo segment header(session 2)
BBED> f /x 0a80 File: /u01/oracle/oradata/XFF/undotbs01.dbf (0) Block: 9 Offsets: 6736 to 6751 Dba:0x00000000 ------------------------------------------------------------------------ 0a800200 00000000 00000000 00000000 <32 bytes per line> BBED> m /x 0900 Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y File: /u01/oracle/oradata/XFF/undotbs01.dbf (0) Block: 9 Offsets: 6736 to 6751 Dba:0x00000000 ------------------------------------------------------------------------ 09000200 00000000 00000000 00000000 <32 bytes per line> BBED> sum apply Check value for File 0, Block 9: current = 0xecdd, required = 0xecdd
bbed modify data block itl(session 2)
struct ktbbhitl[0], 24 bytes @44 struct ktbitxid, 8 bytes @44 ub2 kxidusn @44 0x0001 ub2 kxidslt @46 0x000d ub4 kxidsqn @48 0x0000016f struct ktbituba, 8 bytes @52 ub4 kubadba @52 0x00800466 ub2 kubaseq @56 0x016a ub1 kubarec @58 0x20 ub2 ktbitflg @60 0x0009 (NONE) union _ktbitun, 2 bytes @62 b2 _ktbitfsc @62 18 ub2 _ktbitwrp @62 0x0012 ub4 ktbitbas @64 0x00000000 BBED> m /x 0080 offset 60 Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y File: /u01/oracle/oradata/XFF/users01.dbf (0) Block: 28 Offsets: 60 to 571 Dba:0x00000000 ------------------------------------------------------------------------ 00801200 00000000 09002a00 36020000 <32 bytes per line> BBED> sum apply Check value for File 0, Block 28: current = 0xccf1, required = 0xccf1
restart db and select table(session 3)
SQL> shutdown abort ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 306184192 bytes Fixed Size 1267164 bytes Variable Size 109054500 bytes Database Buffers 188743680 bytes Redo Buffers 7118848 bytes Database mounted. Database opened. SQL> col object_name for a20 SQL> set pages 100 SQL> select * from chf.t_xifenfei; OBJECT_ID OBJECT_NAME ---------- -------------------- 20 orasos.com 44 orasos.com 28 orasos.com 15 orasos.com 29 orasos.com 3 orasos.com 25 orasos.com 39 orasos.com 51 orasos.com 26 xifenfei.com 17 xifenfei.com 13 xifenfei.com 9 xifenfei.com 41 xifenfei.com 48 I_CON1 38 I_OBJ3 7 I_TS# 53 I_CDEF4 19 IND$ 19 rows selected.
到此证明,通过修改undo segment header中的state和cflags实现数据库启动不回滚未提交事务;通过修改datablock itl实现数据库在访问未提交数据块时候不访问undo。从而整体上较完美的实现了手工提交一个事务(数据库提交一个事务涉及的方方面面较为复杂,这里只是通过修改最核心的两部分来大致模拟提交事务)
bbed模拟提交事务一之修改itl
我们都知道,根据oracle 事务的一致性,当我们在session 1中进行dml操作,如果未提交在其他会话中是无法看到修改后的值(只能看到修改前的值).这里通过bbed模拟部分提交事务从而实现在其他会话中查看到另外会话未提交事务(本质已经部分模拟提交,还有undo segment header中信息未清理,下篇补充)
create table(session 1)
SQL> create table chf.t_xifenfei 2 as 3 select object_id,object_name from dba_objects where rownum<20; Table created. SQL> select rowid, 2 dbms_rowid.rowid_relative_fno(rowid) rel_fno, 3 dbms_rowid.rowid_block_number(rowid) block_no 4 from chf.t_xifenfei; ROWID REL_FNO BLOCK_NO ------------------ ---------- ---------- AAANL3AAEAAAAAcAAA 4 28 AAANL3AAEAAAAAcAAB 4 28 AAANL3AAEAAAAAcAAC 4 28 AAANL3AAEAAAAAcAAD 4 28 AAANL3AAEAAAAAcAAE 4 28 AAANL3AAEAAAAAcAAF 4 28 AAANL3AAEAAAAAcAAG 4 28 AAANL3AAEAAAAAcAAH 4 28 AAANL3AAEAAAAAcAAI 4 28 AAANL3AAEAAAAAcAAJ 4 28 AAANL3AAEAAAAAcAAK 4 28 AAANL3AAEAAAAAcAAL 4 28 AAANL3AAEAAAAAcAAM 4 28 AAANL3AAEAAAAAcAAN 4 28 AAANL3AAEAAAAAcAAO 4 28 AAANL3AAEAAAAAcAAP 4 28 AAANL3AAEAAAAAcAAQ 4 28 AAANL3AAEAAAAAcAAR 4 28 AAANL3AAEAAAAAcAAS 4 28 19 rows selected. SQL> select * from chf.t_xifenfei; OBJECT_ID OBJECT_NAME ---------- -------------------- 20 ICOL$ 44 I_USER1 28 CON$ 15 UNDO$ 29 C_COBJ# 3 I_OBJ# 25 PROXY_ROLE_DATA$ 39 I_IND1 51 I_CDEF2 26 I_PROXY_ROLE_DATA$_1 17 FILE$ 13 UET$ 9 I_FILE#_BLOCK# 41 I_FILE1 48 I_CON1 38 I_OBJ3 7 I_TS# 53 I_CDEF4 19 IND$ 19 rows selected.
dump block(session 2)
SQL> alter system checkpoint; System altered. SQL> alter system dump datafile 4 block 28; System altered. Itl Xid Uba Flag Lck Scn/Fsc 0x01 0xffff.000.00000000 0x00000000.0000.00 C--- 0 scn 0x0b2c.c02d1987 0x02 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000 0x03 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000
update record(session 1)
SQL> update chf.t_xifenfei set object_name ='www.xifenfei.com' where rownum<15; 14 rows updated. SQL> col object_name for a20 SQL> select * from chf.t_xifenfei; OBJECT_ID OBJECT_NAME ---------- -------------------- 20 www.xifenfei.com 44 www.xifenfei.com 28 www.xifenfei.com 15 www.xifenfei.com 29 www.xifenfei.com 3 www.xifenfei.com 25 www.xifenfei.com 39 www.xifenfei.com 51 www.xifenfei.com 26 www.xifenfei.com 17 www.xifenfei.com 13 www.xifenfei.com 9 www.xifenfei.com 41 www.xifenfei.com 48 I_CON1 38 I_OBJ3 7 I_TS# 53 I_CDEF4 19 IND$ 19 rows selected.
dump block(session 2)
SQL> alter system checkpoint; System altered. --注意flush buffer_cache(不然后面bbed修改会被不能通过select显示,而且会被覆盖) SQL> alter system flush buffer_cache; System altered. SQL> alter system flush shared_pool; System altered. SQL> alter system dump datafile 4 block 28; System altered. Itl Xid Uba Flag Lck Scn/Fsc 0x01 0xffff.000.00000000 0x00000000.0000.00 C--- 0 scn 0x0b2c.c02d1987 0x02 0x000a.00a.0000017e 0x0081ffc7.01a2.22 ---- 14 fsc 0x0000.00000000 <--注意Lck 14 0x03 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000
bbed commit Transaction(session 3)
BBED> p ktbbh struct ktbbh, 96 bytes @20 ub1 ktbbhtyp @20 0x01 (KDDBTDATA) union ktbbhsid, 4 bytes @24 ub4 ktbbhsg1 @24 0x0000d2f7 ub4 ktbbhod1 @24 0x0000d2f7 struct ktbbhcsc, 8 bytes @28 ub4 kscnbas @28 0xc02d1aec ub2 kscnwrp @32 0x0b2c b2 ktbbhict @36 3 ub1 ktbbhflg @38 0x32 (NONE) ub1 ktbbhfsl @39 0x00 ub4 ktbbhfnx @40 0x01000019 struct ktbbhitl[0], 24 bytes @44 struct ktbitxid, 8 bytes @44 ub2 kxidusn @44 0xffff ub2 kxidslt @46 0x0000 ub4 kxidsqn @48 0x00000000 struct ktbituba, 8 bytes @52 ub4 kubadba @52 0x00000000 ub2 kubaseq @56 0x0000 ub1 kubarec @58 0x00 ub2 ktbitflg @60 0x8000 (KTBFCOM) union _ktbitun, 2 bytes @62 b2 _ktbitfsc @62 2860 ub2 _ktbitwrp @62 0x0b2c ub4 ktbitbas @64 0xc02d1987 struct ktbbhitl[1], 24 bytes @68 struct ktbitxid, 8 bytes @68 ub2 kxidusn @68 0x000a ub2 kxidslt @70 0x000a ub4 kxidsqn @72 0x0000017e struct ktbituba, 8 bytes @76 ub4 kubadba @76 0x0081ffc7 ub2 kubaseq @80 0x01a2 ub1 kubarec @82 0x22 ub2 ktbitflg @84 0x000e (NONE) <--修改要改为8000 union _ktbitun, 2 bytes @86 b2 _ktbitfsc @86 0 ub2 _ktbitwrp @86 0x0000 ub4 ktbitbas @88 0x00000000 struct ktbbhitl[2], 24 bytes @92 struct ktbitxid, 8 bytes @92 ub2 kxidusn @92 0x0000 ub2 kxidslt @94 0x0000 ub4 kxidsqn @96 0x00000000 struct ktbituba, 8 bytes @100 ub4 kubadba @100 0x00000000 ub2 kubaseq @104 0x0000 ub1 kubarec @106 0x00 ub2 ktbitflg @108 0x0000 (NONE) union _ktbitun, 2 bytes @110 b2 _ktbitfsc @110 0 ub2 _ktbitwrp @110 0x0000 ub4 ktbitbas @112 0x00000000 BBED> m /x 0080 offset 84 Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y File: /u01/oracle/oradata/XFF/users01.dbf (0) Block: 28 Offsets: 84 to 115 Dba:0x00000000 ------------------------------------------------------------------------ 00800000 00000000 00000000 00000000 <32 bytes per line> BBED> sum apply Check value for File 0, Block 28: current = 0x03dc, required = 0x03dc BBED> p ktbbh struct ktbbh, 96 bytes @20 ………… struct ktbbhitl[1], 24 bytes @68 struct ktbitxid, 8 bytes @68 ub2 kxidusn @68 0x000a ub2 kxidslt @70 0x000a ub4 kxidsqn @72 0x0000017e struct ktbituba, 8 bytes @76 ub4 kubadba @76 0x0081ffc7 ub2 kubaseq @80 0x01a2 ub1 kubarec @82 0x22 ub2 ktbitflg @84 0x8000 (KTBFCOM) <--修改值 union _ktbitun, 2 bytes @86 b2 _ktbitfsc @86 0 ub2 _ktbitwrp @86 0x0000 ub4 ktbitbas @88 0x00000000 …………
dump block(session 2)
SQL> alter system dump datafile 4 block 28; System altered. Itl Xid Uba Flag Lck Scn/Fsc 0x01 0xffff.000.00000000 0x00000000.0000.00 C--- 0 scn 0x0b2c.c02d1987 0x02 0x000a.00a.0000017e 0x0081ffc7.01a2.22 C--- 0 scn 0x0000.00000000 0x03 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000
select data(session 4)
SQL> select object_id,object_name from chf.t_xifenfei; OBJECT_ID OBJECT_NAME ---------- -------------------- 20 www.xifenfei.com 44 www.xifenfei.com 28 www.xifenfei.com 15 www.xifenfei.com 29 www.xifenfei.com 3 www.xifenfei.com 25 www.xifenfei.com 39 www.xifenfei.com 51 www.xifenfei.com 26 www.xifenfei.com 17 www.xifenfei.com 13 www.xifenfei.com 9 www.xifenfei.com 41 www.xifenfei.com 48 I_CON1 38 I_OBJ3 7 I_TS# 53 I_CDEF4 19 IND$ 19 rows selected.
这里可以看到,已经模拟出来在其他session中可以访问数据库为commit的记录(在该block级别已经模拟了commit)