控制文件包含的内容

1.Control File Contents

A control file contains the following entries:

• Database name and identifier

• Time stamp of database creation

• Tablespace names

• Names and locations of data files and redo log files

• Current redo log file sequence number

• Checkpoint information

• Begin and end of undo segments

• Redo log archive information

• Backup information

2.由于控制文件是二进制文件不能打开看所以把控制文件dump到trace文件中查看它的内容

利用oradebug把控制文件dump到trace文件中去

SQL> oradebug setmypid

已处理的语句

SQL> oradebug dump controlf 3

已处理的语句

SQL>

在user_dump_dest参数指定的目录下可以看到生成的mdsp_ora_2924.trc文件，用户记事本打开看

内容如下：

***************************************************************************

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)

 04/24/2012 23:34:45

 DB Name "MDSP"  ----数据库名字

 Database flags = 0x40404000 0x00001000

 Controlfile Creation Timestamp  04/24/2012 23:34:46 ---创建时间

 Incmplt recovery scn: 0x0000.00000000

 Resetlogs scn: 0x0000.000e5bb0 Resetlogs Timestamp  04/24/2012 23:34:48

 Prior resetlogs scn: 0x0000.00000001 Prior resetlogs Timestamp  04/02/2010 13:18:34

 Redo Version: compatible=0xb200000

 #Data files = 5, #Online files = 5

 Database checkpoint: Thread=1 scn: 0x0000.001e44fb

 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

Max log members = 3, Max data members = 1

 Arch list: Head=0, Tail=0, Force scn: 0x0000.001c4cd6scn: 0x0000.000e5bb0

 Activation ID: 663167509

 Controlfile Checkpointed at scn:  0x0000.001e68ab 06/03/2012 20:51:10

 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:36

low cache rba:(0x28.7f39.0) on disk rba:(0x28.7f8c.0)

on disk scn: 0x0000.001e68ae 06/03/2012 20:51:10

resetlogs scn: 0x0000.000e5bb0 04/24/2012 23:34:48

heartbeat: 785041126 mount id: 666689408

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 = 900, compat size = 900, section max = 1, section in-use = 1,

  last-recid= 0, old-recno = 0, last-recno = 0)

 (extent = 1, blkno = 140, numrecs = 1)

Control AutoBackup date(dd/mm/yyyy)=24/ 4/2012

Next AutoBackup sequence= 0

Database recovery target inc#:2, Last open inc#:2

flg:0x0, flag:0x0

Change tracking state=0, file index=0, checkpoint count=0scn: 0x0000.00000000

Flashback log count=0, block count=0

Desired flashback log size=0 blocks

Oldest guarantee restore point=0

Highest thread enable/disable scn: 0x0000.00000000

Number of Open thread with finite next SCN in last log: 0

Number of half-enabled redo threads: 0

Sum of absolute file numbers for files currently being moved online: 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:1 last used seq#:0x28 ---当前redolog

 enabled at scn: 0x0000.000e5bb0 04/24/2012 23:34:48

 disabled at scn: 0x0000.00000000 01/01/1988 00:00:00

 opened at 06/03/2012 19:10:02 by instance mdsp

Checkpointed at scn:  0x0000.001e44fb 06/03/2012 19:10:02

 thread:1 rba:(0x28.2.10)

 enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000

  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

log history: 39

 restore point keep sequence: 0

***************************************************************************

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 #3: D:\APP\WWANG\ORADATA\MDSP\REDO01.LOG ---日志文件信息及位置

 Thread 1 redo log links: forward: 2 backward: 0

 siz: 0x19000 seq: 0x00000028 hws: 0x2 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 1 – 日志文件的sequence

 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.001dd0b2

 Low scn: 0x0000.001e44fa 06/03/2012 19:10:02

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

LOG FILE #2:

  name #2: D:\APP\WWANG\ORADATA\MDSP\REDO02.LOG

 Thread 1 redo log links: forward: 3 backward: 1

 siz: 0x19000 seq: 0x00000026 hws: 0xa bsz: 512 nab: 0x375f flg: 0x0 dup: 1

 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.001d0124

 Low scn: 0x0000.001d5bc6 06/01/2012 18:13:40

 Next scn: 0x0000.001dd0b2 06/02/2011 21:31:46

LOG FILE #3:

  name #1: D:\APP\WWANG\ORADATA\MDSP\REDO03.LOG

 Thread 1 redo log links: forward: 0 backward: 2

 siz: 0x19000 seq: 0x00000027 hws: 0x11 bsz: 512 nab: 0xb932 flg: 0x0 dup: 1

 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.001d5bc6

 Low scn: 0x0000.001dd0b2 06/02/2011 21:31:46

 Next scn: 0x0000.001e44fa 06/03/2012 19:10:02

***************************************************************************

DATA FILE RECORDS

***************************************************************************

 (size = 520, compat size = 520, section max = 100, section in-use = 5,

  last-recid= 37, old-recno = 0, last-recno = 0)

 (extent = 1, blkno = 11, numrecs = 100)

