科技行者

行者学院 转型私董会 科技行者专题报道 网红大战科技行者

知识库

知识库 安全导航

至顶网软件频道Oracle10g Events CONTROLF的改变

Oracle10g Events CONTROLF的改变

  • 扫一扫
    分享文章到微信

  • 扫一扫
    关注官方公众号
    至顶头条

《深入浅出Oracle》的一个读者在我的留言板上提出一个问题。

作者:中国IT实验室 来源:中国IT实验室 2007年10月7日

关键字: ORACLE

  • 评论
  • 分享微博
  • 分享邮件

在本页阅读全文(共2页)



 

*************************************************************************** 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

查看本文来源

    • 评论
    • 分享微博
    • 分享邮件
    邮件订阅

    如果您非常迫切的想了解IT领域最新产品与技术信息,那么订阅至顶网技术邮件将是您的最佳途径之一。

    重磅专题
    往期文章
    最新文章