Oracle control file content(控制文件内容)

在启动数据库的过程中,要查看参数文件(spfile/pfile),控制文件(control file)。其中控制文件多有3份,Oracle建议保存在不同位置,可见控制文件的重要性!Eygle(盖国强)大师也在其《深入浅析Oracle》一书中指出,控制文件是数据库的大脑,SYSTEM表空间是数据库的心脏。

接下来,我们一起看看控制文件为何如此重要。

控制文件包含以下信息:

  1. 数据库名称以及数据库创建时间
  2. 所有数据文件和重做日志文件的名称和位置信息
  3. 表空间信息
  4. OFFLINE数据文件信息
  5. 重做日志及归档日志信息
  6. 备份集及备份文件信息
  7. 检查点及SCN信息等

控制文件是二进制文件,无法直接打开阅读,但可通过以下方式转储:

SQL> alter session set events 'immediate trace name controlf level 8';

会话已更改。

SQL> select value from v$diag_info where name='Default Trace File';

VALUE
----------------------------------------------------------------------------
h:\app\marshall\diag\rdbms\orcl\orcl\trace\orcl_ora_3664.trc

打开orcl_ora_3664.trc

(开头部分信息属trace自动生成,在此略去)

DUMP OF CONTROL FILES, Seq # 4108 = 0x100c
V10 STYLE FILE HEADER:
Compatibility Vsn = 186646528=0xb200000
Db ID=1276130704=0x4c103590, Db Name='ORCL' 数据库名称及ID
Activation ID=0=0x0
Control Seq=4108=0x100c, File size=594=0x252
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)
04/13/2011 10:59:28
DB Name "ORCL"
Database flags = 0x00404000 0x00001000
Controlfile Creation Timestamp 04/13/2011 10:59:29
Incmplt recovery scn: 0x0000.00000000
Resetlogs scn: 0x0000.000e5bb0 Resetlogs Timestamp 04/13/2011 10:59:30
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.001dacf4
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.001ce2ebscn: 0x0000.000e5bb0
Activation ID: 1276079759
Controlfile Checkpointed at scn: 0x0000.001dd313 05/03/2011 11:48:36 SCN信息
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 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

***************************************************************************
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:23
low cache rba:(0x43.ad35.0) on disk rba:(0x43.ad8b.0)
on disk scn: 0x0000.001dd347 05/03/2011 11:49:59
resetlogs scn: 0x0000.000e5bb0 04/13/2011 10:59:30
heartbeat: 750133910 mount id: 1277927634
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)=13/ 4/2011
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#:0x43
enabled at scn: 0x0000.000e5bb0 04/13/2011 10:59:30
disabled at scn: 0x0000.00000000 01/01/1988 00:00:00
opened at 05/03/2011 03:47:39 by instance orcl
Checkpointed at scn: 0x0000.001dacf4 05/03/2011 03:47:39
thread:1 rba:(0x43.56ed.10)
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
log history: 66
restore point keep sequence: 0

***************************************************************************
LOG FILE RECORDS 重做日日位置、SCN等信息
***************************************************************************
(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: H:\APP\MARSHALL\ORADATA\ORCL\REDO01.LOG
Thread 1 redo log links: forward: 2 backward: 0
siz: 0x19000 seq: 0x00000043 hws: 0x4 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 1
Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.001d1fe9
Low scn: 0x0000.001d939a 04/30/2011 09:00:43
Next scn: 0xffff.ffffffff 01/01/1988 00:00:00
LOG FILE #2:
name #2: H:\APP\MARSHALL\ORADATA\ORCL\REDO02.LOG
Thread 1 redo log links: forward: 3 backward: 1
siz: 0x19000 seq: 0x00000041 hws: 0x6 bsz: 512 nab: 0x144bb flg: 0x0 dup: 1
Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.001c5cb0
Low scn: 0x0000.001ce2eb 04/28/2011 17:26:37
Next scn: 0x0000.001d1fe9 04/29/2011 23:00:53
LOG FILE #3:
name #1: H:\APP\MARSHALL\ORADATA\ORCL\REDO03.LOG
Thread 1 redo log links: forward: 0 backward: 2
siz: 0x19000 seq: 0x00000042 hws: 0x3 bsz: 512 nab: 0x13bf7 flg: 0x0 dup: 1
Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.001ce2eb
Low scn: 0x0000.001d1fe9 04/29/2011 23:00:53
Next scn: 0x0000.001d939a 04/30/2011 09:00:43

***************************************************************************
DATA FILE RECORDS 数据文件位置及SCN等信息
***************************************************************************
(size = 520, compat size = 520, section max = 100, section in-use = 5,
last-recid= 180, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 11, numrecs = 100)
DATA FILE #1:
name #7: H:\APP\MARSHALL\ORADATA\ORCL\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:509 scn: 0x0000.001dacf4 05/03/2011 03:47:39
Stop scn: 0xffff.ffffffff 04/30/2011 10:58:59
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
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
Offline scn: 0x0000.000e5baf prev_range: 0
Online Checkpointed at scn: 0x0000.000e5bb0 04/13/2011 10:59:30
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
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
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: H:\APP\MARSHALL\ORADATA\ORCL\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:509 scn: 0x0000.001dacf4 05/03/2011 03:47:39
Stop scn: 0xffff.ffffffff 04/30/2011 10:58:59
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
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
Offline scn: 0x0000.000e5baf prev_range: 0
Online Checkpointed at scn: 0x0000.000e5bb0 04/13/2011 10:59:30
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
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
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: H:\APP\MARSHALL\ORADATA\ORCL\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:129 scn: 0x0000.001dacf4 05/03/2011 03:47:39
Stop scn: 0xffff.ffffffff 04/30/2011 10:58:59
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
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
Offline scn: 0x0000.000e5baf prev_range: 0
Online Checkpointed at scn: 0x0000.000e5bb0 04/13/2011 10:59:30
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
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
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: H:\APP\MARSHALL\ORADATA\ORCL\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:506 scn: 0x0000.001dacf4 05/03/2011 03:47:39
Stop scn: 0xffff.ffffffff 04/30/2011 10:58:59
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
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
Offline scn: 0x0000.000e5baf prev_range: 0
Online Checkpointed at scn: 0x0000.000e5bb0 04/13/2011 10:59:30
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
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
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: H:\APP\MARSHALL\ORADATA\ORCL\EXAMPLE01.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:125 scn: 0x0000.001dacf4 05/03/2011 03:47:39
Stop scn: 0xffff.ffffffff 04/30/2011 10:58:59
Creation Checkpointed at scn: 0x0000.000ecc6a 04/13/2011 11:00:46
thread:1 rba:(0x1.6804.10)
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
Offline scn: 0x0000.000ecc6a prev_range: 0
Online Checkpointed at scn: 0x0000.000ecc6f 04/13/2011 11:00:46
thread:1 rba:(0x1.6808.10)
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
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
Plugged readony: NO
Plugin scnscn: 0x0000.000eabdb
Plugin resetlogs scn/timescn: 0x0000.000e5bb0 04/13/2011 10:59:30
Foreign creation scn/timescn: 0x0000.000e5e19 04/02/2010 14:24:02
Foreign checkpoint scn/timescn: 0x0000.000eabda 04/02/2010 14:27:02
Online move state: 0

***************************************************************************
TEMP FILE RECORDS 临时位置文件及SCN等信息
***************************************************************************
(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: H:\APP\MARSHALL\ORADATA\ORCL\TEMP01.DBF
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.000e5c67 04/13/2011 10:59:52

***************************************************************************
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 EXAMPLE: 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)
orcl 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: 32673665 us, Times measured: 4
File open time: Avg: 151032 us, Times measured: 16
Log block read time: Avg: 20 us, Times measured: 65536
Data block read/claim time: Avg: 717 us, Times measured: 4083
Data block write time: Avg: 227 us
1000 change vector apply time: Avg: 133207 us, Times measured: 30
Ratio Information:
# of log blocks measured: 481759
# of data blocks measured: 32256
# of change vectors measured: 1375761

***************************************************************************
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
***************************************************************************
(size = 104, compat size = 104, section max = 64, section in-use = 6,
last-recid= 0, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 259, numrecs = 64)
ACM record=1
id=0
descrip=ACM unit testing operation
attr=1
ver=0
exptime=0
cpid=0
cinst=0
phase=1
ACM record=2
id=1
descrip=LSB Database Guard
attr=1
ver=0
exptime=0
cpid=0
cinst=0
phase=1
ACM record=3
id=2
descrip=Supplemental Log Data DDL
attr=1
ver=0
exptime=0
cpid=0
cinst=0
phase=1
ACM record=4
id=3
descrip=LSB Role Change Support
attr=1
ver=0
exptime=0
cpid=0
cinst=0
phase=1
ACM record=5
id=4
descrip=RFS block and kill across RAC
attr=1
ver=0
exptime=0
cpid=0
cinst=0
phase=1
ACM record=6
id=5
descrip=RAC-wide SGA
attr=1
ver=0
exptime=0
cpid=0
cinst=0
phase=1

***************************************************************************
LOG FILE HISTORY RECORDS
***************************************************************************
(size = 56, compat size = 56, section max = 292, section in-use = 66,
last-recid= 66, old-recno = 1, last-recno = 66)
(extent = 1, blkno = 95, numrecs = 292)
Earliest record:
RECID #1 Recno 1 Record timestamp 04/13/11 11:02:17 Thread=1 Seq#=1 Link-Recid=0 kccic-Recid=2
Low scn: 0x0000.000e5bb0 04/13/11 10:59:30 Next scn: 0x0000.000eeaed
Latest record:
RECID #66 Recno 66 Record timestamp 04/30/11 09:00:43 Thread=1 Seq#=66 Link-Recid=65 kccic-Recid=2
Low scn: 0x0000.001d1fe9 04/29/11 23:00:53 Next scn: 0x0000.001d939a
RECID #65 Recno 65 Record timestamp 04/29/11 23:00:53 Thread=1 Seq#=65 Link-Recid=64 kccic-Recid=2
Low scn: 0x0000.001ce2eb 04/28/11 17:26:37 Next scn: 0x0000.001d1fe9
RECID #64 Recno 64 Record timestamp 04/28/11 17:26:37 Thread=1 Seq#=64 Link-Recid=63 kccic-Recid=2
Low scn: 0x0000.001c5cb0 04/27/11 22:33:07 Next scn: 0x0000.001ce2eb
RECID #63 Recno 63 Record timestamp 04/27/11 22:33:07 Thread=1 Seq#=63 Link-Recid=62 kccic-Recid=2
Low scn: 0x0000.001c3d0b 04/27/11 22:05:27 Next scn: 0x0000.001c5cb0
RECID #62 Recno 62 Record timestamp 04/27/11 22:05:27 Thread=1 Seq#=62 Link-Recid=61 kccic-Recid=2
Low scn: 0x0000.001c152a 04/27/11 22:01:44 Next scn: 0x0000.001c3d0b
RECID #61 Recno 61 Record timestamp 04/27/11 22:01:45 Thread=1 Seq#=61 Link-Recid=60 kccic-Recid=2
Low scn: 0x0000.001b98ad 04/26/11 19:14:56 Next scn: 0x0000.001c152a
RECID #60 Recno 60 Record timestamp 04/26/11 19:14:57 Thread=1 Seq#=60 Link-Recid=59 kccic-Recid=2
Low scn: 0x0000.001b75ff 04/26/11 18:52:39 Next scn: 0x0000.001b98ad
RECID #59 Recno 59 Record timestamp 04/26/11 18:52:39 Thread=1 Seq#=59 Link-Recid=58 kccic-Recid=2
Low scn: 0x0000.001b5a10 04/26/11 18:52:07 Next scn: 0x0000.001b75ff
RECID #58 Recno 58 Record timestamp 04/26/11 18:52:07 Thread=1 Seq#=58 Link-Recid=57 kccic-Recid=2
Low scn: 0x0000.001b4183 04/26/11 18:51:57 Next scn: 0x0000.001b5a10
RECID #57 Recno 57 Record timestamp 04/26/11 18:51:57 Thread=1 Seq#=57 Link-Recid=56 kccic-Recid=2
Low scn: 0x0000.001b2920 04/26/11 18:51:44 Next scn: 0x0000.001b4183
RECID #56 Recno 56 Record timestamp 04/26/11 18:51:44 Thread=1 Seq#=56 Link-Recid=55 kccic-Recid=2
Low scn: 0x0000.001b0e3f 04/26/11 18:51:41 Next scn: 0x0000.001b2920
RECID #55 Recno 55 Record timestamp 04/26/11 18:51:41 Thread=1 Seq#=55 Link-Recid=54 kccic-Recid=2
Low scn: 0x0000.001a7ca9 04/21/11 17:23:05 Next scn: 0x0000.001b0e3f
RECID #54 Recno 54 Record timestamp 04/21/11 17:23:05 Thread=1 Seq#=54 Link-Recid=53 kccic-Recid=2
Low scn: 0x0000.001a42a7 04/21/11 15:11:50 Next scn: 0x0000.001a7ca9
RECID #53 Recno 53 Record timestamp 04/21/11 15:11:50 Thread=1 Seq#=53 Link-Recid=52 kccic-Recid=2
Low scn: 0x0000.001a0268 04/21/11 15:08:59 Next scn: 0x0000.001a42a7
RECID #52 Recno 52 Record timestamp 04/21/11 15:08:59 Thread=1 Seq#=52 Link-Recid=51 kccic-Recid=2
Low scn: 0x0000.0019f5d8 04/21/11 15:08:52 Next scn: 0x0000.001a0268
RECID #51 Recno 51 Record timestamp 04/21/11 15:08:52 Thread=1 Seq#=51 Link-Recid=50 kccic-Recid=2
Low scn: 0x0000.00198906 04/19/11 22:21:59 Next scn: 0x0000.0019f5d8
RECID #50 Recno 50 Record timestamp 04/19/11 22:21:59 Thread=1 Seq#=50 Link-Recid=49 kccic-Recid=2
Low scn: 0x0000.001977bf 04/19/11 22:21:46 Next scn: 0x0000.00198906
RECID #49 Recno 49 Record timestamp 04/19/11 22:21:46 Thread=1 Seq#=49 Link-Recid=48 kccic-Recid=2
Low scn: 0x0000.00195ddd 04/19/11 22:21:37 Next scn: 0x0000.001977bf
RECID #48 Recno 48 Record timestamp 04/19/11 22:21:37 Thread=1 Seq#=48 Link-Recid=47 kccic-Recid=2
Low scn: 0x0000.001944a1 04/19/11 22:21:29 Next scn: 0x0000.00195ddd
RECID #47 Recno 47 Record timestamp 04/19/11 22:21:29 Thread=1 Seq#=47 Link-Recid=46 kccic-Recid=2
Low scn: 0x0000.00192ba8 04/19/11 22:21:21 Next scn: 0x0000.001944a1
RECID #46 Recno 46 Record timestamp 04/19/11 22:21:21 Thread=1 Seq#=46 Link-Recid=45 kccic-Recid=2
Low scn: 0x0000.00191304 04/19/11 22:21:11 Next scn: 0x0000.00192ba8
RECID #45 Recno 45 Record timestamp 04/19/11 22:21:11 Thread=1 Seq#=45 Link-Recid=44 kccic-Recid=2
Low scn: 0x0000.0018fb5d 04/19/11 22:20:56 Next scn: 0x0000.00191304
RECID #44 Recno 44 Record timestamp 04/19/11 22:20:56 Thread=1 Seq#=44 Link-Recid=43 kccic-Recid=2
Low scn: 0x0000.0018e308 04/19/11 22:20:43 Next scn: 0x0000.0018fb5d
RECID #43 Recno 43 Record timestamp 04/19/11 22:20:43 Thread=1 Seq#=43 Link-Recid=42 kccic-Recid=2
Low scn: 0x0000.0018ca74 04/19/11 22:20:28 Next scn: 0x0000.0018e308
RECID #42 Recno 42 Record timestamp 04/19/11 22:20:28 Thread=1 Seq#=42 Link-Recid=41 kccic-Recid=2
Low scn: 0x0000.0018b36d 04/19/11 22:19:57 Next scn: 0x0000.0018ca74
RECID #41 Recno 41 Record timestamp 04/19/11 22:19:57 Thread=1 Seq#=41 Link-Recid=40 kccic-Recid=2
Low scn: 0x0000.00189be0 04/19/11 22:19:47 Next scn: 0x0000.0018b36d
RECID #40 Recno 40 Record timestamp 04/19/11 22:19:47 Thread=1 Seq#=40 Link-Recid=39 kccic-Recid=2
Low scn: 0x0000.00187b13 04/19/11 22:06:10 Next scn: 0x0000.00189be0
RECID #39 Recno 39 Record timestamp 04/19/11 22:06:10 Thread=1 Seq#=39 Link-Recid=38 kccic-Recid=2
Low scn: 0x0000.0018330e 04/19/11 18:00:07 Next scn: 0x0000.00187b13
RECID #38 Recno 38 Record timestamp 04/19/11 18:00:07 Thread=1 Seq#=38 Link-Recid=37 kccic-Recid=2
Low scn: 0x0000.00180276 04/19/11 16:35:43 Next scn: 0x0000.0018330e
RECID #37 Recno 37 Record timestamp 04/19/11 16:35:43 Thread=1 Seq#=37 Link-Recid=36 kccic-Recid=2
Low scn: 0x0000.0017b6fe 04/19/11 16:32:36 Next scn: 0x0000.00180276
RECID #36 Recno 36 Record timestamp 04/19/11 16:32:36 Thread=1 Seq#=36 Link-Recid=35 kccic-Recid=2
Low scn: 0x0000.00179fe0 04/19/11 16:32:27 Next scn: 0x0000.0017b6fe
RECID #35 Recno 35 Record timestamp 04/19/11 16:32:27 Thread=1 Seq#=35 Link-Recid=34 kccic-Recid=2
Low scn: 0x0000.001787b7 04/19/11 16:32:19 Next scn: 0x0000.00179fe0
RECID #34 Recno 34 Record timestamp 04/19/11 16:32:19 Thread=1 Seq#=34 Link-Recid=33 kccic-Recid=2
Low scn: 0x0000.0017709e 04/19/11 16:32:15 Next scn: 0x0000.001787b7
RECID #33 Recno 33 Record timestamp 04/19/11 16:32:15 Thread=1 Seq#=33 Link-Recid=32 kccic-Recid=2
Low scn: 0x0000.00175fb9 04/19/11 16:17:08 Next scn: 0x0000.0017709e
RECID #32 Recno 32 Record timestamp 04/19/11 16:17:08 Thread=1 Seq#=32 Link-Recid=31 kccic-Recid=2
Low scn: 0x0000.00172ee0 04/19/11 16:10:17 Next scn: 0x0000.00175fb9
RECID #31 Recno 31 Record timestamp 04/19/11 16:10:17 Thread=1 Seq#=31 Link-Recid=30 kccic-Recid=2
Low scn: 0x0000.00170b88 04/19/11 16:04:11 Next scn: 0x0000.00172ee0
RECID #30 Recno 30 Record timestamp 04/19/11 16:04:11 Thread=1 Seq#=30 Link-Recid=29 kccic-Recid=2
Low scn: 0x0000.0016f1c2 04/19/11 16:04:06 Next scn: 0x0000.00170b88
RECID #29 Recno 29 Record timestamp 04/19/11 16:04:06 Thread=1 Seq#=29 Link-Recid=28 kccic-Recid=2
Low scn: 0x0000.0016a80e 04/19/11 15:48:51 Next scn: 0x0000.0016f1c2
RECID #28 Recno 28 Record timestamp 04/19/11 15:48:51 Thread=1 Seq#=28 Link-Recid=27 kccic-Recid=2
Low scn: 0x0000.0016435c 04/18/11 18:50:13 Next scn: 0x0000.0016a80e
RECID #27 Recno 27 Record timestamp 04/18/11 18:50:14 Thread=1 Seq#=27 Link-Recid=26 kccic-Recid=2
Low scn: 0x0000.00162245 04/18/11 18:45:43 Next scn: 0x0000.0016435c
RECID #26 Recno 26 Record timestamp 04/18/11 18:45:43 Thread=1 Seq#=26 Link-Recid=25 kccic-Recid=2
Low scn: 0x0000.001606b7 04/18/11 18:45:30 Next scn: 0x0000.00162245
RECID #25 Recno 25 Record timestamp 04/18/11 18:45:30 Thread=1 Seq#=25 Link-Recid=24 kccic-Recid=2
Low scn: 0x0000.0015ec92 04/18/11 18:45:09 Next scn: 0x0000.001606b7
RECID #24 Recno 24 Record timestamp 04/18/11 18:45:09 Thread=1 Seq#=24 Link-Recid=23 kccic-Recid=2
Low scn: 0x0000.0015d48e 04/18/11 18:44:59 Next scn: 0x0000.0015ec92
RECID #23 Recno 23 Record timestamp 04/18/11 18:44:59 Thread=1 Seq#=23 Link-Recid=22 kccic-Recid=2
Low scn: 0x0000.0015ba19 04/18/11 18:44:38 Next scn: 0x0000.0015d48e
RECID #22 Recno 22 Record timestamp 04/18/11 18:44:38 Thread=1 Seq#=22 Link-Recid=21 kccic-Recid=2
Low scn: 0x0000.0015a2c7 04/18/11 18:44:20 Next scn: 0x0000.0015ba19
RECID #21 Recno 21 Record timestamp 04/18/11 18:44:20 Thread=1 Seq#=21 Link-Recid=20 kccic-Recid=2
Low scn: 0x0000.001589d3 04/18/11 18:43:51 Next scn: 0x0000.0015a2c7
RECID #20 Recno 20 Record timestamp 04/18/11 18:43:51 Thread=1 Seq#=20 Link-Recid=19 kccic-Recid=2
Low scn: 0x0000.00157064 04/18/11 18:43:35 Next scn: 0x0000.001589d3
RECID #19 Recno 19 Record timestamp 04/18/11 18:43:35 Thread=1 Seq#=19 Link-Recid=18 kccic-Recid=2
Low scn: 0x0000.00152a36 04/18/11 18:38:18 Next scn: 0x0000.00157064
RECID #18 Recno 18 Record timestamp 04/18/11 18:38:18 Thread=1 Seq#=18 Link-Recid=17 kccic-Recid=2
Low scn: 0x0000.0014cfb2 04/15/11 21:31:21 Next scn: 0x0000.00152a36
RECID #17 Recno 17 Record timestamp 04/15/11 21:31:21 Thread=1 Seq#=17 Link-Recid=16 kccic-Recid=2
Low scn: 0x0000.00146f58 04/15/11 05:16:13 Next scn: 0x0000.0014cfb2
RECID #16 Recno 16 Record timestamp 04/15/11 05:16:14 Thread=1 Seq#=16 Link-Recid=15 kccic-Recid=2
Low scn: 0x0000.0013f6e4 04/14/11 22:17:32 Next scn: 0x0000.00146f58
RECID #15 Recno 15 Record timestamp 04/14/11 22:17:32 Thread=1 Seq#=15 Link-Recid=14 kccic-Recid=2
Low scn: 0x0000.0013dc77 04/14/11 22:02:00 Next scn: 0x0000.0013f6e4
RECID #14 Recno 14 Record timestamp 04/14/11 22:02:00 Thread=1 Seq#=14 Link-Recid=13 kccic-Recid=2
Low scn: 0x0000.001364b6 04/14/11 15:00:42 Next scn: 0x0000.0013dc77
RECID #13 Recno 13 Record timestamp 04/14/11 15:00:42 Thread=1 Seq#=13 Link-Recid=12 kccic-Recid=2
Low scn: 0x0000.0012e291 04/14/11 07:18:36 Next scn: 0x0000.001364b6
RECID #12 Recno 12 Record timestamp 04/14/11 07:18:37 Thread=1 Seq#=12 Link-Recid=11 kccic-Recid=2
Low scn: 0x0000.00125918 04/13/11 22:28:42 Next scn: 0x0000.0012e291
RECID #11 Recno 11 Record timestamp 04/13/11 22:28:42 Thread=1 Seq#=11 Link-Recid=10 kccic-Recid=2
Low scn: 0x0000.0011ed8d 04/13/11 22:08:55 Next scn: 0x0000.00125918
RECID #10 Recno 10 Record timestamp 04/13/11 22:08:56 Thread=1 Seq#=10 Link-Recid=9 kccic-Recid=2
Low scn: 0x0000.00118ca8 04/13/11 17:59:34 Next scn: 0x0000.0011ed8d
RECID #9 Recno 9 Record timestamp 04/13/11 17:59:34 Thread=1 Seq#=9 Link-Recid=8 kccic-Recid=2
Low scn: 0x0000.00111ac1 04/13/11 14:46:24 Next scn: 0x0000.00118ca8
RECID #8 Recno 8 Record timestamp 04/13/11 14:46:24 Thread=1 Seq#=8 Link-Recid=7 kccic-Recid=2
Low scn: 0x0000.00109bf5 04/13/11 12:36:45 Next scn: 0x0000.00111ac1
RECID #7 Recno 7 Record timestamp 04/13/11 12:36:45 Thread=1 Seq#=7 Link-Recid=6 kccic-Recid=2
Low scn: 0x0000.001058ec 04/13/11 12:31:46 Next scn: 0x0000.00109bf5
RECID #6 Recno 6 Record timestamp 04/13/11 12:31:46 Thread=1 Seq#=6 Link-Recid=5 kccic-Recid=2
Low scn: 0x0000.000faf2b 04/13/11 11:08:00 Next scn: 0x0000.001058ec
RECID #5 Recno 5 Record timestamp 04/13/11 11:08:00 Thread=1 Seq#=5 Link-Recid=4 kccic-Recid=2
Low scn: 0x0000.000f82ff 04/13/11 11:03:53 Next scn: 0x0000.000faf2b
RECID #4 Recno 4 Record timestamp 04/13/11 11:03:54 Thread=1 Seq#=4 Link-Recid=3 kccic-Recid=2
Low scn: 0x0000.000f3f2f 04/13/11 11:03:23 Next scn: 0x0000.000f82ff
RECID #3 Recno 3 Record timestamp 04/13/11 11:03:23 Thread=1 Seq#=3 Link-Recid=2 kccic-Recid=2
Low scn: 0x0000.000f0581 04/13/11 11:02:34 Next scn: 0x0000.000f3f2f

***************************************************************************
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 = 1,
last-recid= 1, old-recno = 1, last-recno = 1)
(extent = 1, blkno = 113, numrecs = 200)
Earliest record:
RECID #1 Recno 1 Record timestamp 04/13/11 11:00:13
File=5 (5) database id=4043945450 block size=8192
Flags: <deleted> <scanned> <same_endianess>
Filename:
Creation checkpointed at scn: 0x0000.000e5e19 04/02/10 14:24:02
File header checkpointed at scn: 0x0000.000eabda 04/02/10 14:27:02
Resetlogs scn and time scn: 0x0000.00000001 04/02/10 13:18:34
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 12800
Low Offline Range Recid 0
Tag:
Copy does not have keep options.
Plugin scnscn: 0x0000.00000000
Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/88 00:00:00
Latest record:
RECID #1 Recno 1 Record timestamp 04/13/11 11:00:13
File=5 (5) database id=4043945450 block size=8192
Flags: <deleted> <scanned> <same_endianess>
Filename:
Creation checkpointed at scn: 0x0000.000e5e19 04/02/10 14:24:02
File header checkpointed at scn: 0x0000.000eabda 04/02/10 14:27:02
Resetlogs scn and time scn: 0x0000.00000001 04/02/10 13:18:34
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 12800
Low Offline Range Recid 0
Tag:
Copy does not have keep options.
Plugin scnscn: 0x0000.00000000
Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/88 00:00:00

***************************************************************************
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 = 1,
last-recid= 1, old-recno = 1, last-recno = 1)
(extent = 1, blkno = 124, numrecs = 818)
Earliest record:
RECID #1 Recno 1 Record timestamp 04/13/11 11:00:14
Object type=16 Object recid=1 Object timestamp= 04/13/11 11:00:13
Latest record:
RECID #1 Recno 1 Record timestamp 04/13/11 11:00:14
Object type=16 Object recid=1 Object timestamp= 04/13/11 11:00:13

***************************************************************************
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/13/11 10:59:30
Previous Resetlogs scn and time scn: 0x0000.00000001 04/02/10 13:18:34
Incarnation (parent inc#, flag)=(1, 2)
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)

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

如果做物理迁移,需要重建控制文件,在另一篇里详细描述。

参考资料:《深入解析Oracle》 盖国强

总结:由上可见,控制文件记录了数据库的基本也是核心的信息,一定要保证控制文件的安全。

普人特福的博客cnzz&51la for wordpress,cnzz for wordpress,51la for wordpress