ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > Oracle > oracle controlfile理解

oracle controlfile理解

原创 Oracle 作者：tolilong 时间：2014-01-16 16:31:33 0 删除 编辑

select * from v$controlfile
select * from v$parameter where name like '%control%'

查看controlfile文件所在位置
 select * from v$controlfile_record_section

 查看controlfile中包含的大概信息

 

[oracle@primary ~]$ strings /u01/oradata/wlcsp/control01.ctl | more}|{z
WLCSP
P\91y&
1R\91 l
O\91WLCSP
R\91
O\91i
O\91WLCSP
R\91
O\91i
wlcsp
wlcsp
R\91em
R\91em
/u01/oradata/wlcsp/redo03.log
/u01/oradata/wlcsp/redo02.log
/u01/oradata/wlcsp/redo01.log
/u01/oradata/wlcsp/users01.dbf
/u01/oradata/wlcsp/undotbs01.dbf
/u01/oradata/wlcsp/sysaux01.dbf
/u01/oradata/wlcsp/system01.dbf
/u01/oradata/wlcsp/temp01.dbf
/u01/oradata/wlcsp/example01.dbf
/u01/oradata/wlcsp/test_test.dbf
/u01/oradata/wlcsp/redo04.log
u01/oradata/wlcsp/standby_redo01.log
u01/oradata/wlcsp/standby_redo02.log
u01/oradata/wlcsp/standby_redo03.log
u01/oradata/wlcsp/standby_redo04.log
u01/oradata/wlcsp/standby_redo05.log
/u01/oradata/wlcsp/wlcsp_data01.dbf
/u01/oradata/wlcsp/redo03.log
/u01/oradata/wlcsp/redo02.log
/u01/oradata/wlcsp/redo01.log
/u01/oradata/wlcsp/users01.dbf
/u01/oradata/wlcsp/undotbs01.dbf
/u01/oradata/wlcsp/sysaux01.dbf
/u01/oradata/wlcsp/system01.dbf
/u01/oradata/wlcsp/temp01.dbf
/u01/oradata/wlcsp/example01.dbf
/u01/oradata/wlcsp/test_test.dbf
/u01/oradata/wlcsp/redo04.log
u01/oradata/wlcsp/standby_redo01.log
u01/oradata/wlcsp/standby_redo02.log
u01/oradata/wlcsp/standby_redo03.log
u01/oradata/wlcsp/standby_redo04.log
u01/oradata/wlcsp/standby_redo05.log
/u01/oradata/wlcsp/wlcsp_data01.dbf
SYSTEM
SYSAUX
UNDOTBS1
USERS
TEMP
EXAMPLE
TEST
WLCSP
--More--

 

 

SQL> alter database backup controlfile to trace as '/opt/control.sql';

Database altered.

 这个将controlfile的物理结构备份到control.sql文件中，内容是sql形式。

可以通过里面的内容重建controlfile。

 

sql语句如下有两部分组成：
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "WLCSP" NORESETLOGS FORCE LOGGING ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 '/u01/oradata/wlcsp/redo01.log'  SIZE 50M BLOCKSIZE 512,
  GROUP 2 '/u01/oradata/wlcsp/redo02.log'  SIZE 50M BLOCKSIZE 512,
  GROUP 3 '/u01/oradata/wlcsp/redo03.log'  SIZE 50M BLOCKSIZE 512,
  GROUP 4 '/u01/oradata/wlcsp/redo04.log'  SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE

DATAFILE
  '/u01/oradata/wlcsp/system01.dbf',
  '/u01/oradata/wlcsp/sysaux01.dbf',
  '/u01/oradata/wlcsp/undotbs01.dbf',
  '/u01/oradata/wlcsp/users01.dbf',
  '/u01/oradata/wlcsp/example01.dbf',
  '/u01/oradata/wlcsp/test_test.dbf',
  '/u01/oradata/wlcsp/wlcsp_data01.dbf'
CHARACTER SET AL32UTF8
;

ALTER DATABASE OPEN;

ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/oradata/wlcsp/temp01.dbf'
     SIZE 168820736  REUSE AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M; 

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

 

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "WLCSP" RESETLOGS FORCE LOGGING ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 '/u01/oradata/wlcsp/redo01.log'  SIZE 50M BLOCKSIZE 512,
  GROUP 2 '/u01/oradata/wlcsp/redo02.log'  SIZE 50M BLOCKSIZE 512,
  GROUP 3 '/u01/oradata/wlcsp/redo03.log'  SIZE 50M BLOCKSIZE 512,
  GROUP 4 '/u01/oradata/wlcsp/redo04.log'  SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE

DATAFILE
  '/u01/oradata/wlcsp/system01.dbf',
  '/u01/oradata/wlcsp/sysaux01.dbf',
  '/u01/oradata/wlcsp/undotbs01.dbf',
  '/u01/oradata/wlcsp/users01.dbf',
  '/u01/oradata/wlcsp/example01.dbf',
  '/u01/oradata/wlcsp/test_test.dbf',
  '/u01/oradata/wlcsp/wlcsp_data01.dbf'
CHARACTER SET AL32UTF8
;

ALTER DATABASE OPEN RESETLOGS;

--RECOVER DATABASE USING BACKUP CONTROLFILE

ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/oradata/wlcsp/temp01.dbf'
     SIZE 168820736  REUSE AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M;

 

 

 

SQL> alter system set events 'immediate trace name controlf level 10';

System altered.

SQL> show parameter user_

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
license_max_users                    integer     0
user_dump_dest                       string      /u01/oracle/diag/rdbms/wlcsp/w
                                                 lcsp/trace

 

 

 

 

SQL> oradebug setmypid
Statement processed.
SQL> oradebug dump controlf 3
Statement processed.
SQL> select spid from v$process where addr = (select paddr from v$session where sid =(select sid from v$mystat where rownum = 1));

SPID
------------------------
11063

 

Oradebug之后的内容如下：

####################################################################################

Trace file /u01/oracle/diag/rdbms/wlcsp/wlcsp/trace/wlcsp_ora_11063.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/oracle/product/11.2.0/dbhome_1
System name: Linux
Node name: primary
Release: 2.6.18-164.el5
Version: #1 SMP Tue Aug 18 15:51:48 EDT 2009
Machine: x86_64
Instance name: wlcsp
Redo thread mounted by this instance: 1
Oracle process number: 30
Unix process pid: 11063, image: oracle@primary (TNS V1-V3)


*** 2014-01-15 11:14:21.421
*** SESSION ID:(1.606) 2014-01-15 11:14:21.421
*** CLIENT ID:() 2014-01-15 11:14:21.421
*** SERVICE NAME:(SYS$USERS) 2014-01-15 11:14:21.421
*** MODULE NAME:(sqlplus@primary (TNS V1-V3)) 2014-01-15 11:14:21.421
*** ACTION NAME:() 2014-01-15 11:14:21.421
 
Processing Oradebug command 'setmypid'

*** 2014-01-15 11:14:21.421
Oradebug command 'setmypid' console output:

*** 2014-01-15 11:14:30.118
Processing Oradebug command 'dump controlf 3'
DUMP OF CONTROL FILES, Seq # 825919588 = 0x313a8864

 

控制文件头信息
 V10 STYLE FILE HEADER:
 Compatibility Vsn = 186646528=0xb200000
 Db ID=2936527823=0xaf07dbcf, Db Name='WLCSP'
 Activation ID=0=0x0
 Control Seq=825919588=0x313a8864, File size=632=0x278
 File Number=0, Blksiz=16384, File Type=1 CONTROL
 
 
 
 
***************************************************************************
DATABASE ENTRY

如下都是数据库方面的信息.=

(select * from v$controlfile_record_section where type='DATABASE')
select * from v$controlfile_record_section where type='DATABASE'select * from v$controlfile_record_section where type='DATABASE'select * from v$controlfile_record_section where type='DATABASE'***************************************************************************
 (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)
 09/11/2013 08:46:07
 DB Name "WLCSP"
 Database flags = 0x10404001 0x00001200
 Controlfile Creation Timestamp  09/11/2013 08:46:08   控制文件创建时间
 Incmplt recovery scn: 0x0000.00000000
 Resetlogs scn: 0x0000.000e6c20 Resetlogs Timestamp  09/11/2013 08:46:10
 Prior resetlogs scn: 0x0000.00000001 Prior resetlogs Timestamp  08/15/2009 00:16:43
 Redo Version: compatible=0xb200000
 #Data files = 7, #Online files = 7                     数据文件的个数，online的数据文件个数
 Database checkpoint: Thread=1 scn: 0x0000.02870b7c
 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        表示最大日志组个数，测试之后，发现这个是错误，member个数可以超过3个。
 Arch list: Head=1, Tail=1, Force scn: 0x0000.02866fefscn: 0x0000.02870b7c
 Activation ID: 2936552761
 Controlfile Checkpointed at scn:  0x0000.0287278e 01/15/2014 11:13:03   当前ckpt的时间。
 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(ckpt方面的信息)

select * from v$controlfile_record_section where type='CKPT PROGRESS'
***************************************************************************
 (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:12
low cache rba:(0x380.1367b.0) on disk rba:(0x380.13687.0) 

--这个就是自low cache rba写入到on disk rba，即实例恢复前滚的rba地址段 
on disk scn: 0x0000.02872790 01/15/2014 11:13:03
resetlogs scn: 0x0000.000e6c20 09/11/2013 08:46:10
heartbeat: 836825673 mount id: 2947472825
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
.........................
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)= 7/ 1/2014
Next AutoBackup sequence= 1
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 (redo thread information)
***************************************************************************
 (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:4 first:1 last:4 current:1 last used seq#:0x380
 enabled at scn: 0x0000.000fb949 09/11/2013 13:30:47
 disabled at scn: 0x0000.00000000 01/01/1988 00:00:00
 opened at 01/14/2014 12:08:31 by instance wlcsp
Checkpointed at scn:  0x0000.02870b7c 01/15/2014 08:09:37
 thread:1 rba:(0x380.2.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: 895
 restore point keep sequence: 0
 
 
 
 
***************************************************************************
LOG FILE RECORDS (online redo information)

***************************************************************************
 (size = 72, compat size = 72, section max = 16, section in-use = 9,
  last-recid= 173, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 10, numrecs = 16)
LOG FILE #1: 
 name #3: /u01/oradata/wlcsp/redo01.log
 Thread 1 redo log links: forward: 2 backward: 0   
                              --这里有个forward,backward,把日志组链接起来

 siz: 0x19000 seq: 0x00000380 hws: 0x1 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 1
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.0286bda6
 Low scn: 0x0000.02870b7c 01/15/2014 08:09:37
 Next scn: 0xffff.ffffffff 01/01/1988 00:00:00
LOG FILE #2:
  name #2: /u01/oradata/wlcsp/redo02.log
 Thread 1 redo log links: forward: 3 backward: 1
 siz: 0x19000 seq: 0x0000037d hws: 0x2 bsz: 512 nab: 0x1735b flg: 0x1 dup: 1
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.0285e760
 Low scn: 0x0000.02860cc0 01/14/2014 12:17:39
 Next scn: 0x0000.02866fef 01/14/2014 22:00:21
LOG FILE #3:
  name #1: /u01/oradata/wlcsp/redo03.log
 Thread 1 redo log links: forward: 4 backward: 2
 siz: 0x19000 seq: 0x0000037e hws: 0x2 bsz: 512 nab: 0x13d7b flg: 0x1 dup: 1
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.02860cc0
 Low scn: 0x0000.02866fef 01/14/2014 22:00:21
 Next scn: 0x0000.0286bda6 01/14/2014 22:02:24
LOG FILE #4:
  name #11: /u01/oradata/wlcsp/redo04.log
 Thread 1 redo log links: forward: 0 backward: 3
 siz: 0x19000 seq: 0x0000037f hws: 0x2 bsz: 512 nab: 0x1592b flg: 0x1 dup: 1
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.02866fef
 Low scn: 0x0000.0286bda6 01/14/2014 22:02:24
 Next scn: 0x0000.02870b7c 01/15/2014 08:09:37
LOG FILE #5:        deleted表示已经删除掉了
 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 #6:
 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 #7:
 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 #8:
 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 #9:
 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
 
 
 
 
***************************************************************************
DATA FILE RECORDS          数据文件信息
***************************************************************************
 (size = 520, compat size = 520, section max = 100, section in-use = 7,
  last-recid= 487, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 11, numrecs = 100)
DATA FILE #1:
  name #7: /u01/oradata/wlcsp/system01.dbf                                  名称
creation size=0 block size=8192 status=0xe head=7 tail=7 dup=1     v$datafile.create_bytes
 tablespace 0, index=1 krfil=1 prev_file=0                         对应v$tablespace.ts#
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:825860785 scn: 0x0000.02870b7c 01/15/2014 08:09:37
 Stop scn: 0xffff.ffffffff 01/14/2014 12:07:12
 Creation Checkpointed at scn:  0x0000.00000007 08/15/2009 00:16:48 v$datafile.creation_change#   
 thread:0 rba:(0x0.0.0)                                             rba
 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.00000000 prev_range: 0
 Online Checkpointed at scn:  0x0000.00000000
 thread:0 rba:(0x0.0.0)
 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 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                   热备份的scn
 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: /u01/oradata/wlcsp/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:825860785 scn: 0x0000.02870b7c 01/15/2014 08:09:37
 Stop scn: 0xffff.ffffffff 01/14/2014 12:07:12
 Creation Checkpointed at scn:  0x0000.0000085c 08/15/2009 00:17:00
 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.00000000 prev_range: 0
 Online Checkpointed at scn:  0x0000.00000000
 thread:0 rba:(0x0.0.0)
 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 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: /u01/oradata/wlcsp/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:825860785 scn: 0x0000.02870b7c 01/15/2014 08:09:37
 Stop scn: 0xffff.ffffffff 01/14/2014 12:07:12
 Creation Checkpointed at scn:  0x0000.000e620b 08/15/2009 00:52:15
 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.00000000 prev_range: 0
 Online Checkpointed at scn:  0x0000.00000000
 thread:0 rba:(0x0.0.0)
 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 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: /u01/oradata/wlcsp/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:825860785 scn: 0x0000.02870b7c 01/15/2014 08:09:37
 Stop scn: 0xffff.ffffffff 01/14/2014 12:07:12
 Creation Checkpointed at scn:  0x0000.00004649 08/15/2009 00:17:30
 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.00000000 prev_range: 0
 Online Checkpointed at scn:  0x0000.00000000
 thread:0 rba:(0x0.0.0)
 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 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 #7:
  name #17: /u01/oradata/wlcsp/wlcsp_data01.dbf
creation size=1280 block size=8192 status=0xe head=17 tail=17 dup=1
 tablespace 9, index=8 krfil=7 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:931 scn: 0x0000.02870b7c 01/15/2014 08:09:37
 Stop scn: 0xffff.ffffffff 01/14/2014 12:07:12
 Creation Checkpointed at scn:  0x0000.0010625f 09/13/2013 13:24:22
 thread:1 rba:(0x24.e5.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.0259de6f prev_range: 0
 Online Checkpointed at scn:  0x0000.0259e31d 11/18/2013 13:12:17
 thread:1 rba:(0x22b.c23b.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.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: /u01/oradata/wlcsp/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.000e6d07 09/11/2013 08:46:25
 
 
 
 
***************************************************************************
TABLESPACE RECORDS  表空间记录
***************************************************************************
 (size = 68, compat size = 68, section max = 100, section in-use = 8,
  last-recid= 6, 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
TABLESPACE #7 TEST: 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
TABLESPACE #9 WLCSP: recno=8
 First datafile link=7  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   rman配置记录
***************************************************************************
 (size = 1108, compat size = 1108, section max = 50, section in-use = 3,
  last-recid= 3, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 91, numrecs = 50)
CHANNEL:DEVICE TYPE DISK FORMAT   '/u01/rmanbackup/%U' recno=1
CONTROLFILE AUTOBACKUP:ON recno=2
CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE:DISK TO '/u01/rmanbackup/%F' recno=3
 
 
 
 
***************************************************************************
FLASHBACK LOGFILE RECORDS  flashback logfile记录
***************************************************************************
 (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)
wlcsp 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: 20165933 us, Times measured: 4
File open time: Avg: 4167 us, Times measured: 25
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: 33333 us, Times measured: 3
Ratio Information:
# of log blocks measured: 958878
# of data blocks measured: 7660
# of change vectors measured: 650117
 
 
 
 
***************************************************************************
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 = 292,
  last-recid= 895, old-recno = 20, last-recno = 19)
 (extent = 1, blkno = 95, numrecs = 292)
Earliest record:
 RECID #604 Recno 20 Record timestamp  12/12/13 22:00:20 Thread=1 Seq#=604 Link-Recid=603 kccic-Recid=2
  Low scn: 0x0000.0261284a 12/12/13 00:00:33 Next scn: 0x0000.0261c42b
Latest record:
 RECID #895 Recno 19 Record timestamp  01/15/14 08:09:37 Thread=1 Seq#=895 Link-Recid=894 kccic-Recid=2
  Low scn: 0x0000.0286bda6 01/14/14 22:02:24 Next scn: 0x0000.02870b7c
 
 
 
 
***************************************************************************
OFFLINE RANGE RECORDS
***************************************************************************
 (size = 200, compat size = 200, section max = 163, section in-use = 2,
  last-recid= 2, old-recno = 1, last-recno = 2)
 (extent = 1, blkno = 96, numrecs = 163)
Earliest record:
 RECID #1 Recno 1 Record timestamp  09/11/13 13:30:47 File=5 Link-Recid=0 kccic-Recid=2
 Offline scn: 0x0000.000eda8e
 Online checkpointed at scn: 0x0000.000eda93 09/11/13 08:47:24
 thread:1 rba:(0x1.69af.10)
Latest record:
 RECID #2 Recno 2 Record timestamp  09/11/13 13:30:47 File=6 Link-Recid=0 kccic-Recid=2
 Offline scn: 0x0000.000f9ff1
 Online checkpointed at scn: 0x0000.000fa615 09/11/13 12:16:38
 thread:1 rba:(0xf.150f.10)
 
 
 
 
***************************************************************************
ARCHIVED LOG RECORDS
***************************************************************************
 (size = 584, compat size = 584, section max = 560, section in-use = 560,
  last-recid= 1207, old-recno = 88, last-recno = 87)
 (extent = 1, blkno = 98, numrecs = 28)
 (extent = 2, blkno = 297, numrecs = 252)
 (extent = 3, blkno = 306, numrecs = 280)
Earliest record:
 RECID #648 Recno 88 Record timestamp  09/29/13 10:19:03 Thread=1 Seq#=338
  Flags:
  Resetlogs scn and time scn: 0x0000.000e6c20 09/11/13 08:46:10
  filename
  Low scn: 0x0000.01efe4eb 09/29/13 10:12:58 Next scn: 0x0000.01efe620 09/29/13 10:18:49
  Block count=343  Blocksize=512
Latest record:
 RECID #1207 Recno 87 Record timestamp  01/15/14 08:09:41 Thread=1 Seq#=895
  Flags:
  Resetlogs scn and time scn: 0x0000.000e6c20 09/11/13 08:46:10
  filename /arch/1_895_825842770.dbf
  Low scn: 0x0000.0286bda6 01/14/14 22:02:24 Next scn: 0x0000.02870b7c 01/15/14 08:09:37
  Block count=88362  Blocksize=512
 
 
 
 
***************************************************************************
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 = 37,
  last-recid= 37, old-recno = 1, last-recno = 37)
 (extent = 1, blkno = 99, numrecs = 409)
Earliest record:
 RECID #1 Recno 1 Record timestamp  09/11/13 10:42:36
  Backup set key: stamp=825849664, count=1
  Backup status:
  Backup contains:
  Flags:
  Blocksize=8192 Piece-Count=1 Level=0 Time:
  Backup does not have keep options.
Latest record:
 RECID #37 Recno 37 Record timestamp  01/07/14 10:27:15
  Backup set key: stamp=836216833, count=40
  Backup status:
  Backup contains:
  Flags:
  Blocksize=16384 Piece-Count=1 Level=0 Time:
  Backup does not have keep options.
 
 
 
 
***************************************************************************
BACKUP PIECE RECORDS
***************************************************************************
 (size = 736, compat size = 736, section max = 200, section in-use = 37,
  last-recid= 37, old-recno = 1, last-recno = 37)
 (extent = 1, blkno = 100, numrecs = 200)
Earliest record:
 RECID #1 Recno 1 Record timestamp  09/11/13 10:41:04 piece #1  copy #1 pool 0
  Backup set key: stamp=825849664, count=1
  V$RMAN_STATUS: recid=140735224258168, stamp=140735224258160
  Flags:
  Device: DISK
  Handle:
  Media-Handle:
  Comment:
  Tag: TAG20130911T104104
  Completion time  09/11/13 10:42:36
Latest record:
 RECID #37 Recno 37 Record timestamp  01/07/14 10:27:14 piece #1  copy #1 pool 0
  Backup set key: stamp=836216833, count=40
  V$RMAN_STATUS: recid=140735224258168, stamp=140735224258160
  Flags:
  Device: DISK
  Handle: /u01/rmanbackup/c-2936527823-20140107-00
  Media-Handle:
  Comment:
  Tag: TAG20140107T102713
  Completion time  01/07/14 10:27:15
 
 
 
 
***************************************************************************
BACKUP DATAFILE RECORDS
***************************************************************************
 (size = 200, compat size = 200, section max = 245, section in-use = 91,
  last-recid= 91, old-recno = 1, last-recno = 91)
 (extent = 1, blkno = 109, numrecs = 245)
Earliest record:
 RECID #1 Recno 1 Record timestamp  09/11/13 10:42:36 File=1 Incremental backup level=0
  File is NOT part of the incremental strategy
  Backup set key: stamp=825849664, count=1
  Creation checkpointed at scn: 0x0000.00000007 08/15/09 00:16:48
  File header checkpointed at scn: 0x0000.000f8fd1 09/11/13 10:41:04
  Resetlogs scn and time scn: 0x0000.000e6c20 09/11/13 08:46:10
  Incremental Change scn: 0x0000.00000000
  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 75285
  File size at backup time 87040  Block size 8192
  Low Offline Range Recid 0
  Number of blocks read during backup 86209
 Plugged readony: NO
 Plugin scnscn: 0x0000.00000000
 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/88 00:00:00
Latest record:
 RECID #91 Recno 91 Record timestamp  01/07/14 10:27:14 File=0 Incremental backup level=0
  File is NOT part of the incremental strategy
  Backup set key: stamp=836216833, count=40
  Creation checkpointed at scn: 0x0000.00000000 09/11/13 08:46:08
  File header checkpointed at scn: 0x0000.027cff5d 01/07/14 10:27:13
  Resetlogs scn and time scn: 0x0000.000e6c20 09/11/13 08:46:10
  Incremental Change scn: 0x0000.00000000
  Absolute Fuzzy scn: 0x0000.00000000
  Newly-marked media corrupt blocks  2014 Total media corrupt blocks 107
  Total logically corrupt blocks 0  Block images written to backup 632
  File size at backup time 632  Block size 16384
  Low Offline Range Recid 1
  Number of blocks read during backup 632
 Plugged readony: NO
 Plugin scnscn: 0x0000.00000000
 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/88 00:00:00
 
 
 
 
***************************************************************************
BACKUP LOG RECORDS
***************************************************************************
 (size = 76, compat size = 76, section max = 215, section in-use = 112,
  last-recid= 112, old-recno = 1, last-recno = 112)
 (extent = 1, blkno = 112, numrecs = 215)
Earliest record:
 RECID #1 Recno 1 Record timestamp  09/17/13 09:32:24 Thread=1 Seq#=42
  Backup set key: stamp=826363899, count=17
  Lowscn: 0x0000.0011d7cf 09/16/13 13:49:46 Next scn: 0x0000.0011dce8 09/16/13 13:59:23
  Resetlogs scn and time scn: 0x0000.000e6c20 09/11/13 08:46:10
  Block count=97752  Blocksize=512
Latest record:
 RECID #112 Recno 112 Record timestamp  09/26/13 17:17:47 Thread=1 Seq#=326
  Backup set key: stamp=827169466, count=29
  Lowscn: 0x0000.01eb83ab 09/26/13 17:14:49 Next scn: 0x0000.01eb85b8 09/26/13 17:17:46
  Resetlogs scn and time scn: 0x0000.000e6c20 09/11/13 08:46:10
  Block count=721  Blocksize=512
 
 
 
 
***************************************************************************
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  09/11/13 08:46:35
  File=5 (5) database id=4023594539 block size=8192
  Flags:
  Filename:
  Creation checkpointed at scn: 0x0000.000e6d65 08/15/09 00:54:01
  File header checkpointed at scn: 0x0000.000ebcb2 08/15/09 00:57:02
  Resetlogs scn and time scn: 0x0000.00000001 08/15/09 00:16:43
  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  09/11/13 08:46:35
  File=5 (5) database id=4023594539 block size=8192
  Flags:
  Filename:
  Creation checkpointed at scn: 0x0000.000e6d65 08/15/09 00:54:01
  File header checkpointed at scn: 0x0000.000ebcb2 08/15/09 00:57:02
  Resetlogs scn and time scn: 0x0000.00000001 08/15/09 00:16:43
  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 = 818,
  last-recid= 1165, old-recno = 348, last-recno = 347)
 (extent = 1, blkno = 124, numrecs = 818)
Earliest record:
 RECID #348 Recno 348 Record timestamp  09/17/13 15:12:01
  Object type=11  Object recid=246  Object timestamp= 09/17/13 10:55:31
Latest record:
 RECID #1165 Recno 347 Record timestamp  01/06/14 13:20:15
  Object type=233  Object recid=0  Object timestamp= 01/01/88 00:00:00
 
 
 
 
***************************************************************************
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 08/15/09 00:16:43
  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.000e6c20 09/11/13 08:46:10
  Previous Resetlogs scn and time scn: 0x0000.00000001 08/15/09 00:16:43
 Incarnation (parent inc#, flag)=(1, 2)
 
 
 
 
***************************************************************************
RMAN STATUS RECORDS
***************************************************************************
 (size = 116, compat size = 116, section max = 141, section in-use = 141,
  last-recid= 150, old-recno = 10, last-recno = 9)
 (extent = 1, blkno = 158, numrecs = 141)
Earliest record:
 RECID #10 Recno 10
  Internal Status: 34
  External Status: 18
    Command id: 2013-09-11T18:57:15
  Operation: RMAN
  Start and End time 09/11/13 10:56:34 09/11/13 10:57:20
Latest record:
 RECID #150 Recno 9
  Internal Status: 34
  External Status: 2
    Command id: 2014-01-06T13:19:44
  Operation: delete
  Start and End time 01/06/14 13:19:56 01/06/14 13:20:15
 
 
 
 
***************************************************************************
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 ***

*** 2014-01-15 11:14:30.201
Oradebug command 'dump controlf 3' console output:

####################################################################################

 参考:http://blog.itpub.net/9240380/viewspace-757471/

来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24237320/viewspace-1071662/ ，如需转载，请注明出处，否则将追究法律责任。

0
0
上一篇： sqlserver 使用全备和增备 还原数据库
下一篇： data guard的结构常识(转载)
请登录后发表评论 登录
全部评论
tolilong

注册时间：2010-07-13

  • 博文量
    406
  • 访问量
    1208672

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593