oracle controlfile理解
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:
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:
####################################################################################
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/24237320/viewspace-1071662/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- oracle controlfile template;Oracle
- recover database using backup controlfile理解Database
- Oracle 控制檔案(CONTROLFILE)Oracle
- oracle重建controlfile指令碼Oracle指令碼
- Oracle 控制檔案(CONTROLFILE) -- <2>Oracle
- Oracle 控制檔案(CONTROLFILE)- <1>Oracle
- oracle controlfile檔案之三Oracle
- Controlfile備份恢復關於Standby的理解
- oracle-新增 controlfile 以及重建spfileOracle
- Oracle Internals Notes : Controlfile DumpsOracle
- Oracle基礎 06 控制檔案 controlfileOracle
- 檢視oracle中controlfile的內容Oracle
- oracle create a new database using backup controlfile to traceOracleDatabase
- oracle之 利用 controlfile trace檔案重建控制檔案Oracle
- Oracle OCP IZ0-053 Q64(Rman controlfile)Oracle
- Restore standby database controlfile in ASM (refreshing standby controlfile)RESTDatabaseASM
- Oracle 11G 隱含引數“_controlfile_autobackup_delay”Oracle
- Oracle OCP 1Z0 053 Q554(Backup Controlfile)Oracle
- [WK-T]ORACLE 10G RAC+ASM增加controlfileOracle 10gASM
- restore controlfile from autobackREST
- Linux -controlfile -scriptLinux
- oracle with * option 理解Oracle
- create controlfile for new SID
- Oracle Password File 理解Oracle
- ORACLE概念的理解！Oracle
- Oracle基於TSM恢復實驗(模擬spfile、controlfile、datafile丟失)Oracle
- rman restore database(spfile,controlfile, datafile)RESTDatabase
- recover database using backup controlfileDatabase
- 轉：Oracle基於TSM恢復實驗(模擬spfile、controlfile、datafile丟失)Oracle
- 對ORACLE SCN的理解Oracle
- oracle資料塊理解Oracle
- oracle中的exists理解Oracle
- 對Oracle cursor的理解Oracle
- 理解Oracle Shared PoolOracle
- 理解 oracle 的 “lsnrctl status”Oracle
- 理解ORACLE資料庫Oracle資料庫
- 理解 oracle 的 “lsnrctl status”(ZT)Oracle
- oracle表分割槽自我理解Oracle