程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> Oracle數據庫 >> Oracle教程 >> 對oracle controlfile進行轉儲

對oracle controlfile進行轉儲

編輯:Oracle教程

對oracle controlfile進行轉儲


對oracle controlfile進行轉儲


環境:
rhel5.5,x64,oracle 10.2.0.5.12

轉儲命令:

alter session set events 'immediate trace name controlf level 9';

該命令摘自:
How to find the name of an old Restore Point when the database will not open: ORA-38760 (Doc ID 1288189.1)

不過,貌似呂海波大師用的是level 10的命令:

alter session set events 'immediate trace name controlf level 10' 

另外,在mos文章 RMAN Recovery Session Fails with ORA-1861 (Doc ID 852723.1)中,提到了level 20:

alter session set events 'immediate trace name controlf level 20';

至於level 表示的含義,在別的文章中研究一下。

[oracle@jjtest udump]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Fri May 15 09:28:07 2015

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> oradebug setmypid
Statement processed.
SQL> alter session set events 'immediate trace name controlf level 9';

Session altered.

SQL> oradebug tracefile_name
/u01/app/oracle/admin/orcl/udump/orcl_ora_4484.trc


以下全文引用'orcl_ora_4484.trc'文件的內容:

/u01/app/oracle/admin/orcl/udump/orcl_ora_4484.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
System name:	Linux
Node name:	jjtest
Release:	2.6.18-348.el5
Version:	#1 SMP Wed Nov 28 21:22:00 EST 2012
Machine:	x86_64
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 15
Unix process pid: 4484, image: oracle@jjtest (TNS V1-V3)

*** ACTION NAME:() 2015-05-15 09:28:10.059
*** MODULE NAME:(sqlplus@jjtest (TNS V1-V3)) 2015-05-15 09:28:10.059
*** SERVICE NAME:() 2015-05-15 09:28:10.059
*** SESSION ID:(654.7) 2015-05-15 09:28:10.059
*** 2015-05-15 09:28:10.059
Processing Oradebug command 'setmypid'
*** 2015-05-15 09:28:22.620
DUMP OF CONTROL FILES, Seq # 444 = 0x1bc
 V10 STYLE FILE HEADER:
	Compatibility Vsn = 169870592=0xa200500
	Db ID=1407362313=0x53e2a509, Db Name='ORCL'
	Activation ID=0=0x0
	Control Seq=444=0x1bc, File size=430=0x1ae
	File Number=0, Blksiz=16384, File Type=1 CONTROL
 
 
 
 
***************************************************************************
DATABASE ENTRY
***************************************************************************
 (size = 316, compat size = 316, section max = 1, section in-use = 1,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 1, numrecs = 1)
 05/13/2015 08:12:57
 DB Name "ORCL"
 Database flags = 0x00404000 0x00001000
 Controlfile Creation Timestamp  05/13/2015 08:13:03
 Incmplt recovery scn: 0x0000.00000000
 Resetlogs scn: 0x0000.0005eca9 Resetlogs Timestamp  05/13/2015 08:13:06
 Prior resetlogs scn: 0x0000.00000001 Prior resetlogs Timestamp  04/20/2010 08:24:24
 Redo Version: compatible=0xa200500
 #Data files = 7, #Online files = 7
 Database checkpoint: Thread=1 scn: 0x0000.0006b6fe
 Threads: #Enabled=1, #Open=1, Head=1, Tail=1
 enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Max log members = 3, Max data members = 1
 Arch list: Head=0, Tail=0, Force scn: 0x0000.00063520scn: 0x0000.0005eca9
 Activation ID: 1407383561
 Controlfile Checkpointed at scn:  0x0000.0006c3dc 05/14/2015 05:44:54
 thread:0 rba:(0x0.0.0)
 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 
 
 
 
***************************************************************************
CHECKPOINT PROGRESS RECORDS
***************************************************************************
 (size = 8180, compat size = 8180, section max = 11, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 2, numrecs = 11)