DATA FILE #1:

  name #7: D:\APP\WWANG\ORADATA\MDSP\SYSTEM01.DBF –数据文件的信息及位置

creation size=0 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:499 scn: 0x0000.001e44fb 06/03/2012 19:10:02

 Stop scn: 0xffff.ffffffff 06/02/2012 23:35:15

 Creation Checkpointed at scn:  0x0000.00000007 04/02/2010 13:18:37

 thread:0 rba:(0x0.0.0)

 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000

  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

Offline scn: 0x0000.000e5baf prev_range: 0

 Online Checkpointed at scn:  0x0000.000e5bb0 04/24/2012 23:34:48

 thread:1 rba:(0x1.2.0)

 enabled  threads:  01000000 00000000 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

 Plugged readony: NO

 Plugin scnscn: 0x0000.00000000

 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00

 Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00

 Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00

 Online move state: 0

DATA FILE #2:

  name #6: D:\APP\WWANG\ORADATA\MDSP\SYSAUX01.DBF

creation size=0 block size=8192 status=0xe head=6 tail=6 dup=1

 tablespace 1, index=2 krfil=2 prev_file=0

 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00

 Checkpoint cnt:499 scn: 0x0000.001e44fb 06/03/2012 19:10:02

 Stop scn: 0xffff.ffffffff 06/02/2012 23:35:15

 Creation Checkpointed at scn:  0x0000.00000871 04/02/2010 13:18:41

 thread:0 rba:(0x0.0.0)

 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000

  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

 

 Offline scn: 0x0000.000e5baf prev_range: 0

 Online Checkpointed at scn:  0x0000.000e5bb0 04/24/2012 23:34:48

 thread:1 rba:(0x1.2.0)

 enabled  threads:  01000000 00000000 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

 Plugged readony: NO

 Plugin scnscn: 0x0000.00000000

 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00

 Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00

 Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00

 Online move state: 0

DATA FILE #3:

  name #5: D:\APP\WWANG\ORADATA\MDSP\UNDOTBS01.DBF

creation size=0 block size=8192 status=0xe head=5 tail=5 dup=1

 tablespace 2, index=3 krfil=3 prev_file=0

 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00

 Checkpoint cnt:119 scn: 0x0000.001e44fb 06/03/2012 19:10:02

 Stop scn: 0xffff.ffffffff 06/02/2012 23:35:15

 Creation Checkpointed at scn:  0x0000.000e50e7 04/02/2010 14:21:45

 thread:0 rba:(0x0.0.0)

 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000

  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

 

 Offline scn: 0x0000.000e5baf prev_range: 0

 Online Checkpointed at scn:  0x0000.000e5bb0 04/24/2012 23:34:48

 thread:1 rba:(0x1.2.0)

 enabled  threads:  01000000 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

 Plugged readony: NO

 Plugin scnscn: 0x0000.00000000

 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00

 Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00

 Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00

 Online move state: 0

DATA FILE #4:

  name #4: D:\APP\WWANG\ORADATA\MDSP\USERS01.DBF

creation size=0 block size=8192 status=0xe head=4 tail=4 dup=1

 tablespace 4, index=4 krfil=4 prev_file=0

 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00

 Checkpoint cnt:496 scn: 0x0000.001e44fb 06/03/2012 19:10:02

 Stop scn: 0xffff.ffffffff 06/02/2012 23:35:15

 Creation Checkpointed at scn:  0x0000.00004661 04/02/2010 13:18:52

 thread:0 rba:(0x0.0.0)

 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000

  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

Offline scn: 0x0000.000e5baf prev_range: 0

 Online Checkpointed at scn:  0x0000.000e5bb0 04/24/2012 23:34:48

 thread:1 rba:(0x1.2.0)

 enabled  threads:  01000000 00000000 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

 Plugged readony: NO

 Plugin scnscn: 0x0000.00000000

 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00

 Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00

 Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00

 Online move state: 0

DATA FILE #5:

  name #9: D:\APP\WWANG\ORADATA\MDSP\IMUSE01.DBF

creation size=12800 block size=8192 status=0xe head=9 tail=9 dup=1

 tablespace 6, index=6 krfil=5 prev_file=0

 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00

 Checkpoint cnt:106 scn: 0x0000.001e44fb 06/03/2012 19:10:02

 Stop scn: 0xffff.ffffffff 06/02/2012 23:35:15

 Creation Checkpointed at scn:  0x0000.000f9f2a 04/26/2012 20:18:34

 thread:1 rba:(0x6.33ee.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

 Hot Backup end marker scn: 0x0000.00000000

 aux_file is NOT DEFINED

 Plugged readony: NO

 Plugin scnscn: 0x0000.00000000

 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00

 Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00

 Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00

 Online move state: 0

***************************************************************************

TEMP FILE RECORDS

***************************************************************************

 (size = 56, compat size = 56, section max = 100, section in-use = 1,

  last-recid= 1, old-recno = 0, last-recno = 0)

 (extent = 1, blkno = 90, numrecs = 100)

TEMP FILE #1: External File #201

  name #8: D:\APP\WWANG\ORADATA\MDSP\TEMP01.DBF ---temp文件的信息及位置

creation size=2560 block size=8192 status=0x1e head=8 tail=8 dup=1

 tablespace 3, index=5 krfil=1 prev_file=0

 unrecoverable scn: 0x0000.000e5c7e 04/24/2012 23:35:34

***************************************************************************

TABLESPACE RECORDS

***************************************************************************

 (size = 68, compat size = 68, section max = 100, section in-use = 6,

  last-recid= 2, old-recno = 0, last-recno = 0)

 (extent = 1, blkno = 89, 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 SYSAUX: 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 UNDOTBS1: 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 #4 USERS: recno=4

 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 #3 TEMP: recno=5

 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 #6 IMUSE01: 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

 

***************************************************************************

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 = 91, 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 = 142, 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 = 159, numrecs = 8)

mdsp 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 = 160, numrecs = 8)

MTTR record for thread 1

MTTR statistics status: 3

Init time: Avg: 17926417 us, Times measured: 4

File open time: Avg: 58894 us, Times measured: 19

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: 89876 us, Times measured: 38

Ratio Information:

# of log blocks measured: 184779

# of data blocks measured: 7700

# of change vectors measured: 429233

***************************************************************************

STANDBY DATABASE MAP RECORDS

***************************************************************************

 (size = 400, compat size = 400, section max = 31, section in-use = 31,

  last-recid= 0, old-recno = 0, last-recno = 0)

 (extent = 1, blkno = 163, numrecs = 31)

***************************************************************************

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 = 164, numrecs = 2048)

***************************************************************************

ACM SERVICE RECORDS

***************************************************************************

***************************************************************************

LOG FILE HISTORY RECORDS

***************************************************************************

 (size = 56, compat size = 56, section max = 292, section in-use = 39,

  last-recid= 39, old-recno = 1, last-recno = 39)

 (extent = 1, blkno = 95, numrecs = 292)

Earliest record:

 RECID #1 Recno 1 Record timestamp  04/24/12 23:36:00 Thread=1 Seq#=1 Link-Recid=0 kccic-Recid=2

  Low scn: 0x0000.000e5bb0 04/24/12 23:34:48 Next scn: 0x0000.000e6eb3

Latest record:

 RECID #39 Recno 39 Record timestamp  06/03/12 19:10:02 Thread=1 Seq#=39 Link-Recid=38 kccic-Recid=2

  Low scn: 0x0000.001dd0b2 06/02/11 21:31:46 Next scn: 0x0000.001e44fa

***************************************************************************

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 = 96, 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 = 98, numrecs = 28)

***************************************************************************

FOREIGN ARCHIVED LOG RECORDS

***************************************************************************

 (size = 604, compat size = 604, section max = 1002, section in-use = 0,

  last-recid= 0, old-recno = 0, last-recno = 0)

 (extent = 1, blkno = 260, numrecs = 1002)

***************************************************************************

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 = 99, 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 = 100, numrecs = 200)

***************************************************************************

BACKUP DATAFILE RECORDS

***************************************************************************

 (size = 200, compat size = 200, section max = 245, section in-use = 0,

  last-recid= 0, old-recno = 0, last-recno = 0)

 (extent = 1, blkno = 109, numrecs = 245)

***************************************************************************

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 = 112, numrecs = 215)

***************************************************************************

DATAFILE COPY 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 = 113, numrecs = 200)

***************************************************************************

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 = 122, 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 = 123, 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 = 124, numrecs = 818)

***************************************************************************

PROXY COPY RECORDS

***************************************************************************

 (size = 928, compat size = 928, section max = 246, section in-use = 0,

  last-recid= 0, old-recno = 0, last-recno = 0)

 (extent = 1, blkno = 125, numrecs = 246)

***************************************************************************

INCARNATION RECORDS

***************************************************************************

 (size = 56, compat size = 56, section max = 292, section in-use = 2,

  last-recid= 2, old-recno = 1, last-recno = 2)

 (extent = 1, blkno = 141, numrecs = 292)

Earliest record:

 RECID #1 Recno 1 Record timestamp

  Resetlogs scn and time scn: 0x0000.00000001 04/02/10 13:18:34

  Previous Resetlogs scn and time scn: 0x0000.00000000 01/01/88 00:00:00

 Incarnation (parent inc#, flag)=(0, 0)

Latest record:

 RECID #2 Recno 2 Record timestamp

  Resetlogs scn and time scn: 0x0000.000e5bb0 04/24/12 23:34:48

  Previous Resetlogs scn and time scn: 0x0000.00000001 04/02/10 13:18:34

 Incarnation (parent inc#, flag)=(1, 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 = 158, 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 = 161, 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 = 191, numrecs = 2083)

***************************************************************************

DATABASE BLOCK CORRUPTION RECORDS

***************************************************************************

 (size = 80, compat size = 80, section max = 8384, section in-use = 0,

  last-recid= 0, old-recno = 0, last-recno = 0)

 (extent = 1, blkno = 218, numrecs = 8384)

*** END OF DUMP ***

*** 2012-06-03 20:51:23.221

Oradebug command 'dump controlf 3' console output: <none>