【赛迪网－it技术报道】在我们的实际的工作中,非归档模式下(注:归档模式会导致日志损坏)使用_disable_logging可以禁止日志的生成,在此条件下可以很大的提高某些特殊操作(例如批量加载或者benchmark测试等)的性能。

禁止完成的参考示例:

首先我们需要启动两个session,一个用来管理,一个用来测试。

1.session 1 ,使用sys用户连接数据库,当前_disable_logging没有设置,数据库处于正常的状态。

$ sqlplus "/ as sysdba"

sql*plus: release 9.2.0.4.0 - production on fri apr 14 09:30:42 2006

copyright (c) 1982, 2002, oracle corporation. all rights reserved.

connected to:

oracle9i enterprise edition release 9.2.0.4.0 - 64bit production

with the partitioning option

jserver release 9.2.0.4.0 - production

sql> col member for a40

sql> select * from v$logfile;

group# status type member

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

1 online /opt/oracle9/oradata/testora9/redo01.log

2 online /opt/oracle9/oradata/testora9/redo02.log

3 online /opt/oracle9/oradata/testora9/redo03.log

sql> alter system switch logfile;

system altered.

sql> select * from v$log;

group# thread# sequence# bytes members

arc status first_change# first_tim

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

1 1 148 104857600 1 no current 262708457 14-apr-06

2 1 146 104857600 1 no inactive 262662667 14-apr-06

3 1 147 104857600 1 no active 262675537 14-apr-06

2.session 2则通过scott用户连接,具体执行下面的更新:

sql> connect scott/tiger

connected.

sql> update emp set sal=3000 where empno=7788;

1 row updated.

sql> commit;

commit complete.

3.在session转储redo日志

sql> alter system dump logfile '

/opt/oracle9/oradata/testora9/redo01.log';

system altered.

4.观察跟踪文件,记录正常状态下的redo信息

$ ls

testora9_ora_16037.trc

$ cat *

/opt/oracle9/admin/testora9/udump/testora9_ora_16037.trc

oracle9i enterprise edition release 9.2.0.4.0 - 64bit production

with the partitioning option

jserver release 9.2.0.4.0 - production

oracle_home = /opt/oracle9/product/9.2.0

system name: sunos

node name: testdbserver.hurray.com.cn

release: 5.8

version: generic_108528-25

machine: sun4u

instance name: testora9

redo thread mounted by this instance: 1

oracle process number: 15

unix process pid: 16037, image: oracle@testdbserver.hurray.com.cn (tns v1-v3)

*** 2006-04-14 09:32:01.356

*** session id:(17.3524) 2006-04-14 09:32:01.340

dump of redo from file '/opt/oracle9/oradata/testora9/redo01.log'

opcodes *.*

dba's: (file # 0, block # 0) thru (file # 65534, block # 4194303)

rba's: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff

scn's scn: 0x0000.00000000 thru scn: 0xffff.ffffffff

times: creation thru eternity

file header:

software vsn=153092096=0x9200000, compatibility vsn=153092096=0x9200000

db id=1628068176=0x610a5950, db name='testora9'

activation id=1628067152=0x610a5550

control seq=1161=0x489, file size=204800=0x32000

file number=1, blksiz=512, file type=2 log

descrip:"thread 0001, seq# 0000000148, scn 0x00000fa89ce9-0xffffffffffff"

thread: 1 nab: 0xffffffff seq: 0x00000094 hws: 0x1 eot: 1 dis: 0

reset logs count: 0x1f435110 scn: 0x0000.00000001

low scn: 0x0000.0fa89ce9 04/14/2006 09:31:06

next scn: 0xffff.ffffffff 01/01/1988 00:00:00

enabled scn: 0x0000.00000001 04/26/2004 15:56:10

thread closed scn: 0x0000.0fa89ce9 04/14/2006 09:31:06

log format vsn: 0x8000000 disk cksum: 0x9930 calc cksum: 0x9930

terminal recovery stamp scn: 0x0000.00000000 01/01/1988 00:00:00

most recent redo scn: 0x0000.00000000

largest lwn: 0 blocks

end-of-redo stream : no

unprotected mode

miscellaneous flags: 0x0

redo record - thread:1 rba: 0x000094.00000002.0010 len: 0x01b0 vld: 0x01

scn: 0x0000.0fa89cf0 subscn: 1 04/14/2006 09:31:30

change #1 typ:0 cls:33 afn:2 dba:0x00800089 scn:0x0000.0fa89cca seq: 1 op:5.2

ktudh redo: slt: 0x000f sqn: 0x00009c89 flg: 0x000a siz: 132 fbi: 0

uba: 0x00800559.0352.01 pxid: 0x0000.000.00000000

change #2 typ:1 cls:34 afn:2 dba:0x00800559 scn:0x0000.0fa89cf0 seq: 1 op:5.1

ktudb redo: siz: 132 spc: 0 flg: 0x000a seq: 0x0352 rec: 0x01

xid: 0x0009.00f.00009c89

ktubl redo: slt: 15 rci: 0 opc: 11.1 objn: 30359 objd: 30359 tsn: 0

undo type: regular undo begin trans last buffer split: no

temp object: no

tablespace undo: no

0x00000000 prev ctl uba: 0x00800558.0352.57

prev ctl max cmt scn: 0x0000.0fa89887 prev tx cmt scn: 0x0000.0fa8988b

kdo undo record:

ktb redo

op: 0x04 ver: 0x01

op: l itl: xid: 0x0005.01e.00009810 uba: 0x00800615.032f.26

flg: c--- lkc: 0 scn: 0x0000.0f92af59