THREAD #1 - status:0x2 flags:0x0 dirty:25
low cache rba:(0x9.72ba.0) on disk rba:(0x9.72d6.0)
on disk scn: 0x0000.0006e0fa 05/14/2015 10:38:30
resetlogs scn: 0x0000.0005eca9 05/13/2015 08:13:06
heartbeat: 879713207 mount id: 1407480442
THREAD #2 - status:0x0 flags:0x0 dirty:0
low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
on disk scn: 0x0000.00000000 01/01/1988 00:00:00
resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
heartbeat: 0 mount id: 0
THREAD #3 - status:0x0 flags:0x0 dirty:0
low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
on disk scn: 0x0000.00000000 01/01/1988 00:00:00
resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
heartbeat: 0 mount id: 0
THREAD #4 - status:0x0 flags:0x0 dirty:0
low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
on disk scn: 0x0000.00000000 01/01/1988 00:00:00
resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
heartbeat: 0 mount id: 0
THREAD #5 - status:0x0 flags:0x0 dirty:0
low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
on disk scn: 0x0000.00000000 01/01/1988 00:00:00
resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
heartbeat: 0 mount id: 0
THREAD #6 - status:0x0 flags:0x0 dirty:0
low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
on disk scn: 0x0000.00000000 01/01/1988 00:00:00
resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
heartbeat: 0 mount id: 0
THREAD #7 - status:0x0 flags:0x0 dirty:0
low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
on disk scn: 0x0000.00000000 01/01/1988 00:00:00
resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
heartbeat: 0 mount id: 0
THREAD #8 - status:0x0 flags:0x0 dirty:0
low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
on disk scn: 0x0000.00000000 01/01/1988 00:00:00
resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
heartbeat: 0 mount id: 0
 
 
 
 
***************************************************************************
EXTENDED DATABASE ENTRY
***************************************************************************
 (size = 276, compat size = 276, section max = 1, section in-use = 1,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 137, numrecs = 1)
Control AutoBackup date(dd/mm/yyyy)=13/ 5/2015
Next AutoBackup sequence= 0
Database recovery target inc#:2, Last open inc#:2
flg:0x0, flag:0x0
Change tracking state=0, file index=0, checkpoint count=0
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
 
 
 
 
***************************************************************************
REDO THREAD RECORDS
***************************************************************************
 (size = 256, compat size = 256, section max = 8, section in-use = 1,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 9, numrecs = 8)
THREAD #1 - status:0xf thread links forward:0 back:0
 #logs:3 first:1 last:3 current:3 last used seq#:0x9
 enabled at scn: 0x0000.0005eca9 05/13/2015 08:13:06
 disabled at scn: 0x0000.00000000 01/01/1988 00:00:00
 opened at 05/14/2015 05:39:06 by instance orcl
