|
|
Oracle10g Events CONTROLF的改变
发表日期：2008-2-9 
| 
|
《深入浅出Oracle》的一个读者在我的留言板上提出一个问题，他说以下这条命令运行生成的跟踪文件和我书上的结果完全不同：
alter session set events 'immediate trace name controlf level 10';
注重一下他的输出:
DUMP OF CONTROL FILES, Seq # 2017 = 0x7e1
V10 STYLE FILE HEADER:
Compatibility Vsn = 169869568=0xa200100
Db ID=2395540743=0x8ec90d07, Db Name='TESTDB'
Activation ID=0=0x0
Control Seq=2017=0x7e1, File size=932=0x3a4
File Number=0, Blksiz=16384, File Type=1 CONTROL
原来是V10 Style的输出，这是Oracle10g的数据库，我书中第一章的测试来自Oracle9iR2，由于events是Oracle的内部事件，其行为在不同的版本中可能不同。
在Oracle10g中，使用Level 8的trace，得到以下的输出.
在这个输出中，和Oracle9i最大的不同是enabled threads部分增加了位图信息，这个信息的增加我猜测是为了满足Oracle10g Grid运算支持大量并行实例的需要.Level 10及的trace将包含DUMP memory的信息，可读性又有所降低了。
记录一下，还有待于进一步研究：
DUMP OF CONTROL FILES, Seq # 522 = 0x20a
V10 STYLE FILE HEADER:
Compatibility Vsn = 169869568=0xa200100
Db ID=1417824532=0x54824914, Db Name='EYGLE'
Activation ID=0=0x0
Control Seq=522=0x20a, File size=430=0x1ae
File Number=0, Blksiz=16384, File Type=1 CONTROL
***************************************************************************
DATABASE ENTRY
***************************************************************************
(size = 316, compat size = 316, section max = 1, section in-use = 1,
last-recid= 0, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 1, numrecs = 1)
08/17/2006 19:41:08
DB Name "EYGLE"
Database flags = 0x00404000 0x00001000
Controlfile Creation Timestamp 08/17/2006 19:41:09
Incmplt recovery scn: 0x0000.00000000
Resetlogs scn: 0x0000.00000001 Resetlogs Timestamp 08/17/2006 19:41:08
Prior resetlogs scn: 0x0000.00000000 Prior resetlogs Timestamp 01/01/1988 00:00:00
Redo Version: compatible=0xa200100
#Data files = 4, #Online files = 4
Database checkpoint: Thread=1 scn: 0x0000.0007276a
Threads: #Enabled=1, #Open=1, Head=1, Tail=1
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000
Max log members = 3, Max data members = 1
Arch list: Head=0, Tail=0, Force scn: 0x0000.0005a8ebscn: 0x0000.00000000
Activation ID: 1417764628
Controlfile Checkpointed at scn: 0x0000.0007281d 02/07/2007 10:20:47
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
.......
*************************************************************************** CHECKPOINT PROGRESS RECORDS ***************************************************************************
(size = 8180, compat size = 8180, section max = 11, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 2, numrecs = 11)
THREAD #1 - status:0x2 flags:0x0 dirty:24 low cache rba:(0x17.14dc8.0) on disk rba:(0x17.14df3.0) on disk scn: 0x0000.0007335c 02/07/2007 11:34:28 resetlogs scn: 0x0000.00000001 08/17/2006 19:41:08 heartbeat: 613912496 mount id: 1433005479 THREAD #2 - status:0x0 flags:0x0 dirty:0 low cache rba:(0x0.0.0) on disk rba:(0x0.0.0) on disk scn: 0x0000.00000000 01/01/1988 00:00:00 resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00 heartbeat: 0 mount id: 0 THREAD #3 - status:0x0 flags:0x0 dirty:0 low cache rba:(0x0.0.0) on disk rba:(0x0.0.0) on disk scn: 0x0000.00000000 01/01/1988 00:00:00 resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00 heartbeat: 0 mount id: 0 THREAD #4 - status:0x0 flags:0x0 dirty:0 low cache rba:(0x0.0.0) on disk rba:(0x0.0.0) on disk scn: 0x0000.00000000 01/01/1988 00:00:00 resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00 heartbeat: 0 mount id: 0 THREAD #5 - status:0x0 flags:0x0 dirty:0 low cache rba:(0x0.0.0) on disk rba:(0x0.0.0) on disk scn: 0x0000.00000000 01/01/1988 00:00:00 resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00 heartbeat: 0 mount id: 0 THREAD #6 - status:0x0 flags:0x0 dirty:0 low cache rba:(0x0.0.0) on disk rba:(0x0.0.0) on disk scn: 0x0000.00000000 01/01/1988 00:00:00 resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00 heartbeat: 0 mount id: 0 THREAD #7 - status:0x0 flags:0x0 dirty:0 low cache rba:(0x0.0.0) on disk rba:(0x0.0.0) on disk scn: 0x0000.00000000 01/01/1988 00:00:00 resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00 heartbeat: 0 mount id: 0 THREAD #8 - status:0x0 flags:0x0 dirty:0 low cache rba:(0x0.0.0) on disk rba:(0x0.0.0) on disk scn: 0x0000.00000000 01/01/1988 00:00:00 resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00 heartbeat: 0 mount id: 0 *************************************************************************** EXTENDED DATABASE ENTRY ***************************************************************************
(size = 276, compat size = 276, section max = 1, section in-use = 1, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 137, numrecs = 1) Control AutoBackup date(dd/mm/yyyy)=17/ 8/2006 Next AutoBackup sequence= 0 Database recovery target inc#:1, Last open inc#:1 flg:0x0, flag:0x0 Change tracking state=0, file index=0, checkpoint count=0 Flashback log count=0, block count=0 Oldest guarantee restore point=0 ***************************************************************************
REDO THREAD RECORDS ***************************************************************************
(size = 256, compat size = 256, section max = 8, section in-use = 1, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 9, numrecs = 8) THREAD #1 - status:0xf thread links forward:0 back:0 #logs:3 first:1 last:3 current:2 last used seq#:0x17 enabled at scn: 0x0000.00000001 08/17/2006 19:41:33 disabled at scn: 0x0000.00000000 01/01/1988 00:00:00 opened at 02/07/2007 10:20:31 by instance eygle Checkpointed at scn: 0x0000.0007276a 02/07/2007 10:20:31 thread:1 rba:(0x17.13a4d.10) enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 .... log history: 22 ***************************************************************************
LOG FILE RECORDS ***************************************************************************
(size = 72, compat size = 72, section max = 16, section in-use = 3, last-recid= 3, old-recno = 0, last-recno = 0) (extent = 1, blkno = 10, numrecs = 16) LOG FILE #1: (name #1) D:\ORADATA\EYGLE\ONLINELOG\O1_MF_1_2G8OGOQG_.LOG (name #2) D:\ORADATA\FLASH_RECOVERY_AREA\EYGLE\ONLINELOG\O1_MF_1_2G8OGTJH_.LOG Thread 1 redo log links: forward: 2 backward: 0 siz: 0x19000 seq: 0x00000016 hws: 0xd bsz: 512 nab: 0x6ed8 flg: 0x0 dup: 2 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.0005a8eb Low scn: 0x0000.00063e6d 01/25/2007 17:15:06 Next scn: 0x0000.0006b865 02/02/2007 10:44:31 LOG FILE #2: (name #3) D:\ORADATA\EYGLE\ONLINELOG\O1_MF_2_2G8OGZKN_.LOG (name #4) D:\ORADATA\FLASH_RECOVERY_AREA\EYGLE\ONLINELOG\O1_MF_2_2G8OH3JL_.LOG Thread 1 redo log links: forward: 3 backward: 1 siz: 0x19000 seq: 0x00000017 hws: 0x11 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 2 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.00063e6d Low scn: 0x0000.0006b865 02/02/2007 10:44:31 Next scn: 0xffff.ffffffff 01/01/1988 00:00:00 LOG FILE #3: (name #5) D:\ORADATA\EYGLE\ONLINELOG\O1_MF_3_2G8OH65Q_.LOG (name #6) D:\ORADATA\FLASH_RECOVERY_AREA\EYGLE\ONLINELOG\O1_MF_3_2G8OH8XX_.LOG Thread 1 redo log links: forward: 0 backward: 2 siz: 0x19000 seq: 0x00000015 hws: 0xf bsz: 512 nab: 0x18ffd flg: 0x0 dup: 2 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.000591bc Low scn: 0x0000.0005a8eb 01/25/2007 11:22:46 Next scn: 0x0000.00063e6d 01/25/2007 17:15:06 ***************************************************************************
DATA FILE RECORDS ***************************************************************************
(size = 428, compat size = 428, section max = 100, section in-use = 4, last-recid= 9, old-recno = 0, last-recno = 0) (extent = 1, blkno = 11, numrecs = 100) DATA FILE #1: (name #7) D:\ORADATA\EYGLE\DATAFILE\O1_MF_SYSTEM_2G8OHFX6_.DBF creation size=38400 block size=8192 status=0xe head=7 tail=7 dup=1 tablespace 0, index=1 krfil=1 prev_file=0 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00 Checkpoint cnt:86 scn: 0x0000.0007276a 02/07/2007 10:20:31 Stop scn: 0xffff.ffffffff 02/05/2007 16:41:32 Creation Checkpointed at scn: 0x0000.00000009 08/17/2006 19:41:47 thread:1 rba:(0x1.3.10) enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 .... Offline scn: 0x0000.00000000 prev_range: 0 Online Checkpointed at scn: 0x0000.00000000 thread:0 rba:(0x0.0.0) enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 .... 00000000 00000000 00000000 00000000 00000000 00000000 Hot Backup end marker scn: 0x0000.00000000 aux_file is NOT DEFINED DATA FILE #2: (name #8) D:\ORADATA\EYGLE\DATAFILE\O1_MF_UNDOTBS1_2G8OJ6NB_.DBF creation size=25600 block size=8192 status=0xe head=8 tail=8 dup=1 tablespace 1, index=2 krfil=2 prev_file=0 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00 Checkpoint cnt:86 scn: 0x0000.0007276a 02/07/2007 10:20:31 Stop scn: 0xffff.ffffffff 02/05/2007 16:41:32 Creation Checkpointed at scn: 0x0000.000013cc 08/17/2006 19:42:07 thread:1 rba:(0x1.4a1b.10) enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 .... 00000000 00000000 00000000 00000000 00000000 00000000 Offline scn: 0x0000.00000000 prev_range: 0 Online Checkpointed at scn: 0x0000.00000000 thread:0 rba:(0x0.0.0) enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 .... 00000000 00000000 00000000 00000000 00000000 00000000 Hot Backup end marker scn: 0x0000.00000000 aux_file is NOT DEFINED DATA FILE #3: (name #9) D:\ORADATA\EYGLE\DATAFILE\O1_MF_SYSAUX_2G8OJHP9_.DBF creation size=15360 block size=8192 status=0xe head=9 tail=9 dup=1 tablespace 2, index=3 krfil=3 prev_file=0 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00 Checkpoint cnt:86 scn: 0x0000.0007276a 02/07/2007 10:20:31 Stop scn: 0xffff.ffffffff 02/05/2007 16:41:32 Creation Checkpointed at scn: 0x0000.0000144e 08/17/2006 19:42:13 thread:1 rba:(0x1.4ac4.10) enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 .... 00000000 00000000 00000000 00000000 00000000 00000000 Offline scn: 0x0000.00000000 prev_range: 0 Online Checkpointed at scn: 0x0000.00000000 thread:0 rba:(0x0.0.0) enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 ..... 00000000 00000000 00000000 00000000 00000000 00000000 Hot Backup end marker scn: 0x0000.00000000 aux_file is NOT DEFINED DATA FILE #4: (name #11) D:\ORADATA\EYGLE\DATAFILE\O1_MF_USERS_2G8OJYYS_.DBF creation size=640 block size=8192 status=0xe head=11 tail=11 dup=1 tablespace 4, index=5 krfil=4 prev_file=0 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00 Checkpoint cnt:85 scn: 0x0000.0007276a 02/07/2007 10:20:31 Stop scn: 0xffff.ffffffff 02/05/2007 16:41:32 Creation Checkpointed at scn: 0x0000.00001f92 08/17/2006 19:42:23 thread:1 rba:(0x1.74f7.10) enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 ..... 00000000 00000000 00000000 00000000 00000000 00000000 Offline scn: 0x0000.00000000 prev_range: 0 Online Checkpointed at scn: 0x0000.00000000 thread:0 rba:(0x0.0.0) enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 ..... 00000000 00000000 00000000 00000000 00000000 00000000 Hot Backup end marker scn: 0x0000.00000000 aux_file is NOT DEFINED ***************************************************************************
TEMP FILE RECORDS ***************************************************************************
(size = 56, compat size = 56, section max = 100, section in-use = 2, last-recid= 5, old-recno = 0, last-recno = 0) (extent = 1, blkno = 89, numrecs = 100) TEMP FILE #1: External File #201 (name #10) D:\ORADATA\EYGLE\DATAFILE\O1_MF_TEMP_2G8OJPDX_.TMP creation size=2560 block size=8192 status=0x1e head=10 tail=10 dup=1 tablespace 3, index=4 krfil=1 prev_file=0 unrecoverable scn: 0x0000.00001654 08/17/2006 19:42:14 TEMP FILE #2: External File #202 creation size=128000 block size=8192 status=0xc head=0 tail=0 dup=0 tablespace 5, index=6 krfil=1 prev_file=0 unrecoverable scn: 0x0000.0003320a 01/08/2007 16:43:52 *************************************************************************** TABLESPACE RECORDS ***************************************************************************
(size = 68, compat size = 68, section max = 100, section in-use = 6, last-recid= 9, old-recno = 0, last-recno = 0) (extent = 1, blkno = 88, numrecs = 100) TABLESPACE #0 SYSTEM: recno=1 First datafile link=1 Tablespace Flag=0 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00 TABLESPACE #1 UNDOTBS1: recno=2 First datafile link=2 Tablespace Flag=0 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00 TABLESPACE #2 SYSAUX: recno=3 First datafile link=3 Tablespace Flag=0 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00 TABLESPACE #3 TEMP: recno=4 First datafile link=1 Tablespace Flag=1 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00 TABLESPACE #4 USERS: recno=5 First datafile link=4 Tablespace Flag=0 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00 TABLESPACE #2147483647 TEMP1: recno=6 First datafile link=0 Tablespace Flag=1 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00 ***************************************************************************
RMAN CONFIGURATION RECORDS ***************************************************************************
(size = 1108, compat size = 1108, section max = 50, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 90, numrecs = 50) *************************************************************************** FLASHBACK LOGFILE RECORDS ***************************************************************************
(size = 84, compat size = 84, section max = 2048, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 139, numrecs = 2048) *************************************************************************** THREAD INSTANCE MAPPING RECORDS ***************************************************************************
(size = 80, compat size = 80, section max = 8, section in-use = 8, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 156, numrecs = 8) eygle recno=1 UNNAMED_INSTANCE_2 recno=2 UNNAMED_INSTANCE_3 recno=3 UNNAMED_INSTANCE_4 recno=4 UNNAMED_INSTANCE_5 recno=5 UNNAMED_INSTANCE_6 recno=6 UNNAMED_INSTANCE_7 recno=7 UNNAMED_INSTANCE_8 recno=8 ***************************************************************************
MTTR RECORDS ***************************************************************************
(size = 100, compat size = 100, section max = 8, section in-use = 1, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 157, numrecs = 8) MTTR record for thread 1 MTTR statistics status: 3 Init time: Avg: 27724313 us, Times measured: 4 File open time: Avg: 112894 us, Times measured: 16 Log block read time: Avg: 20 us, Times measured: 65536 Data block read/claim time: Avg: 170 us, Times measured: 1000 Data block write time: Avg: 390 us 1000 change vector apply time: Avg: 143264 us, Times measured: 28 Ratio Information: # of log blocks measured: 698471 # of data blocks measured: 32871 # of change vectors measured: 1457654 *************************************************************************** STANDBY DATABASE MAP RECORDS ***************************************************************************
(size = 400, compat size = 400, section max = 10, section in-use = 10, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 160, numrecs = 10) *************************************************************************** RESTORE POINT RECORDS ***************************************************************************
(size = 212, compat size = 212, section max = 2048, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 161, numrecs = 2048) ***************************************************************************
LOG FILE HISTORY RECORDS ***************************************************************************
(size = 56, compat size = 56, section max = 292, section in-use = 22, last-recid= 22, old-recno = 1, last-recno = 22) (extent = 1, blkno = 94, numrecs = 292) Earliest record: RECID #1 Recno 1 Record timestamp 08/17/06 19:45:30 Thread=1 Seq#=1 Link-Recid=0 kccic-Recid=1 Low scn: 0x0000.00000001 08/17/06 19:41:33 Next scn: 0x0000.0000850a Latest record: RECID #22 Recno 22 Record timestamp 02/02/07 10:44:31 Thread=1 Seq#=22 Link-Recid=21 kccic-Recid=1 Low scn: 0x0000.00063e6d 01/25/07 17:15:06 Next scn: 0x0000.0006b865 RECID #21 Recno 21 Record timestamp 01/25/07 17:15:06 Thread=1 Seq#=21 Link-Recid=20 kccic-Recid=1 Low scn: 0x0000.0005a8eb 01/25/07 11:22:46 Next scn: 0x0000.00063e6d RECID #20 Recno 20 Record timestamp 01/25/07 11:22:47 Thread=1 Seq#=20 Link-Recid=19 kccic-Recid=1 Low scn: 0x0000.000591bc 01/25/07 11:21:16 Next scn: 0x0000.0005a8eb RECID #19 Recno 19 Record timestamp 01/25/07 11:21:17 Thread=1 Seq#=19 Link-Recid=18 kccic-Recid=1 Low scn: 0x0000.00055826 01/25/07 11:20:02 Next scn: 0x0000.000591bc RECID #18 Recno 18 Record timestamp 01/25/07 11:20:02 Thread=1 Seq#=18 Link-Recid=17 kccic-Recid=1 Low scn: 0x0000.00052492 01/25/07 11:16:18 Next scn: 0x0000.00055826 RECID #17 Recno 17 Record timestamp 01/25/07 11:16:18 Thread=1 Seq#=17 Link-Recid=16 kccic-Recid=1 Low scn: 0x0000.0004fb00 01/25/07 11:03:35 Next scn: 0x0000.00052492 RECID #16 Recno 16 Record timestamp 01/25/07 11:03:36 Thread=1 Seq#=16 Link-Recid=15 kccic-Recid=1 Low scn: 0x0000.0004b072 01/13/07 15:53:08 Next scn: 0x0000.0004fb00 RECID #15 Recno 15 Record timestamp 01/13/07 15:53:08 Thread=1 Seq#=15 Link-Recid=14 kccic-Recid=1 Low scn: 0x0000.00045da5 01/13/07 15:30:39 Next scn: 0x0000.0004b072 RECID #14 Recno 14 Record timestamp 01/13/07 15:30:40 Thread=1 Seq#=14 Link-Recid=13 kccic-Recid=1 Low scn: 0x0000.0003eaff 01/12/07 15:27:28 Next scn: 0x0000.00045da5 RECID #13 Recno 13 Record timestamp 01/12/07 15:27:28 Thread=1 Seq#=13 Link-Recid=12 kccic-Recid=1 Low scn: 0x0000.00039857 01/09/07 15:09:27 Next scn: 0x0000.0003eaff RECID #12 Recno 12 Record timestamp 01/09/07 15:09:27 Thread=1 Seq#=12 Link-Recid=11 kccic-Recid=1 Low scn: 0x0000.0003100e 09/25/06 10:19:55 Next scn: 0x0000.00039857 RECID #11 Recno 11 Record timestamp 09/25/06 10:19:55 Thread=1 Seq#=11 Link-Recid=10 kccic-Recid=1 Low scn: 0x0000.0002c06a 08/22/06 10:46:44 Next scn: 0x0000.0003100e RECID #10 Recno 10 Record timestamp 08/22/06 10:46:44 Thread=1 Seq#=10 Link-Recid=9 kccic-Recid=1 Low scn: 0x0000.00026213 08/17/06 20:13:42 Next scn: 0x0000.0002c06a RECID #9 Recno 9 Record timestamp 08/17/06 20:13:42 Thread=1 Seq#=9 Link-Recid=8 kccic-Recid=1 Low scn: 0x0000.00022efa 08/17/06 20:11:46 Next scn: 0x0000.00026213 RECID #8 Recno 8 Record timestamp 08/17/06 20:11:47 Thread=1 Seq#=8 Link-Recid=7 kccic-Recid=1 Low scn: 0x0000.0001f3d5 08/17/06 19:57:06 Next scn: 0x0000.00022efa RECID #7 Recno 7 Record timestamp 08/17/06 19:57:06 Thread=1 Seq#=7 Link-Recid=6 kccic-Recid=1 Low scn: 0x0000.0001b362 08/17/06 19:53:44 Next scn: 0x0000.0001f3d5 RECID #6 Recno 6 Record timestamp 08/17/06 19:53:44 Thread=1 Seq#=6 Link-Recid=5 kccic-Recid=1 Low scn: 0x0000.00017065 08/17/06 19:52:02 Next scn: 0x0000.0001b362 RECID #5 Recno 5 Record timestamp 08/17/06 19:52:02 Thread=1 Seq#=5 Link-Recid=4 kccic-Recid=1 Low scn: 0x0000.000150ed 08/17/06 19:49:57 Next scn: 0x0000.00017065 RECID #4 Recno 4 Record timestamp 08/17/06 19:49:58 Thread=1 Seq#=4 Link-Recid=3 kccic-Recid=1 Low scn: 0x0000.00012232 08/17/06 19:48:01 Next scn: 0x0000.000150ed RECID #3 Recno 3 Record timestamp 08/17/06 19:48:01 Thread=1 Seq#=3 Link-Recid=2 kccic-Recid=1 Low scn: 0x0000.0000e17f 08/17/06 19:46:46 Next scn: 0x0000.00012232 RECID #2 Recno 2 Record timestamp 08/17/06 19:46:47 Thread=1 Seq#=2 Link-Recid=1 kccic-Recid=1 Low scn: 0x0000.0000850a 08/17/06 19:45:30 Next scn: 0x0000.0000e17f RECID #1 Recno 1 Record timestamp 08/17/06 19:45:30 Thread=1 Seq#=1 Link-Recid=0 kccic-Recid=1 Low scn: 0x0000.00000001 08/17/06 19:41:33 Next scn: 0x0000.0000850a *************************************************************************** OFFLINE RANGE RECORDS ***************************************************************************
(size = 200, compat size = 200, section max = 163, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 95, numrecs = 163) *************************************************************************** ARCHIVED LOG RECORDS ***************************************************************************
(size = 584, compat size = 584, section max = 28, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 97, numrecs = 28) *************************************************************************** BACKUP SET RECORDS ***************************************************************************
(size = 40, compat size = 40, section max = 409, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 98, numrecs = 409) *************************************************************************** BACKUP PIECE RECORDS ***************************************************************************
(size = 736, compat size = 736, section max = 200, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 99, numrecs = 200) *************************************************************************** BACKUP DATAFILE RECORDS ***************************************************************************
(size = 116, compat size = 116, section max = 282, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 108, numrecs = 282) *************************************************************************** BACKUP LOG RECORDS ***************************************************************************
(size = 76, compat size = 76, section max = 215, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 110, numrecs = 215) *************************************************************************** DATAFILE COPY RECORDS ***************************************************************************
(size = 660, compat size = 660, section max = 223, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 111, numrecs = 223) *************************************************************************** BACKUP DATAFILE CORRUPTION RECORDS ***************************************************************************
(size = 44, compat size = 44, section max = 371, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 120, numrecs = 371) *************************************************************************** DATAFILE COPY CORRUPTION RECORDS ***************************************************************************
(size = 40, compat size = 40, section max = 409, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 121, numrecs = 409) *************************************************************************** DELETION RECORDS ***************************************************************************
(size = 20, compat size = 20, section max = 818, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 122, numrecs = 818) ***************************************************************************
PROXY COPY RECORDS ***************************************************************************
(size = 852, compat size = 852, section max = 249, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 123, numrecs = 249) *************************************************************************** INCARNATION RECORDS ***************************************************************************
(size = 56, compat size = 56, section max = 292, section in-use = 1, last-recid= 1, old-recno = 1, last-recno = 1) (extent = 1, blkno = 138, numrecs = 292) Earliest record: RECID #1 Recno 1 Record timestamp Resetlogs scn and time scn: 0x0000.00000001 08/17/06 19:41:08 Previous Resetlogs scn and time scn: 0x0000.00000000 01/01/88 00:00:00 Incarnation (parent inc#, flag)=(0, 2) Latest record: RECID #1 Recno 1 Record timestamp Resetlogs scn and time scn: 0x0000.00000001 08/17/06 19:41:08 Previous Resetlogs scn and time scn: 0x0000.00000000 01/01/88 00:00:00 Incarnation (parent inc#, flag)=(0, 2) ***************************************************************************
RMAN STATUS RECORDS ***************************************************************************
(size = 116, compat size = 116, section max = 141, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 155, numrecs = 141) *************************************************************************** DATAFILE HISTORY RECORDS ***************************************************************************
(size = 568, compat size = 568, section max = 57, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 158, numrecs = 57) *************************************************************************** NORMAL RESTORE POINT RECORDS ***************************************************************************
(size = 212, compat size = 212, section max = 2083, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 188, numrecs = 2083) *** END OF DUMP ***
-The End-
http://www.eygle.com/archives/2007/02/10g_controlf_events_changed.Html
|
|
|
上一篇：oracle 10g重建em db control
人气:802
下一篇：Oracle 数据库优化的R方法(Method R)
人气:605 |
浏览全部Oracle教程的内容
Dreamweaver插件下载
常用网页广告代码全集
|
|
