对oracle controlfile进行转储
浏览数：40 /
时间：2015年06月12日
对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'
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