kdo op code: urp row dependencies disabled

xtype: xa bdba: 0x0040a482 hdba: 0x0040a481

itli: 1 ispac: 0 maxfr: 4863

tabn: 0 slot: 7(0x7) flag: 0x2c lock: 0 ckix: 0

ncol: 8 nnew: 1 size: 0

col 5: [ 2] c2 29

change #3 typ:2 cls: 1 afn:1 dba:0x0040a482 scn:0x0000.0f92ced1 seq: 1 op:11.5

ktb redo

op: 0x11 ver: 0x01

op: f xid: 0x0009.00f.00009c89 uba: 0x00800559.0352.01

block cleanout record, scn: 0x0000.0fa89cf0 ver: 0x01 opt: 0x02, entries follow...

itli: 2 flg: 2 scn: 0x0000.0f92ced1

kdo op code: urp row dependencies disabled

xtype: xa bdba: 0x0040a482 hdba: 0x0040a481

itli: 1 ispac: 0 maxfr: 4863

tabn: 0 slot: 7(0x7) flag: 0x2c lock: 1 ckix: 0

ncol: 8 nnew: 1 size: 0

col 5: [ 2] c2 1f

change #4 media recovery marker scn:0x0000.00000000 seq: 0 op:5.20

session number = 16

serial number = 651

transaction name =

redo record - thread:1 rba: 0x000094.00000002.01c0 len: 0x0054 vld: 0x01

scn: 0x0000.0fa89cf1 subscn: 1 04/14/2006 09:31:30

change #1 typ:0 cls:33 afn:2 dba:0x00800089 scn:0x0000.0fa89cf0 seq: 1 op:5.4

ktucm redo: slt: 0x000f sqn: 0x00009c89 srt: 0 sta: 9 flg: 0x2

ktucf redo: uba: 0x00800559.0352.01 ext: 2 spc: 8016 fbi: 0

redo record - thread:1 rba: 0x000094.00000004.0010 len: 0x01f4 vld: 0x01

scn: 0x0000.0fa89cf2 subscn: 1 04/14/2006 09:31:31

change #1 typ:0 cls:21 afn:2 dba:0x00800029 scn:0x0000.0fa89ccc seq: 1 op:5.2

ktudh redo: slt: 0x001b sqn: 0x00009c9b flg: 0x0012 siz: 108 fbi: 0

uba: 0x0080046b.0345.40 pxid: 0x0000.000.00000000

change #2 typ:0 cls:22 afn:2 dba:0x0080046b scn:0x0000.0fa89ccb seq: 1 op:5.1

ktudb redo: siz: 108 spc: 2908 flg: 0x0012 seq: 0x0345 rec: 0x40

xid: 0x0003.01b.00009c9b

ktubl redo: slt: 27 rci: 0 opc: 11.1 objn: 3643 objd: 3643 tsn: 0

undo type: regular undo begin trans last buffer split: no

temp object: no

tablespace undo: no

0x00000000 prev ctl uba: 0x0080046b.0345.3f

prev ctl max cmt scn: 0x0000.0fa89888 prev tx cmt scn: 0x0000.0fa8988d

kdo undo record:

ktb redo

op: 0x04 ver: 0x01

op: l itl: xid: 0x0002.021.0000a088 uba: 0x0080091e.0714.47

flg: c--- lkc: 0 scn: 0x0000.0fa89ce0

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f7a hdba: 0x00401f79

itli: 1 ispac: 0 maxfr: 4863

tabn: 0 slot: 0 to: 0

change #3 typ:2 cls: 1 afn:1 dba:0x00401f7a scn:0x0000.0fa89ce3 seq: 1 op:11.4

ktb redo

op: 0x11 ver: 0x01

op: f xid: 0x0003.01b.00009c9b uba: 0x0080046b.0345.40

block cleanout record, scn: 0x0000.0fa89cf2 ver: 0x01 opt: 0x02, entries follow...

itli: 1 flg: 2 scn: 0x0000.0fa89ce0

itli: 2 flg: 2 scn: 0x0000.0fa89ce3

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f7a hdba: 0x00401f79

itli: 1 ispac: 0 maxfr: 4863

tabn: 0 slot: 0 to: 1

change #4 media recovery marker scn:0x0000.00000000 seq: 0 op:5.19

session number = 8

serial number = 1

current username = sys

login username =

client info =

os username = oracle9

machine name = testdbserver.hurray.com.cn

os terminal = unknown

os process id = 2053

os program name = oracle@testdbserver.hurray.com.cn (qmn0)

transaction name =

redo record - thread:1 rba: 0x000094.00000005.0014 len: 0x00dc vld: 0x01

scn: 0x0000.0fa89cf2 subscn: 1 04/14/2006 09:31:31

change #1 typ:0 cls:22 afn:2 dba:0x0080046b scn:0x0000.0fa89cf2 seq: 1 op:5.1

ktudb redo: siz: 84 spc: 2798 flg: 0x0022 seq: 0x0345 rec: 0x41

xid: 0x0003.01b.00009c9b

ktubu redo: slt: 27 rci: 64 opc: 11.1 objn: 3635 objd: 3635 tsn: 0

undo type: regular undo undo type: last buffer split: no

tablespace undo: no

0x00000000

kdo undo record:

ktb redo

op: 0x04 ver: 0x01

op: l itl: xid: 0x0008.01b.00009c85 uba: 0x008007a3.037e.0b

flg: c--- lkc: 0 scn: 0x0000.0fa89ce3

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f3a hdba: 0x00401f39

itli: 1 ispac: 0 maxfr: 4863

tabn: 0 slot: 0 to: 0

change #2 typ:2 cls: 1 afn:1 dba:0x00401f3a scn:0x0000.0fa89ce5 seq: 1 op:11.4

ktb redo

op: 0x01 ver: 0x01

op: f xid: 0x0003.01b.00009c9b uba: 0x0080046b.0345.41

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f3a hdba: 0x00401f39

itli: 1 ispac: 0 maxfr: 4863

tabn: 0 slot: 0 to: 1

redo record - thread:1 rba: 0x000094.00000005.00f0 len: 0x0054 vld: 0x01

scn: 0x0000.0fa89cf3 subscn: 1 04/14/2006 09:31:31

change #1 typ:0 cls:21 afn:2 dba:0x00800029 scn:0x0000.0fa89cf2 seq: 1 op:5.4

ktucm redo: slt: 0x001b sqn: 0x00009c9b srt: 0 sta: 9 flg: 0x2

ktucf redo: uba: 0x0080046b.0345.41 ext: 2 spc: 2712 fbi: 0

redo record - thread:1 rba: 0x000094.00000006.0010 len: 0x0188 vld: 0x01

scn: 0x0000.0fa89cf5 subscn: 1 04/14/2006 09:31:31

change #1 typ:0 cls:27 afn:2 dba:0x00800059 scn:0x0000.0fa89ccd seq: 1 op:5.2

ktudh redo: slt: 0x0020 sqn: 0x00009c72 flg: 0x0012 siz: 108 fbi: 0

uba: 0x0080027b.0352.1d pxid: 0x0000.000.00000000

change #2 typ:0 cls:28 afn:2 dba:0x0080027b scn:0x0000.0fa89ccc seq: 1 op:5.1

ktudb redo: siz: 108 spc: 5718 flg: 0x0012 seq: 0x0352 rec: 0x1d

xid: 0x0006.020.00009c72

ktubl redo: slt: 32 rci: 0 opc: 11.1 objn: 3635 objd: 3635 tsn: 0

undo type: regular undo begin trans last buffer split: no

temp object: no

tablespace undo: no

0x00000000 prev ctl uba: 0x0080027b.0352.1c

prev ctl max cmt scn: 0x0000.0fa8988a prev tx cmt scn: 0x0000.0fa8988e

kdo undo record:

ktb redo

op: 0x04 ver: 0x01

op: l itl: xid: 0x0002.01a.0000a089 uba: 0x0080091e.0714.49

flg: c--- lkc: 0 scn: 0x0000.0fa89ce5

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f3a hdba: 0x00401f39

itli: 2 ispac: 0 maxfr: 4863

tabn: 0 slot: 0 to: 0

change #3 typ:2 cls: 1 afn:1 dba:0x00401f3a scn:0x0000.0fa89cf3 seq: 1 op:11.4

ktb redo

op: 0x11 ver: 0x01

op: f xid: 0x0006.020.00009c72 uba: 0x0080027b.0352.1d

block cleanout record, scn: 0x0000.0fa89cf5 ver: 0x01 opt: 0x02, entries follow...

itli: 1 flg: 2 scn: 0x0000.0fa89cf3

itli: 2 flg: 2 scn: 0x0000.0fa89ce5

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f3a hdba: 0x00401f39

itli: 2 ispac: 0 maxfr: 4863

tabn: 0 slot: 0 to: 2

change #4 media recovery marker scn:0x0000.00000000 seq: 0 op:5.20

session number = 8

serial number = 1

transaction name =

redo record - thread:1 rba: 0x000094.00000006.0198 len: 0x0054 vld: 0x01

scn: 0x0000.0fa89cf6 subscn: 1 04/14/2006 09:31:31

change #1 typ:0 cls:27 afn:2 dba:0x00800059 scn:0x0000.0fa89cf5 seq: 1 op:5.4

ktucm redo: slt: 0x0020 sqn: 0x00009c72 srt: 0 sta: 9 flg: 0x2

ktucf redo: uba: 0x0080027b.0352.1d ext: 2 spc: 5608 fbi: 0

redo record - thread:1 rba: 0x000094.00000007.0010 len: 0x00d4 vld: 0x01

scn: 0x0000.0fa89cf7 subscn: 1 04/14/2006 09:31:31

change #1 typ:0 cls:33 afn:2 dba:0x00800089 scn:0x0000.0fa89cf1 seq: 1 op:5.2

ktudh redo: slt: 0x0027 sqn: 0x00009c88 flg: 0x0011 siz: 52 fbi: 0

uba: 0x00800559.0352.02 pxid: 0x0000.000.00000000

change #2 typ:0 cls:34 afn:2 dba:0x00800559 scn:0x0000.0fa89cf0 seq: 2 op:5.1

ktudb redo: siz: 52 spc: 8016 flg: 0x0012 seq: 0x0352 rec: 0x02

xid: 0x0009.027.00009c88

ktubl redo: slt: 39 rci: 0 opc: 5.7 objn: 0 objd: 0 tsn: 0

undo type: regular undo begin trans last buffer split: no

temp object: no

tablespace undo: no

0x00000000 prev ctl uba: 0x00800559.0352.01

prev ctl max cmt scn: 0x0000.0fa8988b prev tx cmt scn: 0x0000.0fa89894

change #3 media recovery marker scn:0x0000.00000000 seq: 0 op:5.20

session number = 8

serial number = 1

transaction name =

redo record - thread:1 rba: 0x000094.00000007.00e4 len: 0x0118 vld: 0x01

scn: 0x0000.0fa89cf8 subscn: 1 04/14/2006 09:31:31

change #1 typ:0 cls:33 afn:2 dba:0x00800089 scn:0x0000.0fa89cf7 seq: 1 op:5.2

ktudh redo: slt: 0x0027 sqn: 0x00000000 flg: 0x0002 siz: 84 fbi: 0

uba: 0x00800559.0352.03 pxid: 0x0000.000.00000000

change #2 typ:0 cls:34 afn:2 dba:0x00800559 scn:0x0000.0fa89cf7 seq: 1 op:5.1

ktudb redo: siz: 84 spc: 7962 flg: 0x0022 seq: 0x0352 rec: 0x03

xid: 0x0009.027.00009c88

ktubu redo: slt: 39 rci: 0 opc: 11.1 objn: 3643 objd: 3643 tsn: 0

undo type: regular undo undo type: last buffer split: no

tablespace undo: no

0x00000000

kdo undo record:

ktb redo

op: 0x04 ver: 0x01

op: l itl: xid: 0x0008.01b.00009c85 uba: 0x008007a3.037e.0a

flg: c--- lkc: 0 scn: 0x0000.0fa89ce3

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f7a hdba: 0x00401f79

itli: 2 ispac: 0 maxfr: 4863

tabn: 0 slot: 1 to: 0

change #3 typ:2 cls: 1 afn:1 dba:0x00401f7a scn:0x0000.0fa89cf3 seq: 1 op:11.4

ktb redo

op: 0x01 ver: 0x01

op: f xid: 0x0009.027.00009c88 uba: 0x00800559.0352.03

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f7a hdba: 0x00401f79

itli: 2 ispac: 0 maxfr: 4863

tabn: 0 slot: 1 to: 2

redo record - thread:1 rba: 0x000094.00000008.0010 len: 0x00dc vld: 0x01

scn: 0x0000.0fa89cf8 subscn: 1 04/14/2006 09:31:31

change #1 typ:0 cls:34 afn:2 dba:0x00800559 scn:0x0000.0fa89cf8 seq: 1 op:5.1

ktudb redo: siz: 84 spc: 7876 flg: 0x0022 seq: 0x0352 rec: 0x04

xid: 0x0009.027.00009c88

ktubu redo: slt: 39 rci: 3 opc: 11.1 objn: 3635 objd: 3635 tsn: 0

undo type: regular undo undo type: last buffer split: no

tablespace undo: no

0x00000000

kdo undo record:

ktb redo

op: 0x04 ver: 0x01

op: l itl: xid: 0x0003.01b.00009c9b uba: 0x0080046b.0345.41

flg: c--- lkc: 0 scn: 0x0000.0fa89cf3

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f3a hdba: 0x00401f39

itli: 1 ispac: 0 maxfr: 4863

tabn: 0 slot: 1 to: 0

change #2 typ:2 cls: 1 afn:1 dba:0x00401f3a scn:0x0000.0fa89cf6 seq: 1 op:11.4

ktb redo

op: 0x01 ver: 0x01

op: f xid: 0x0009.027.00009c88 uba: 0x00800559.0352.04

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f3a hdba: 0x00401f39

itli: 1 ispac: 0 maxfr: 4863

tabn: 0 slot: 1 to: 1

redo record - thread:1 rba: 0x000094.00000008.00ec len: 0x0054 vld: 0x01

scn: 0x0000.0fa89cf9 subscn: 1 04/14/2006 09:31:31

change #1 typ:0 cls:33 afn:2 dba:0x00800089 scn:0x0000.0fa89cf8 seq: 1 op:5.4

ktucm redo: slt: 0x0027 sqn: 0x00009c88 srt: 0 sta: 9 flg: 0x2

ktucf redo: uba: 0x00800559.0352.04 ext: 2 spc: 7790 fbi: 0

redo record - thread:1 rba: 0x000094.00000008.0140 len: 0x0188 vld: 0x01

scn: 0x0000.0fa89cfa subscn: 1 04/14/2006 09:31:31

change #1 typ:0 cls:21 afn:2 dba:0x00800029 scn:0x0000.0fa89cf3 seq: 1 op:5.2

ktudh redo: slt: 0x001a sqn: 0x00009c9b flg: 0x0012 siz: 108 fbi: 0

uba: 0x0080046b.0345.42 pxid: 0x0000.000.00000000

change #2 typ:0 cls:22 afn:2 dba:0x0080046b scn:0x0000.0fa89cf2 seq: 2 op:5.1

ktudb redo: siz: 108 spc: 2712 flg: 0x0012 seq: 0x0345 rec: 0x42

xid: 0x0003.01a.00009c9b

ktubl redo: slt: 26 rci: 0 opc: 11.1 objn: 3635 objd: 3635 tsn: 0

undo type: regular undo begin trans last buffer split: no

temp object: no

tablespace undo: no

0x00000000 prev ctl uba: 0x0080046b.0345.40

prev ctl max cmt scn: 0x0000.0fa8988d prev tx cmt scn: 0x0000.0fa898e6

kdo undo record:

ktb redo

op: 0x04 ver: 0x01

op: l itl: xid: 0x0006.020.00009c72 uba: 0x0080027b.0352.1d

flg: c--- lkc: 0 scn: 0x0000.0fa89cf6

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f3a hdba: 0x00401f39

itli: 2 ispac: 0 maxfr: 4863

tabn: 0 slot: 1 to: 0

change #3 typ:2 cls: 1 afn:1 dba:0x00401f3a scn:0x0000.0fa89cf9 seq: 1 op:11.4

ktb redo

op: 0x11 ver: 0x01

op: f xid: 0x0003.01a.00009c9b uba: 0x0080046b.0345.42

block cleanout record, scn: 0x0000.0fa89cfa ver: 0x01 opt: 0x02, entries follow...

itli: 1 flg: 2 scn: 0x0000.0fa89cf9

itli: 2 flg: 2 scn: 0x0000.0fa89cf6

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f3a hdba: 0x00401f39

itli: 2 ispac: 0 maxfr: 4863

tabn: 0 slot: 1 to: 2

change #4 media recovery marker scn:0x0000.00000000 seq: 0 op:5.20

session number = 8

serial number = 1

transaction name =

redo record - thread:1 rba: 0x000094.00000009.00d8 len: 0x0054 vld: 0x01

scn: 0x0000.0fa89cfb subscn: 1 04/14/2006 09:31:31

change #1 typ:0 cls:21 afn:2 dba:0x00800029 scn:0x0000.0fa89cfa seq: 1 op:5.4

ktucm redo: slt: 0x001a sqn: 0x00009c9b srt: 0 sta: 9 flg: 0x2

ktucf redo: uba: 0x0080046b.0345.42 ext: 2 spc: 2602 fbi: 0

redo record - thread:1 rba: 0x000094.00000009.012c len: 0x00d4 vld: 0x01

scn: 0x0000.0fa89cfb subscn: 1 04/14/2006 09:31:31

change #1 typ:0 cls:27 afn:2 dba:0x00800059 scn:0x0000.0fa89cf6 seq: 1 op:5.2

ktudh redo: slt: 0x000c sqn: 0x00009c72 flg: 0x0011 siz: 52 fbi: 0

uba: 0x0080027b.0352.1e pxid: 0x0000.000.00000000

change #2 typ:0 cls:28 afn:2 dba:0x0080027b scn:0x0000.0fa89cf5 seq: 1 op:5.1

ktudb redo: siz: 52 spc: 5608 flg: 0x0012 seq: 0x0352 rec: 0x1e

xid: 0x0006.00c.00009c72

ktubl redo: slt: 12 rci: 0 opc: 5.7 objn: 0 objd: 0 tsn: 0

undo type: regular undo begin trans last buffer split: no

temp object: no

tablespace undo: no

0x00000000 prev ctl uba: 0x0080027b.0352.1d

prev ctl max cmt scn: 0x0000.0fa8988e prev tx cmt scn: 0x0000.0fa89902

change #3 media recovery marker scn:0x0000.00000000 seq: 0 op:5.20

session number = 8

serial number = 1

transaction name =

redo record - thread:1 rba: 0x000094.0000000a.0010 len: 0x0148 vld: 0x01

scn: 0x0000.0fa89cfb subscn: 1 04/14/2006 09:31:31

change #1 typ:0 cls:27 afn:2 dba:0x00800059 scn:0x0000.0fa89cfb seq: 1 op:5.2

ktudh redo: slt: 0x000c sqn: 0x00000000 flg: 0x0002 siz: 84 fbi: 0

uba: 0x0080027b.0352.1f pxid: 0x0000.000.00000000

change #2 typ:0 cls:28 afn:2 dba:0x0080027b scn:0x0000.0fa89cfb seq: 1 op:5.1

ktudb redo: siz: 84 spc: 5554 flg: 0x0022 seq: 0x0352 rec: 0x1f

xid: 0x0006.00c.00009c72

ktubu redo: slt: 12 rci: 0 opc: 11.1 objn: 3643 objd: 3643 tsn: 0

undo type: regular undo undo type: last buffer split: no

tablespace undo: no

0x00000000

kdo undo record:

ktb redo

op: 0x04 ver: 0x01

op: l itl: xid: 0x0003.01b.00009c9b uba: 0x0080046b.0345.40

flg: c--- lkc: 0 scn: 0x0000.0fa89cf3

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f7a hdba: 0x00401f79

itli: 1 ispac: 0 maxfr: 4863

tabn: 0 slot: 2 to: 0

change #3 typ:2 cls: 1 afn:1 dba:0x00401f7a scn:0x0000.0fa89cf9 seq: 1 op:11.4

ktb redo

op: 0x11 ver: 0x01

op: f xid: 0x0006.00c.00009c72 uba: 0x0080027b.0352.1f

block cleanout record, scn: 0x0000.0fa89cfb ver: 0x01 opt: 0x02, entries follow...

itli: 1 flg: 2 scn: 0x0000.0fa89cf3

itli: 2 flg: 2 scn: 0x0000.0fa89cf9

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f7a hdba: 0x00401f79

itli: 1 ispac: 0 maxfr: 4863

tabn: 0 slot: 2 to: 1

redo record - thread:1 rba: 0x000094.0000000a.0158 len: 0x00dc vld: 0x01

scn: 0x0000.0fa89cfb subscn: 1 04/14/2006 09:31:31

change #1 typ:0 cls:28 afn:2 dba:0x0080027b scn:0x0000.0fa89cfb seq: 2 op:5.1

ktudb redo: siz: 84 spc: 5468 flg: 0x0022 seq: 0x0352 rec: 0x20

xid: 0x0006.00c.00009c72

ktubu redo: slt: 12 rci: 31 opc: 11.1 objn: 3635 objd: 3635 tsn: 0

undo type: regular undo undo type: last buffer split: no

tablespace undo: no

0x00000000

kdo undo record:

ktb redo

op: 0x04 ver: 0x01

op: l itl: xid: 0x0009.027.00009c88 uba: 0x00800559.0352.04

flg: c--- lkc: 0 scn: 0x0000.0fa89cf9

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f3a hdba: 0x00401f39

itli: 1 ispac: 0 maxfr: 4863

tabn: 0 slot: 2 to: 0

change #2 typ:2 cls: 1 afn:1 dba:0x00401f3a scn:0x0000.0fa89cfb seq: 1 op:11.4

ktb redo

op: 0x01 ver: 0x01

op: f xid: 0x0006.00c.00009c72 uba: 0x0080027b.0352.20

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f3a hdba: 0x00401f39

itli: 1 ispac: 0 maxfr: 4863

tabn: 0 slot: 2 to: 1

redo record - thread:1 rba: 0x000094.0000000b.0044 len: 0x0054 vld: 0x01

scn: 0x0000.0fa89cfc subscn: 1 04/14/2006 09:31:31

change #1 typ:0 cls:27 afn:2 dba:0x00800059 scn:0x0000.0fa89cfb seq: 2 op:5.4

ktucm redo: slt: 0x000c sqn: 0x00009c72 srt: 0 sta: 9 flg: 0x2

ktucf redo: uba: 0x0080027b.0352.20 ext: 2 spc: 5382 fbi: 0

redo record - thread:1 rba: 0x000094.0000000b.0098 len: 0x0188 vld: 0x01

scn: 0x0000.0fa89cfd subscn: 1 04/14/2006 09:31:31

change #1 typ:0 cls:33 afn:2 dba:0x00800089 scn:0x0000.0fa89cf9 seq: 1 op:5.2

ktudh redo: slt: 0x000d sqn: 0x00009c89 flg: 0x0012 siz: 108 fbi: 0

uba: 0x00800559.0352.05 pxid: 0x0000.000.00000000

change #2 typ:0 cls:34 afn:2 dba:0x00800559 scn:0x0000.0fa89cf8 seq: 2 op:5.1

ktudb redo: siz: 108 spc: 7790 flg: 0x0012 seq: 0x0352 rec: 0x05

xid: 0x0009.00d.00009c89

ktubl redo: slt: 13 rci: 0 opc: 11.1 objn: 3635 objd: 3635 tsn: 0

undo type: regular undo begin trans last buffer split: no

temp object: no

tablespace undo: no

0x00000000 prev ctl uba: 0x00800559.0352.02

prev ctl max cmt scn: 0x0000.0fa89894 prev tx cmt scn: 0x0000.0fa89905

kdo undo record:

ktb redo

op: 0x04 ver: 0x01

op: l itl: xid: 0x0003.01a.00009c9b uba: 0x0080046b.0345.42

flg: c--- lkc: 0 scn: 0x0000.0fa89cfb

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f3a hdba: 0x00401f39

itli: 2 ispac: 0 maxfr: 4863

tabn: 0 slot: 2 to: 0

change #3 typ:2 cls: 1 afn:1 dba:0x00401f3a scn:0x0000.0fa89cfc seq: 1 op:11.4

ktb redo

op: 0x11 ver: 0x01

op: f xid: 0x0009.00d.00009c89 uba: 0x00800559.0352.05

block cleanout record, scn: 0x0000.0fa89cfd ver: 0x01 opt: 0x02, entries follow...

itli: 1 flg: 2 scn: 0x0000.0fa89cfc

itli: 2 flg: 2 scn: 0x0000.0fa89cfb

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f3a hdba: 0x00401f39

itli: 2 ispac: 0 maxfr: 4863

tabn: 0 slot: 2 to: 2

change #4 media recovery marker scn:0x0000.00000000 seq: 0 op:5.20

session number = 8

serial number = 1

transaction name =

redo record - thread:1 rba: 0x000094.0000000c.0030 len: 0x0054 vld: 0x01

scn: 0x0000.0fa89cfe subscn: 1 04/14/2006 09:31:31

change #1 typ:0 cls:33 afn:2 dba:0x00800089 scn:0x0000.0fa89cfd seq: 1 op:5.4

ktucm redo: slt: 0x000d sqn: 0x00009c89 srt: 0 sta: 9 flg: 0x2

ktucf redo: uba: 0x00800559.0352.05 ext: 2 spc: 7680 fbi: 0

redo record - thread:1 rba: 0x000094.0000000d.0010 len: 0x00d4 vld: 0x01

scn: 0x0000.0fa89cff subscn: 1 04/14/2006 09:31:37

change #1 typ:0 cls:21 afn:2 dba:0x00800029 scn:0x0000.0fa89cfb seq: 1 op:5.2

ktudh redo: slt: 0x0017 sqn: 0x00009c9c flg: 0x0011 siz: 52 fbi: 0

uba: 0x0080046b.0345.43 pxid: 0x0000.000.00000000

change #2 typ:0 cls:22 afn:2 dba:0x0080046b scn:0x0000.0fa89cfa seq: 1 op:5.1

ktudb redo: siz: 52 spc: 2602 flg: 0x0012 seq: 0x0345 rec: 0x43

xid: 0x0003.017.00009c9c

ktubl redo: slt: 23 rci: 0 opc: 5.7 objn: 0 objd: 0 tsn: 0

undo type: regular undo begin trans last buffer split: no

temp object: no

tablespace undo: no

0x00000000 prev ctl uba: 0x0080046b.0345.42

prev ctl max cmt scn: 0x0000.0fa898e6 prev tx cmt scn: 0x0000.0fa89907

change #3 media recovery marker scn:0x0000.00000000 seq: 0 op:5.20

session number = 8

serial number = 1

transaction name =

redo record - thread:1 rba: 0x000094.0000000d.00e4 len: 0x0118 vld: 0x01

scn: 0x0000.0fa89cff subscn: 1 04/14/2006 09:31:37

change #1 typ:0 cls:21 afn:2 dba:0x00800029 scn:0x0000.0fa89cff seq: 1 op:5.2

ktudh redo: slt: 0x0017 sqn: 0x00000000 flg: 0x0002 siz: 84 fbi: 0

uba: 0x0080046b.0345.44 pxid: 0x0000.000.00000000

change #2 typ:0 cls:22 afn:2 dba:0x0080046b scn:0x0000.0fa89cff seq: 1 op:5.1

ktudb redo: siz: 84 spc: 2548 flg: 0x0022 seq: 0x0345 rec: 0x44

xid: 0x0003.017.00009c9c

ktubu redo: slt: 23 rci: 0 opc: 11.1 objn: 3643 objd: 3643 tsn: 0

undo type: regular undo undo type: last buffer split: no

tablespace undo: no

0x00000000

kdo undo record:

ktb redo

op: 0x04 ver: 0x01

op: l itl: xid: 0x0009.027.00009c88 uba: 0x00800559.0352.03

flg: c--- lkc: 0 scn: 0x0000.0fa89cf9

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f7a hdba: 0x00401f79

itli: 2 ispac: 0 maxfr: 4863

tabn: 0 slot: 3 to: 0

change #3 typ:2 cls: 1 afn:

1 dba:0x00401f7a scn:0x0000.0fa89cfc seq: 1 op:11.4

ktb redo

op: 0x01 ver: 0x01

op: f xid: 0x0003.017.00009c9c uba: 0x0080046b.0345.44

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f7a hdba: 0x00401f79

itli: 2 ispac: 0 maxfr: 4863

tabn: 0 slot: 3 to: 2

redo record - thread:1 rba:

0x000094.0000000e.0010 len: 0x00dc vld: 0x01

scn: 0x0000.0fa89cff subscn: 1 04/14/2006 09:31:37

change #1 typ:0 cls:22 afn:

2 dba:0x0080046b scn:0x0000.0fa89cff seq: 2 op:5.1

ktudb redo: siz: 84 spc: 2462 flg: 0x0022 seq: 0x0345 rec: 0x45

xid: 0x0003.017.00009c9c

ktubu redo: slt: 23 rci: 68 opc: 11.1 objn: 3635 objd: 3635 tsn: 0

undo type: regular undo undo type: last buffer split: no

tablespace undo: no

0x00000000

kdo undo record:

ktb redo

op: 0x04 ver: 0x01

op: l itl: xid: 0x0006.00c.00009c72 uba: 0x0080027b.0352.20

flg: c--- lkc: 0 scn: 0x0000.0fa89cfc

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f3a hdba: 0x00401f39

itli: 1 ispac: 0 maxfr: 4863

tabn: 0 slot: 3 to: 0

change #2 typ:2 cls: 1 afn:

1 dba:0x00401f3a scn:0x0000.0fa89cfe seq: 1 op:11.4

ktb redo

op: 0x01 ver: 0x01

op: f xid: 0x0003.017.00009c9c uba: 0x0080046b.0345.45

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f3a hdba: 0x00401f39

itli: 1 ispac: 0 maxfr: 4863

tabn: 0 slot: 3 to: 1

redo record - thread:1 rba:

0x000094.0000000e.00ec len: 0x0054 vld: 0x01

scn: 0x0000.0fa89d00 subscn: 1 04/14/2006 09:31:37

change #1 typ:0 cls:21 afn:2 dba:0x00800029 scn:0x0000.0fa89cff seq: 2 op:5.4

ktucm redo: slt: 0x0017 sqn: 0x00009c9c srt: 0 sta: 9 flg: 0x2

ktucf redo: uba: 0x0080046b.0345.45 ext: 2 spc: 2376 fbi: 0

redo record - thread:1 rba:

0x000094.0000000e.0140 len: 0x0188 vld: 0x01

scn: 0x0000.0fa89d01 subscn: 1 04/14/2006 09:31:37

change #1 typ:0 cls:27 afn:2 dba:0x00800059 scn:0x0000.0fa89cfc seq: 1 op:5.2

ktudh redo: slt: 0x001f sqn: 0x00009c72 flg: 0x0012 siz: 108 fbi: 0

uba: 0x0080027b.0352.21 pxid: 0x0000.000.00000000

change #2 typ:0 cls:28 afn:2 dba:0x0080027b scn:0x0000.0fa89cfb seq: 3 op:5.1

ktudb redo: siz: 108 spc: 5382 flg: 0x0012 seq: 0x0352 rec: 0x21

xid: 0x0006.01f.00009c72

ktubl redo: slt: 31 rci: 0 opc: 11.1 objn: 3635 objd: 3635 tsn: 0

undo type: regular undo begin trans last buffer split: no

temp object: no

tablespace undo: no

0x00000000 prev ctl uba:

0x0080027b.0352.1e

prev ctl max cmt scn:

0x0000.0fa89902 prev tx cmt scn: 0x0000.0fa89908

kdo undo record:

ktb redo

op: 0x04 ver: 0x01

op: l itl: xid:

0x0009.00d.00009c89 uba: 0x00800559.0352.05

flg: c--- lkc: 0 scn: 0x0000.0fa89cfe

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f3a hdba: 0x00401f39

itli: 2 ispac: 0 maxfr: 4863

tabn: 0 slot: 3 to: 0

change #3 typ:2 cls: 1 afn:

1 dba:0x00401f3a scn:0x0000.0fa89d00 seq: 1 op:11.4

ktb redo

op: 0x11 ver: 0x01

op: f xid: 0x0006.01f.00009c72 uba: 0x0080027b.0352.21

block cleanout record, scn: 0x0000.0fa89d01 ver: 0x01 opt: 0x02, entries follow...

itli: 1 flg: 2 scn: 0x0000.0fa89d00

itli: 2 flg: 2 scn: 0x0000.0fa89cfe

kdo op code: lkr row dependencies disabled

xtype: xa bdba: 0x00401f3a hdba: 0x00401f39

itli: 2 ispac: 0 maxfr: 4863

tabn: 0 slot: 3 to: 2

change #4 media recovery marker scn:0x0000.00000000 seq: 0 op:5.20

session number = 8

serial number = 1

transaction name =

redo record - thread:1 rba:

0x000094.0000000f.00d8 len: 0x0054 vld: 0x01

scn: 0x0000.0fa89d02 subscn:

1 04/14/2006 09:31:37

change #1 typ:0 cls:27 afn:

2 dba:0x00800059 scn:0x0000.0fa89d01 seq: 1 op:5.4

ktucm redo: slt: 0x001f sqn:

0x00009c72 srt: 0 sta: 9 flg: 0x2

ktucf redo: uba: 0x0080027b.0352.21 ext: 2 spc: 5272 fbi: 0

redo record - thread:

1 rba: 0x000094.0000000f.012c len: 0x00d4 vld: 0x01

scn: 0x0000.0fa89d02 subscn:

1 04/14/2006 09:31:37

change #1 typ:0 cls:33 afn:

2 dba:0x00800089 scn:0x0000.0fa89cfe seq: 1 op:5.2

ktudh redo: slt: 0x0028 sqn:

0x00009c88 flg: 0x0011 siz: 52 fbi: 0

uba: 0x00800559.0352.06 pxid:

0x0000.000.00000000

change #2 typ:0 cls:34 afn:

2 dba:0x00800559 scn:0x0000.0fa89cfd seq: 1 op:5.1

ktudb redo: siz: 52 spc: 7680 flg: 0x0012 seq: 0x0352 rec: 0x06

xid: 0x0009.028.00009c88

ktubl redo: slt: 40 rci: 0 opc: 5.7 objn: 0 objd: 0 tsn: 0

undo type: regular undo begin trans last buffer split: no

temp object: no

tablespace undo: no

0x00000000 prev ctl uba: 0x00800559.0352.05

prev ctl max cmt scn: 0x0000.0fa89905 prev tx cmt scn: 0x0000.0fa8990a

change #3 media recovery marker scn:0x0000.00000000 seq: 0 op:5.20

session number = 8

serial number = 1

transaction name =

redo record - thread:1 rba:

0x000094.00000010.0010 len: 0x0054 vld: 0x01

scn: 0x0000.0fa89d03 subscn:

1 04/14/2006 09:31:37

change #1 typ:0 cls:33 afn:2 dba:

0x00800089 scn:0x0000.0fa89d02 seq: 1 op:5.4

ktucm redo: slt: 0x0028 sqn:

0x00009c88 srt: 0 sta: 9 flg: 0x2

ktucf redo: uba:

0x00800559.0352.06 ext: 2 spc: 7626 fbi: 0

end of redo dump

----- redo read statistics for thread 1 -----

read rate (async): 7kb in 0.19s => 0.00 mb/sec

longest record: 0kb, moves: 0/27 (0%)

change moves: 6/63 (9%), moved: 0mb

5.禁用日志生成的,并且切换日志

sql> alter system set "_disable_logging"=true;

system altered.

sql> alter system switch logfile;

system altered.

sql> select * from v$log;

group# thread# sequence# bytes members arc status first_change# first_tim

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

1 1 148 104857600 1 no active 262708457 14-apr-06

2 1 149 104857600 1 no current 262708606 14-apr-06

3 1 147 104857600 1 no inactive 262675537 14-apr-06

6.scott用户再更新

sql> show parameter disable

name type value

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

_disable_logging boolean true

sql> update emp set sal=4000 where empno=7788;

1 row updated.

sql> commit;

commit complete.

7.转储日志

sql> alter system dump logfile '

/opt/oracle9/oradata/testora9/redo02.log';

system altered.

8.记录此时redo信息

dump of redo from file '/opt/oracle9/oradata/testora9/redo02.log'

opcodes *.*

dba's: (file # 0, block # 0) thru (file # 65534, block # 4194303)

rba's: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff

scn's scn: 0x0000.00000000 thru scn: 0xffff.ffffffff

times: creation thru eternity

file header:

software vsn=153092096=0x9200000, compatibility vsn=153092096=0x9200000

db id=1628068176=0x610a5950, db name='testora9'

activation id=1628067152=0x610a5550

control seq=1163=0x48b, file size=204800=0x32000

file number=2, blksiz=512, file type=2 log

descrip:"thread 0001, seq# 0000000149, scn 0x00000fa89d7e-0xffffffffffff"

thread: 1 nab: 0xffffffff seq: 0x00000095 hws: 0x1 eot: 1 dis: 0

reset logs count: 0x1f435110 scn: 0x0000.00000001

low scn: 0x0000.0fa89d7e 04/14/2006 09:33:43

next scn: 0xffff.ffffffff 01/01/1988 00:00:00

enabled scn: 0x0000.00000001 04/26/2004 15:56:10

thread closed scn: 0x0000.0fa89d7e 04/14/2006 09:33:43

log format vsn: 0x8000000 disk cksum: 0xcac7 calc cksum: 0xcac7

terminal recovery stamp scn: 0x0000.00000000 01/01/1988 00:00:00

most recent redo scn: 0x0000.00000000

largest lwn: 0 blocks

end-of-redo stream : no

unprotected mode

miscellaneous flags: 0x0

end of redo dump

至此已经没有redo的生成.数据库目前仅仅记录少量的必要信息。