eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« 2007 我的新书写作计划 | Blog首页 | Oracle ACE China的一个小小聚会 »

Oracle10g Events CONTROLF的改变

《深入浅出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-


历史上的今天...
    >> 2009-02-07文章:
    >> 2008-02-07文章:
           ORA-03113错误解决一例
    >> 2006-02-07文章:
           DBWR enhancements In Oracle10g
    >> 2005-02-07文章:
           如何获得Oracle的隐含参数

无觅

By eygle on 2007-02-07 11:28 | Comments (0) | Oracle12c/11g | 1351 |


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com