如何查看Control File中保存的内容
------------------------------------------------------------------Control File是二进制文件，用普通的方法很难知道其中到底保存了什么内容，但是Oracle却提供了一个SQL*PLUS命令来将Control File的内容dump到文本文件中。
方法如下： 以SYSDBA身份登入SQL*PLUS
SQL> oradebug setmypid
SQL> oradebug dump controlf 3
将把control file dump到USER_DUMP_DEST初始化参数指定的目录下。
其中3为dump level。 level的解释如下：
1 ：only the file header
2 ：just the file header, the database info record, and checkpoint progress records
3 ：all record types, but just the earliest and latest records for circular reuse record types
4 ：as above, but includes the 4 most recent records for circular reuse record types
5+ ：as above, but the number of circular reuse records included doubles with each level
范例:
--------------------------------------------------------------------
Dump file d:\oracle9i\admin\wenhua01\udump\wenhua01_ora_2716.trc
Wed Nov 01 11:32:22 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.1 , CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.1 , CPU type 586
Instance name: wenhua01
*** 2006-11-01 11:32:22.000
*** SESSION ID:(9.5) 2006-11-01 11:32:22.000
DUMP OF CONTROL FILES, Seq # 312 = 0x138
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=134217728=0x8000000
Db ID=3005787356=0xb328acdc, Db Name='WENHUA01'
Activation ID=0=0x0
Control Seq=312=0x138, File size=202=0xca
File Number=0, Blksiz=8192, File Type=1 CONTROL
***************************************************************************
DATABASE ENTRY
***************************************************************************
(blkno = 0x1, size = 192, max = 1, in-use = 1, last-recid= 0)
DF Version: creation=0x9200000 compatible=0x8000000, Date 09/13/2006 16:17:32
DB Name "WENHUA01"
Database flags = 0x00404001
Controlfile Creation Timestamp 09/13/2006 16:17:33
Incmplt recovery scn: 0x0000.00000000
Resetlogs scn: 0x0000.00000001 Resetlogs Timestamp 09/13/2006 16:17:32
Prior resetlogs scn: 0x0000.00000000 Prior resetlogs Timestamp 01/01/1988 00:00:00
Redo Version: creation=0x9200000 compatable=0x9200000
#Data files = 6, #Online files = 5
Database checkpoint: Thread=1 scn: 0x0000.0001ffa6
Threads: #Enabled=1, #Open=1, Head=1, Tail=1
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Max log members = 3, Max data members = 1
Arch list: Head=5, Tail=5, Force scn: 0x0000.000136afscn: 0x0000.0001db49
Controlfile Checkpointed at scn: 0x0000.000200fc 11/01/2006 11:32:09
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
***************************************************************************
CHECKPOINT PROGRESS RECORDS
***************************************************************************
(blkno = 0x4, size = 104, max = 1, in-use = 1, last-recid= 0)
THREAD #1 - status:0x2 flags:0x0 dirty:61
low cache rba:(0x2e.3f4.0) on disk rba:(0x2e.45e.0)
on disk scn: 0x0000.00020103 11/01/2006 11:32:09
resetlogs scn: 0x0000.00000001 09/13/2006 16:17:32
heartbeat: 605412996 mount id: 3010095719
MTTR statistics status: 3
Init time: Avg: 11111046, Times measured: 3
File open time: Avg: 59681, Times measured: 23
Log block read time: Avg: 110, Times measured: 18945
Data block handling time: Avg: 6329, Times measured: 147
***************************************************************************
EXTENDED DATABASE ENTRY
***************************************************************************
(blkno = 0x64, size = 276, max = 1, in-use = 1, last-recid= 0)
Control AutoBackup date(dd/mm/yyyy)=13/ 9/2006
Next AutoBackup sequence= 0
***************************************************************************
REDO THREAD RECORDS
***************************************************************************
(blkno = 0x4, size = 104, max = 1, in-use = 1, last-recid= 0)
THREAD #1 - status:0xf thread links forward:0 back:0
#logs:3 first:3 last:5 current:5 last used seq#:0x2e
enabled at scn: 0x0000.00000001 09/13/2006 16:18:07
disabled at scn: 0x0000.00000000 01/01/1988 00:00:00
opened at 11/01/2006 11:21:18 by instance wenhua01
Checkpointed at scn: 0x0000.0001ffa6 11/01/2006 11:21:18
thread:1 rba:(0x2e.3f3.10)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
log history: 45
***************************************************************************
LOG FILE RECORDS
***************************************************************************
(blkno = 0x5, size = 72, max = 5, in-use = 5, last-recid= 13)
LOG FILE #1:
Thread 0 redo log links: forward: 0 backward: 0
siz: 0x0 seq: 0x00000000 hws: 0x0 bsz: 0 nab: 0x0 flg: 0x0 dup: 0
Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.00000000
Low scn: 0x0000.00000000 01/01/1988 00:00:00
Next scn: 0x0000.00000000 01/01/1988 00:00:00
LOG FILE #2:
Thread 0 redo log links: forward: 0 backward: 0
siz: 0x0 seq: 0x00000000 hws: 0x0 bsz: 0 nab: 0x0 flg: 0x0 dup: 0
Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.00000000
Low scn: 0x0000.00000000 01/01/1988 00:00:00
Next scn: 0x0000.00000000 01/01/1988 00:00:00
LOG FILE #3:
(name #1) D:\ORACLE9I\ORADATA\WENHUA01\REDO3A.LOG
(name #2) D:\ORACLE9I\ORADATA\WENHUA01\REDO3B.LOG
Thread 1 redo log links: forward: 4 backward: 0
siz: 0x800 seq: 0x0000002d hws: 0xc bsz: 512 nab: 0x6e flg: 0x1 dup: 2
Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.000136af
Low scn: 0x0000.00018c98 09/14/2006 10:41:18
Next scn: 0x0000.0001db49 10/31/2006 09:14:56
LOG FILE #4:
(name #11) D:\ORACLE9I\ORADATA\WENHUA01\REDO4A.LOG
(name #12) D:\ORACLE9I\ORADATA\WENHUA01\REDO4B.LOG
Thread 1 redo log links: forward: 5 backward: 3
siz: 0x800 seq: 0x0000002c hws: 0xc bsz: 512 nab: 0x6aa flg: 0x1 dup: 2
Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.0001345f
Low scn: 0x0000.000136af 09/14/2006 09:41:12
Next scn: 0x0000.00018c98 09/14/2006 10:41:18
LOG FILE #5:
(name #13) D:\ORACLE9I\ORADATA\WENHUA01\REDO5A.LOG
(name #14) D:\ORACLE9I\ORADATA\WENHUA01\REDO5B.LOG
Thread 1 redo log links: forward: 0 backward: 4
siz: 0x800 seq: 0x0000002e hws: 0x17 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 2
Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.00018c98
Low scn: 0x0000.0001db49 10/31/2006 09:14:56
Next scn: 0xffff.ffffffff 01/01/1988 00:00:00
***************************************************************************
DATA FILE RECORDS
***************************************************************************
(blkno = 0x6, size = 180, max = 100, in-use = 6, last-recid= 22)
DATA FILE #1:
(name #4) D:\ORACLE9I\ORADATA\WENHUA01\SYSTEM01.DBF
creation size=32000 block size=8192 status=0xe head=4 tail=4 dup=1
tablespace 0, index=1 krfil=1 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:65 scn: 0x0000.0001ffa6 11/01/2006 11:21:18
Stop scn: 0xffff.ffffffff 11/01/2006 11:07:16
Creation Checkpointed at scn: 0x0000.0000000b 09/13/2006 16:18:34
thread:1 rba:(0x1.3.10)
enabled threads: 01000000 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
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
DATA FILE #2:
(name #5) D:\ORACLE9I\ORADATA\WENHUA01\UNDOTBS01.DBF
creation size=25600 block size=8192 status=0xe head=5 tail=5 dup=1
tablespace 1, index=2 krfil=2 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:65 scn: 0x0000.0001ffa6 11/01/2006 11:21:18
Stop scn: 0xffff.ffffffff 11/01/2006 11:07:16
Creation Checkpointed at scn: 0x0000.000011b1 09/13/2006 16:19:01
thread:1 rba:(0x1.41c3.10)
enabled threads: 01000000 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
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
DATA FILE #3:
(name #7) D:\ORACLE9I\ORADATA\WENHUA01\EXAMPLE01.DBF
creation size=1280 block size=8192 status=0x80 head=7 tail=7 dup=1
tablespace 3, index=4 krfil=3 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:64 scn: 0x0000.000200fc 11/01/2006 11:32:09
Stop scn: 0x0000.000200fc 11/01/2006 11:32:09
Creation Checkpointed at scn: 0x0000.000016f7 09/13/2006 16:19:11
thread:1 rba:(0x1.53f5.10)
enabled threads: 01000000 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
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
DATA FILE #4:
(name #8) D:\ORACLE9I\ORADATA\WENHUA01\INDX01.DBF
creation size=3200 block size=8192 status=0xe head=8 tail=8 dup=1
tablespace 4, index=5 krfil=4 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:63 scn: 0x0000.0001ffa6 11/01/2006 11:21:18
Stop scn: 0xffff.ffffffff 11/01/2006 11:07:16
Creation Checkpointed at scn: 0x0000.0000170a 09/13/2006 16:19:13
thread:1 rba:(0x1.5409.10)
enabled threads: 01000000 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
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
DATA FILE #5:
(name #3) D:\ORACLE9I\ORADATA\WENHUA01\CATALOG01.DBF
creation size=1280 block size=8192 status=0xe head=3 tail=3 dup=1
tablespace 7, index=6 krfil=5 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:50 scn: 0x0000.0001ffa6 11/01/2006 11:21:18
Stop scn: 0xffff.ffffffff 11/01/2006 11:07:16
Creation Checkpointed at scn: 0x0000.00011383 09/14/2006 08:55:54
thread:1 rba:(0xb.b9.10)
enabled threads: 01000000 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
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
DATA FILE #6:
(name #9) D:\ORACLE9I\ORADATA\WENHUA01\OEM01.DBF
creation size=2561 block size=8192 status=0xe head=9 tail=9 dup=1
tablespace 8, index=7 krfil=6 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:40 scn: 0x0000.0001ffa6 11/01/2006 11:21:18
Stop scn: 0xffff.ffffffff 11/01/2006 11:07:16
Creation Checkpointed at scn: 0x0000.00011cfb 09/14/2006 09:39:52
thread:1 rba:(0x1a.413.10)
enabled threads: 01000000 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
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
***************************************************************************
TEMP FILE RECORDS
***************************************************************************
(blkno = 0x12, size = 56, max = 100, in-use = 1, last-recid= 1)
TEMP FILE #1: External File #201
(name #6) D:\ORACLE9I\ORADATA\WENHUA01\TEMP01.DBF
creation size=5120 block size=8192 status=0xe head=6 tail=6 dup=1
tablespace 2, index=3 krfil=1 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
***************************************************************************
TABLESPACE RECORDS
***************************************************************************
(blkno = 0x11, size = 68, max = 100, in-use = 7, last-recid= 17)
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 TEMP: recno=3
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 #3 EXAMPLE: recno=4
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 #4 INDX: 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 #7 CATALOG: recno=6
First datafile link=5 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 #8 OEM_REPOSITORY: recno=7
First datafile link=6 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
***************************************************************************
RMAN CONFIGURATION RECORDS
***************************************************************************
(blkno = 0x13, size = 1108, max = 50, in-use = 0, last-recid= 0)
***************************************************************************
LOG FILE HISTORY RECORDS
***************************************************************************
(blkno = 0x1a, size = 36, max = 226, in-use = 45, last-recid= 45)
Earliest record:
RECID #1 Recno 1 Record timestamp 09/13/06 16:21:04 Thread=1 Seq#=1 Link-Recid=0
Low scn: 0x0000.00000001 09/13/06 16:18:07 Next scn: 0x0000.000070c8
Latest record:
RECID #45 Recno 45 Record timestamp 10/31/06 09:14:56 Thread=1 Seq#=45 Link-Recid=44
Low scn: 0x0000.00018c98 09/14/06 10:41:18 Next scn: 0x0000.0001db49
RECID #44 Recno 44 Record timestamp 09/14/06 10:41:18 Thread=1 Seq#=44 Link-Recid=43
Low scn: 0x0000.000136af 09/14/06 09:41:12 Next scn: 0x0000.00018c98
RECID #43 Recno 43 Record timestamp 09/14/06 09:41:13 Thread=1 Seq#=43 Link-Recid=42
Low scn: 0x0000.0001345f 09/14/06 09:41:09 Next scn: 0x0000.000136af
RECID #42 Recno 42 Record timestamp 09/14/06 09:41:09 Thread=1 Seq#=42 Link-Recid=41
Low scn: 0x0000.000132c5 09/14/06 09:41:03 Next scn: 0x0000.0001345f
RECID #41 Recno 41 Record timestamp 09/14/06 09:41:05 Thread=1 Seq#=41 Link-Recid=40
Low scn: 0x0000.00013170 09/14/06 09:41:01 Next scn: 0x0000.000132c5
RECID #40 Recno 40 Record timestamp 09/14/06 09:41:01 Thread=1 Seq#=40 Link-Recid=39
Low scn: 0x0000.00012f3d 09/14/06 09:40:53 Next scn: 0x0000.00013170
RECID #39 Recno 39 Record timestamp 09/14/06 09:40:54 Thread=1 Seq#=39 Link-Recid=38
Low scn: 0x0000.00012db3 09/14/06 09:40:48 Next scn: 0x0000.00012f3d
RECID #38 Recno 38 Record timestamp 09/14/06 09:40:48 Thread=1 Seq#=38 Link-Recid=37
Low scn: 0x0000.00012a3d 09/14/06 09:40:41 Next scn: 0x0000.00012db3
***************************************************************************
OFFLINE RANGE RECORDS
***************************************************************************
(blkno = 0x1b, size = 56, max = 145, in-use = 0, last-recid= 0)
***************************************************************************
ARCHIVED LOG RECORDS
***************************************************************************
(blkno = 0x1c, size = 584, max = 55, in-use = 42, last-recid= 42)
Earliest record:
RECID #1 Recno 1 Record timestamp 09/14/06 08:23:26 Thread=1 Seq#=4
Flags:
Resetlogs scn and time scn: 0x0000.00000001 09/13/06 16:17:32
filename D:\ORACLE9I\ARCHIVED\WENHUA_ARC_001_00004
Low scn: 0x0000.00010dfe 09/14/06 08:00:54 Next scn: 0x0000.0001105b 09/14/06 08:23:26
Block count=281 Blocksize=512
Latest record:
RECID #42 Recno 42 Record timestamp 10/31/06 09:14:57 Thread=1 Seq#=45
Flags:
Resetlogs scn and time scn: 0x0000.00000001 09/13/06 16:17:32
filename D:\ORACLE9I\ARCHIVED\WENHUA_ARC_001_00045
Low scn: 0x0000.00018c98 09/14/06 10:41:18 Next scn: 0x0000.0001db49 10/31/06 09:14:56
Block count=109 Blocksize=512
RECID #41 Recno 41 Record timestamp 09/14/06 10:41:21 Thread=1 Seq#=44
Flags:
Resetlogs scn and time scn: 0x0000.00000001 09/13/06 16:17:32
filename D:\ORACLE9I\ARCHIVED\WENHUA_ARC_001_00044
Low scn: 0x0000.000136af 09/14/06 09:41:12 Next scn: 0x0000.00018c98 09/14/06 10:41:18
Block count=1705 Blocksize=512
RECID #40 Recno 40 Record timestamp 09/14/06 09:41:14 Thread=1 Seq#=43
Flags:
Resetlogs scn and time scn: 0x0000.00000001 09/13/06 16:17:32
filename D:\ORACLE9I\ARCHIVED\WENHUA_ARC_001_00043
Low scn: 0x0000.0001345f 09/14/06 09:41:09 Next scn: 0x0000.000136af 09/14/06 09:41:12
Block count=2046 Blocksize=512
RECID #39 Recno 39 Record timestamp 09/14/06 09:41:11 Thread=1 Seq#=42
Flags:
Resetlogs scn and time scn: 0x0000.00000001 09/13/06 16:17:32
filename D:\ORACLE9I\ARCHIVED\WENHUA_ARC_001_00042
Low scn: 0x0000.000132c5 09/14/06 09:41:03 Next scn: 0x0000.0001345f 09/14/06 09:41:09
Block count=2046 Blocksize=512
RECID #38 Recno 38 Record timestamp 09/14/06 09:41:07 Thread=1 Seq#=41
Flags:
Resetlogs scn and time scn: 0x0000.00000001 09/13/06 16:17:32
filename D:\ORACLE9I\ARCHIVED\WENHUA_ARC_001_00041
Low scn: 0x0000.00013170 09/14/06 09:41:01 Next scn: 0x0000.000132c5 09/14/06 09:41:03
Block count=2046 Blocksize=512
RECID #37 Recno 37 Record timestamp 09/14/06 09:41:05 Thread=1 Seq#=40
Flags:
Resetlogs scn and time scn: 0x0000.00000001 09/13/06 16:17:32
filename D:\ORACLE9I\ARCHIVED\WENHUA_ARC_001_00040
Low scn: 0x0000.00012f3d 09/14/06 09:40:53 Next scn: 0x0000.00013170 09/14/06 09:41:01
Block count=2046 Blocksize=512
RECID #36 Recno 36 Record timestamp 09/14/06 09:40:56 Thread=1 Seq#=39
Flags:
Resetlogs scn and time scn: 0x0000.00000001 09/13/06 16:17:32
filename D:\ORACLE9I\ARCHIVED\WENHUA_ARC_001_00039
Low scn: 0x0000.00012db3 09/14/06 09:40:48 Next scn: 0x0000.00012f3d 09/14/06 09:40:53
Block count=2046 Blocksize=512
RECID #35 Recno 35 Record timestamp 09/14/06 09:40:50 Thread=1 Seq#=38
Flags:
Resetlogs scn and time scn: 0x0000.00000001 09/13/06 16:17:32
filename D:\ORACLE9I\ARCHIVED\WENHUA_ARC_001_00038
Low scn: 0x0000.00012a3d 09/14/06 09:40:41 Next scn: 0x0000.00012db3 09/14/06 09:40:48
Block count=2046 Blocksize=512
***************************************************************************
BACKUP SET RECORDS
***************************************************************************
(blkno = 0x20, size = 40, max = 204, in-use = 0, last-recid= 0)
***************************************************************************
BACKUP PIECE RECORDS
***************************************************************************
(blkno = 0x21, size = 736, max = 210, in-use = 0, last-recid= 0)
***************************************************************************
BACKUP DATAFILE RECORDS
***************************************************************************
(blkno = 0x34, size = 116, max = 211, in-use = 0, last-recid= 0)
***************************************************************************
BACKUP LOG RECORDS
***************************************************************************
(blkno = 0x37, size = 76, max = 107, in-use = 0, last-recid= 0)
***************************************************************************
DATAFILE COPY RECORDS
***************************************************************************
(blkno = 0x38, size = 660, max = 210, in-use = 1, last-recid= 1)
Earliest record:
RECID #1 Recno 1 Record timestamp 11/01/06 10:59:41
File=0 (0) database id=3005787356 block size=8192
Flags:
Filename: C:\CONTROL.CTL
Creation checkpointed at scn: 0x0000.00000000 09/13/06 16:17:33
File header checkpointed at scn: 0x0000.0001f2d4 11/01/06 08:27:54
Resetlogs scn and time scn: 0x0000.00000001 09/13/06 16:17:32
Recovery Fuzzy scn and time scn: 0x0000.00000000 01/01/88 00:00:00
Absolute Fuzzy scn: 0x0000.00000000
Newly-marked media corrupt blocks 0 Total media corrupt blocks 0
Total logically corrupt blocks 0 Block images written to backup 202
Low Offline Range Recid 0
Tag:
Copy does not have keep options.
Latest record:
RECID #1 Recno 1 Record timestamp 11/01/06 10:59:41
File=0 (0) database id=3005787356 block size=8192
Flags:
Filename: C:\CONTROL.CTL
Creation checkpointed at scn: 0x0000.00000000 09/13/06 16:17:33
File header checkpointed at scn: 0x0000.0001f2d4 11/01/06 08:27:54
Resetlogs scn and time scn: 0x0000.00000001 09/13/06 16:17:32
Recovery Fuzzy scn and time scn: 0x0000.00000000 01/01/88 00:00:00
Absolute Fuzzy scn: 0x0000.00000000
Newly-marked media corrupt blocks 0 Total media corrupt blocks 0
Total logically corrupt blocks 0 Block images written to backup 202
Low Offline Range Recid 0
Tag:
Copy does not have keep options.
***************************************************************************
BACKUP DATAFILE CORRUPTION RECORDS
***************************************************************************
(blkno = 0x49, size = 44, max = 185, in-use = 0, last-recid= 0)
***************************************************************************
DATAFILE COPY CORRUPTION RECORDS
***************************************************************************
(blkno = 0x4a, size = 40, max = 204, in-use = 0, last-recid= 0)
***************************************************************************
DELETION RECORDS
***************************************************************************
(blkno = 0x4b, size = 20, max = 408, in-use = 0, last-recid= 0)
***************************************************************************
PROXY COPY RECORDS
***************************************************************************
(blkno = 0x4c, size = 852, max = 210, in-use = 0, last-recid= 0)
***************************************************************************
INCARNATION RECORDS
***************************************************************************
(blkno = 0x65, size = 56, max = 145, in-use = 1, last-recid= 1)
Earliest record:
RECID #1 Recno 1 Record timestamp
Resetlogs scn and time scn: 0x0000.00000001 09/13/06 16:17:32
Previous Resetlogs scn and time scn: 0x0000.00000000 01/01/88 00:00:00
Latest record:
RECID #1 Recno 1 Record timestamp
Resetlogs scn and time scn: 0x0000.00000001 09/13/06 16:17:32
Previous Resetlogs scn and time scn: 0x0000.00000000 01/01/88 00:00:00
*** END OF DUMP ***
