oracle controlfile理解

tolilong發表於2014-01-16

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: (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:( (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部落格 ” ,連結:http://blog.itpub.net/24237320/viewspace-1071662/,如需轉載,請註明出處,否則將追究法律責任。

相關文章