Checkpointed at scn:  0x0000.0006b6fe 05/14/2015 05:39:06
 thread:1 rba:(0x9.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: 8
 restore point keep sequence: 0
 
 
 
 
***************************************************************************
LOG FILE RECORDS
***************************************************************************
 (size = 72, compat size = 72, section max = 16, section in-use = 3,
  last-recid= 3, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 10, numrecs = 16)
LOG FILE #1: 
  (name #3) /u01/app/oracle/oradata/orcl/redo01.log
 Thread 1 redo log links: forward: 2 backward: 0
 siz: 0x19000 seq: 0x00000007 hws: 0x3 bsz: 512 nab: 0x16775 flg: 0x0 dup: 1
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.000634ed
 Low scn: 0x0000.00063520 05/13/2015 10:55:05
 Next scn: 0x0000.000664e0 05/13/2015 11:58:30
LOG FILE #2: 
  (name #2) /u01/app/oracle/oradata/orcl/redo02.log
 Thread 1 redo log links: forward: 3 backward: 1
 siz: 0x19000 seq: 0x00000008 hws: 0x4 bsz: 512 nab: 0xe904 flg: 0x0 dup: 1
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.00063520
 Low scn: 0x0000.000664e0 05/13/2015 11:58:30
 Next scn: 0x0000.0006b6fd 05/14/2015 05:39:06
LOG FILE #3: 
  (name #1) /u01/app/oracle/oradata/orcl/redo03.log
 Thread 1 redo log links: forward: 0 backward: 2
 siz: 0x19000 seq: 0x00000009 hws: 0x2 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 1
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.000664e0
 Low scn: 0x0000.0006b6fd 05/14/2015 05:39:06
 Next scn: 0xffff.ffffffff 01/01/1988 00:00:00
 
 
 
 
***************************************************************************
DATA FILE RECORDS
***************************************************************************
 (size = 428, compat size = 428, section max = 100, section in-use = 7,
  last-recid= 8, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 11, numrecs = 100)
DATA FILE #1: 
  (name #7) /u01/app/oracle/oradata/orcl/system01.dbf
creation size=0 block size=8192 status=0xe head=7 tail=7 dup=1
 tablespace 0, index=1 krfil=1 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:58 scn: 0x0000.0006b6fe 05/14/2015 05:39:06
 Stop scn: 0xffff.ffffffff 05/13/2015 12:23:12
 Creation Checkpointed at scn:  0x0000.00000007 04/20/2010 08:24:26
 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.0005eca8 prev_range: 0
 Online Checkpointed at scn:  0x0000.0005eca9 05/13/2015 08:13:06
 thread:1 rba:(0x1.2.0)
 enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Hot Backup end marker scn: 0x0000.00000000
 aux_file is NOT DEFINED 
DATA FILE #2: 
  (name #6) /u01/app/oracle/oradata/orcl/undotbs01.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:21 scn: 0x0000.0006b6fe 05/14/2015 05:39:06
 Stop scn: 0xffff.ffffffff 05/13/2015 12:23:12
 Creation Checkpointed at scn:  0x0000.0005e654 04/20/2010 08:49:03
 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.0005eca8 prev_range: 0
 Online Checkpointed at scn:  0x0000.0005eca9 05/13/2015 08:13:06
 thread:1 rba:(0x1.2.0)
 enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Hot Backup end marker scn: 0x0000.00000000
 aux_file is NOT DEFINED 
DATA FILE #3: 
  (name #5) /u01/app/oracle/oradata/orcl/sysaux01.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:58 scn: 0x0000.0006b6fe 05/14/2015 05:39:06
 Stop scn: 0xffff.ffffffff 05/13/2015 12:23:12
 Creation Checkpointed at scn:  0x0000.000016a6 04/20/2010 08:24:32
 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.0005eca8 prev_range: 0
 Online Checkpointed at scn:  0x0000.0005eca9 05/13/2015 08:13:06
 thread:1 rba:(0x1.2.0)
 enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Hot Backup end marker scn: 0x0000.00000000
 aux_file is NOT DEFINED 
DATA FILE #4: 
  (name #4) /u01/app/oracle/oradata/orcl/users01.dbf
creation size=0 block size=8192 status=0xe head=4 tail=4 dup=1
 tablespace 4, index=4 krfil=4 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:57 scn: 0x0000.0006b6fe 05/14/2015 05:39:06
 Stop scn: 0xffff.ffffffff 05/13/2015 12:23:12
 Creation Checkpointed at scn:  0x0000.000022b3 04/20/2010 08:24:34
 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.0005eca8 prev_range: 0
 Online Checkpointed at scn:  0x0000.0005eca9 05/13/2015 08:13:06
 thread:1 rba:(0x1.2.0)
 enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Hot Backup end marker scn: 0x0000.00000000
 aux_file is NOT DEFINED 
DATA FILE #5: 
  (name #9) /u01/app/oracle/oradata/orcl/dm_01.ora
creation size=3200 block size=32768 status=0xe head=9 tail=9 dup=1
 tablespace 6, index=6 krfil=5 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:11 scn: 0x0000.0006b6fe 05/14/2015 05:39:06
 Stop scn: 0xffff.ffffffff 05/13/2015 12:23:12
 Creation Checkpointed at scn:  0x0000.00063093 05/13/2015 10:31:54
 thread:1 rba:(0x2.12fcc.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.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 
DATA FILE #6: 
  (name #10) /u01/app/oracle/oradata/orcl/dm_02.ora
creation size=3200 block size=32768 status=0xe head=10 tail=10 dup=1
 tablespace 6, index=6 krfil=6 prev_file=5
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:11 scn: 0x0000.0006b6fe 05/14/2015 05:39:06
 Stop scn: 0xffff.ffffffff 05/13/2015 12:23:12
 Creation Checkpointed at scn:  0x0000.0006309d 05/13/2015 10:32:19
 thread:1 rba:(0x2.12fd0.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.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 
DATA FILE #7: 
  (name #11) /u01/app/oracle/oradata/orcl/dm_03.ora
creation size=3200 block size=32768 status=0xe head=11 tail=11 dup=1
 tablespace 6, index=6 krfil=7 prev_file=6
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:11 scn: 0x0000.0006b6fe 05/14/2015 05:39:06
 Stop scn: 0xffff.ffffffff 05/13/2015 12:23:12
 Creation Checkpointed at scn:  0x0000.000630a0 05/13/2015 10:32:19
 thread:1 rba:(0x2.12fd5.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.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 
 
 
 
 
***************************************************************************
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 = 89, numrecs = 100)
TEMP FILE #1: External File #201 
  (name #8) /u01/app/oracle/oradata/orcl/temp01.dbf
creation size=2560 block size=8192 status=0x1e head=8 tail=8 dup=1
 tablespace 3, index=5 krfil=1 prev_file=0
 unrecoverable scn: 0x0000.0005ed62 05/13/2015 08:14:21
 
 
 
 
***************************************************************************
TABLESPACE RECORDS
***************************************************************************
 (size = 68, compat size = 68, section max = 100, section in-use = 6,
  last-recid= 2, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 88, 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 UNDOTBS1: 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 SYSAUX: 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 DM: recno=6
 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
***************************************************************************
 (size = 1108, compat size = 1108, section max = 50, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 90, numrecs = 50)
 
 
 
 
***************************************************************************
FLASHBACK LOGFILE RECORDS
***************************************************************************
 (size = 84, compat size = 84, section max = 2048, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 139, 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 = 156, numrecs = 8)
orcl recno=1
UNNAMED_INSTANCE_2 recno=2
UNNAMED_INSTANCE_3 recno=3
UNNAMED_INSTANCE_4 recno=4
UNNAMED_INSTANCE_5 recno=5
UNNAMED_INSTANCE_6 recno=6
UNNAMED_INSTANCE_7 recno=7
UNNAMED_INSTANCE_8 recno=8
 
 
 
 
***************************************************************************
MTTR RECORDS
***************************************************************************
 (size = 100, compat size = 100, section max = 8, section in-use = 1,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 157, numrecs = 8)
MTTR record for thread 1
MTTR statistics status: 1
Init time: Avg: 18105555 us, Times measured: 3
File open time: Avg: 24040 us, Times measured: 10
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: 0 us, Times measured: 1
Ratio Information:
# of log blocks measured: 562716
# of data blocks measured: 10888
# of change vectors measured: 467327
 
 
 
 
***************************************************************************
STANDBY DATABASE MAP RECORDS
***************************************************************************
 (size = 400, compat size = 400, section max = 10, section in-use = 10,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 160, numrecs = 10)
 
 
 
 
***************************************************************************
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 = 161, numrecs = 2048)
 
 
 
 
***************************************************************************
LOG FILE HISTORY RECORDS
***************************************************************************
 (size = 56, compat size = 56, section max = 292, section in-use = 8,
  last-recid= 8, old-recno = 1, last-recno = 8)
 (extent = 1, blkno = 94, numrecs = 292)
Earliest record:
 RECID #1 Recno 1 Record timestamp  05/13/15 08:14:44 Thread=1 Seq#=1 Link-Recid=0 kccic-Recid=2
  Low scn: 0x0000.0005eca9 05/13/15 08:13:06 Next scn: 0x0000.00060604
Latest record:
 RECID #8 Recno 8 Record timestamp  05/14/15 05:39:06 Thread=1 Seq#=8 Link-Recid=7 kccic-Recid=2
  Low scn: 0x0000.000664e0 05/13/15 11:58:30 Next scn: 0x0000.0006b6fd
 RECID #7 Recno 7 Record timestamp  05/13/15 11:58:35 Thread=1 Seq#=7 Link-Recid=6 kccic-Recid=2
  Low scn: 0x0000.00063520 05/13/15 10:55:05 Next scn: 0x0000.000664e0
 RECID #6 Recno 6 Record timestamp  05/13/15 10:55:05 Thread=1 Seq#=6 Link-Recid=5 kccic-Recid=2
  Low scn: 0x0000.000634ed 05/13/15 10:54:40 Next scn: 0x0000.00063520
 RECID #5 Recno 5 Record timestamp  05/13/15 10:54:40 Thread=1 Seq#=5 Link-Recid=4 kccic-Recid=2
  Low scn: 0x0000.000634b4 05/13/15 10:54:12 Next scn: 0x0000.000634ed
 RECID #4 Recno 4 Record timestamp  05/13/15 10:54:12 Thread=1 Seq#=4 Link-Recid=3 kccic-Recid=2
  Low scn: 0x0000.00063453 05/13/15 10:53:49 Next scn: 0x0000.000634b4
 RECID #3 Recno 3 Record timestamp  05/13/15 10:53:49 Thread=1 Seq#=3 Link-Recid=2 kccic-Recid=2
  Low scn: 0x0000.00063300 05/13/15 10:47:09 Next scn: 0x0000.00063453
 RECID #2 Recno 2 Record timestamp  05/13/15 10:47:09 Thread=1 Seq#=2 Link-Recid=1 kccic-Recid=2
  Low scn: 0x0000.00060604 05/13/15 08:14:44 Next scn: 0x0000.00063300
 RECID #1 Recno 1 Record timestamp  05/13/15 08:14:44 Thread=1 Seq#=1 Link-Recid=0 kccic-Recid=2
  Low scn: 0x0000.0005eca9 05/13/15 08:13:06 Next scn: 0x0000.00060604
 
 
 
 
***************************************************************************
OFFLINE RANGE RECORDS
***************************************************************************
 (size = 200, compat size = 200, section max = 163, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 95, numrecs = 163)
 
 
 
 
***************************************************************************
ARCHIVED LOG RECORDS
***************************************************************************
 (size = 584, compat size = 584, section max = 28, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 97, numrecs = 28)
 
 
 
 
***************************************************************************
BACKUP SET RECORDS
***************************************************************************
 (size = 40, compat size = 40, section max = 409, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 98, numrecs = 409)
 
 
 
 
***************************************************************************
BACKUP PIECE RECORDS
***************************************************************************
 (size = 736, compat size = 736, section max = 200, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 99, numrecs = 200)
 
 
 
 
***************************************************************************
BACKUP DATAFILE RECORDS
***************************************************************************
 (size = 116, compat size = 116, section max = 282, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 108, numrecs = 282)
 
 
 
 
***************************************************************************
BACKUP LOG RECORDS
***************************************************************************
 (size = 76, compat size = 76, section max = 215, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 110, numrecs = 215)
 
 
 
 
***************************************************************************
DATAFILE COPY RECORDS
***************************************************************************
 (size = 660, compat size = 660, section max = 223, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 111, numrecs = 223)
 
 
 
 
***************************************************************************
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 = 120, 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 = 121, numrecs = 409)
 
 
 
 
***************************************************************************
DELETION RECORDS
***************************************************************************
 (size = 20, compat size = 20, section max = 818, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 122, numrecs = 818)
 
 
 
 
***************************************************************************
PROXY COPY RECORDS
***************************************************************************
 (size = 852, compat size = 852, section max = 249, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 123, numrecs = 249)
 
 
 
 
***************************************************************************
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 = 138, numrecs = 292)
Earliest record:
 RECID #1 Recno 1 Record timestamp 
  Resetlogs scn and time scn: 0x0000.00000001 04/20/10 08:24:24
  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.0005eca9 05/13/15 08:13:06
  Previous Resetlogs scn and time scn: 0x0000.00000001 04/20/10 08:24:24
 Incarnation (parent inc#, flag)=(1, 2)
 RECID #1 Recno 1 Record timestamp 
  Resetlogs scn and time scn: 0x0000.00000001 04/20/10 08:24:24
  Previous Resetlogs scn and time scn: 0x0000.00000000 01/01/88 00:00:00
 Incarnation (parent inc#, flag)=(0, 0)
 
 
 
 
***************************************************************************
RMAN STATUS RECORDS
***************************************************************************
 (size = 116, compat size = 116, section max = 141, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 155, numrecs = 141)
 
 
 
 
***************************************************************************
DATAFILE HISTORY RECORDS
***************************************************************************
 (size = 568, compat size = 568, section max = 57, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 158, 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 = 188, numrecs = 2083)
*** END OF DUMP ***
*** 2015-05-15 09:28:29.283
Processing Oradebug command 'tracefile_name'

 

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved