eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« Oracle数据恢复:格式化、ASM及字典损坏案例三则 | Blog首页 | Oracle数据恢复:强制Resetlogs的可能数据损失 »

DBID的获取 与 控制文件中有什么?
modb.pro

我以前写过一个文章,如何获得DBID,这个问题今天仍然有人问,其实不管控制文件的名称里是否包含了DBID,但是,只要有了控制文件,就可以从其中获得DBID,可以直接用二进制工具打开,读取固定的位,也可以恢复出了控制文件,通过其Mount数据库,再来查询V$视图。

如果能够转储控制文件,可以看到其头部是有这样一个DBID的:
*** SESSION ID:(147.24) 2010-06-29 12:11:40.899
DUMP OF CONTROL FILES, Seq # 13094 = 0x3326
 V10 STYLE FILE HEADER:
    Compatibility Vsn = 169870080=0xa200300
    Db ID=1535818776=0x5b8abc18, Db Name='EYGLE'
    Activation ID=0=0x0
    Control Seq=13094=0x3326, File size=430=0x1ae
    File Number=0, Blksiz=16384, File Type=1 CONTROL
简单的用BBED打开控制文件,同样可以清晰的看到这个DBID:
BBED> dump
 File: D:\oracle\oradata\EYGLE\CONTROLFILE\O1_MF_5WQNTR1V_.CTL (2)
 Block: 3                Offsets:    0 to  511           Dba:0x00800003
------------------------------------------------------------------------
 15c20000 01000000 00000000 00000104 02b30000 00000000 0003200a 18bc8a5b
 4559474c 45000000 27330000 ae010000 00400000 00000100 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 661eea5b 5871b82a fb823500 00000000 d65e172b 00000000 00000000 00000000
这里的18bc8a5b按照字节序调整一下,就是5b8abc18,正好就是DB ID。

而紧跟DBID之后的8 位正好就是DB Name:
SQL> select dump('EYGLE',16) from dual;

DUMP('EYGLE',16)
----------------------------
Typ=96 Len=5: 45,59,47,4c,45
多了解一下数据库的内部结构,在遇到问题时的处理方法就会有很多。

转储控制文件内容,可以使用以下命令:
alter session set events 'immediate trace name CONTROLF level 8';

参考文档:
Oracle HowTo:如何获得数据库的DBID



收录一个完整的控制文件转储备忘:
*** 2010-06-29 12:11:40.926
*** ACTION NAME:() 2010-06-29 12:11:40.899
*** MODULE NAME:(sqlplus.exe) 2010-06-29 12:11:40.899
*** SERVICE NAME:(SYS$USERS) 2010-06-29 12:11:40.899
*** SESSION ID:(147.24) 2010-06-29 12:11:40.899
DUMP OF CONTROL FILES, Seq # 13094 = 0x3326
 V10 STYLE FILE HEADER:
    Compatibility Vsn = 169870080=0xa200300
    Db ID=1535818776=0x5b8abc18, Db Name='EYGLE'
    Activation ID=0=0x0
    Control Seq=13094=0x3326, 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)
 04/19/2010 11:51:52
 DB Name "EYGLE"
 Database flags = 0x00404000 0x00001000
 Controlfile Creation Timestamp  04/19/2010 11:51:52
 Incmplt recovery scn: 0x0000.00000000
 Resetlogs scn: 0x0000.00089c75 Resetlogs Timestamp  04/19/2010 11:51:53
 Prior resetlogs scn: 0x0000.00000001 Prior resetlogs Timestamp  03/14/2008 18:46:22
 Redo Version: compatible=0xa200300
 #Data files = 10, #Online files = 10
 Database checkpoint: Thread=1 scn: 0x0000.003582b1
 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
 Max log members = 3, Max data members = 1
 Arch list: Head=0, Tail=0, Force scn: 0x0000.0034dc9cscn: 0x0000.00089c75
 Activation ID: 1535842584
 Controlfile Checkpointed at scn:  0x0000.003582fb 06/29/2010 11:58:14
 thread:0 rba:(0x0.0.0)
 enabled  threads:  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:237
low cache rba:(0xe4.2d1.0) on disk rba:(0xe4.6b3.0)
on disk scn: 0x0000.00358553 06/29/2010 12:11:30
resetlogs scn: 0x0000.00089c75 04/19/2010 11:51:53
heartbeat: 722944197 mount id: 1542069862
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)=19/ 4/2010
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
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:4 first:1 last:4 current:2 last used seq#:0xe4
 enabled at scn: 0x0000.00089c75 04/19/2010 11:51:53
 disabled at scn: 0x0000.00000000 01/01/1988 00:00:00
 opened at 06/29/2010 11:57:41 by instance eygle
Checkpointed at scn:  0x0000.003582b1 06/29/2010 11:57:41
 thread:1 rba:(0xe4.2.10)
 enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
.... 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 log history: 227
 restore point keep sequence: 0
 
 
 
 
***************************************************************************
LOG FILE RECORDS
***************************************************************************
 (size = 72, compat size = 72, section max = 16, section in-use = 4,
  last-recid= 10, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 10, numrecs = 16)
LOG FILE #1:
  (name #5) D:\ORACLE\ORADATA\EYGLE\ONLINELOG\O1_MF_1_5WQNTT1R_.LOG
  (name #6) D:\ORACLE\FLASH_RECOVERY_AREA\EYGLE\ONLINELOG\O1_MF_1_5WQNTV35_.LOG
 Thread 1 redo log links: forward: 2 backward: 0
 siz: 0x19000 seq: 0x000000e3 hws: 0x6 bsz: 512 nab: 0xbc1 flg: 0x0 dup: 2
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.0034dc9c
 Low scn: 0x0000.00352f82 06/28/2010 00:46:32
 Next scn: 0x0000.003582b0 06/29/2010 11:57:40
LOG FILE #2:
  (name #3) D:\ORACLE\ORADATA\EYGLE\ONLINELOG\O1_MF_2_5WQNTVVK_.LOG
  (name #4) D:\ORACLE\FLASH_RECOVERY_AREA\EYGLE\ONLINELOG\O1_MF_2_5WQNTWP4_.LOG
 Thread 1 redo log links: forward: 3 backward: 1
 siz: 0x19000 seq: 0x000000e4 hws: 0x2 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 2
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.00352f82
 Low scn: 0x0000.003582b0 06/29/2010 11:57:40
 Next scn: 0xffff.ffffffff 01/01/1988 00:00:00
LOG FILE #3:
  (name #1) D:\ORACLE\ORADATA\EYGLE\ONLINELOG\O1_MF_3_5WQNTXPL_.LOG
  (name #2) D:\ORACLE\FLASH_RECOVERY_AREA\EYGLE\ONLINELOG\O1_MF_3_5WQNTZ4F_.LOG
 Thread 1 redo log links: forward: 4 backward: 2
 siz: 0x19000 seq: 0x000000e1 hws: 0xb bsz: 512 nab: 0xf48 flg: 0x0 dup: 2
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.0034322a
 Low scn: 0x0000.00348521 06/27/2010 20:10:35
 Next scn: 0x0000.0034dc9c 06/27/2010 22:09:11
LOG FILE #4:
  (name #17) D:\ORACLE\ORADATA\EYGLE\ONLINELOG\O1_MF_4_5Y7DTYG4_.LOG
  (name #18) D:\ORACLE\FLASH_RECOVERY_AREA\EYGLE\ONLINELOG\O1_MF_4_5Y7DV5PR_.LOG
 Thread 1 redo log links: forward: 0 backward: 3
 siz: 0x64000 seq: 0x000000e2 hws: 0x7 bsz: 512 nab: 0x7db flg: 0x0 dup: 2
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.00348521
 Low scn: 0x0000.0034dc9c 06/27/2010 22:09:11
 Next scn: 0x0000.00352f82 06/28/2010 00:46:32
 
 
 
 
***************************************************************************
DATA FILE RECORDS
***************************************************************************
 (size = 428, compat size = 428, section max = 100, section in-use = 10,
  last-recid= 10764, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 11, numrecs = 100)
DATA FILE #1:
  (name #10) D:\ORACLE\ORADATA\EYGLE\DATAFILE\O1_MF_SYSTEM_5WQNS3QZ_.DBF
creation size=0 block size=8192 status=0xe head=10 tail=10 dup=1
 tablespace 0, index=1 krfil=1 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:536 scn: 0x0000.003582b1 06/29/2010 11:57:41
 Stop scn: 0xffff.ffffffff 06/28/2010 01:06:50
 Creation Checkpointed at scn:  0x0000.00000009 03/14/2008 18:46:45
 thread:0 rba:(0x0.0.0)
 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000
.... 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Offline scn: 0x0000.00089c74 prev_range: 0
 Online Checkpointed at scn:  0x0000.00089c75 04/19/2010 11:51:53
 thread:1 rba:(0x1.2.0)
 enabled  threads:  01000000 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 #9) D:\ORACLE\ORADATA\EYGLE\DATAFILE\O1_MF_UNDOTBS1_5WQNS3VF_.DBF
creation size=0 block size=8192 status=0xe head=9 tail=9 dup=1
 tablespace 1, index=2 krfil=2 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:318 scn: 0x0000.003582b1 06/29/2010 11:57:41
 Stop scn: 0xffff.ffffffff 06/28/2010 01:06:50
 Creation Checkpointed at scn:  0x0000.0008937b 03/14/2008 19:53:28
 thread:0 rba:(0x0.0.0)
 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000
.... 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Offline scn: 0x0000.00089c74 prev_range: 0
 Online Checkpointed at scn:  0x0000.00089c75 04/19/2010 11:51:53
 thread:1 rba:(0x1.2.0)
 enabled  threads:  01000000 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 #8) D:\ORACLE\ORADATA\EYGLE\DATAFILE\O1_MF_SYSAUX_5WQNS3SG_.DBF
creation size=0 block size=8192 status=0xe head=8 tail=8 dup=1
 tablespace 2, index=3 krfil=3 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:536 scn: 0x0000.003582b1 06/29/2010 11:57:41
 Stop scn: 0xffff.ffffffff 06/28/2010 01:06:50
 Creation Checkpointed at scn:  0x0000.000018ed 03/14/2008 18:47:05
 thread:0 rba:(0x0.0.0)
 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000
.... 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Offline scn: 0x0000.00089c74 prev_range: 0
 Online Checkpointed at scn:  0x0000.00089c75 04/19/2010 11:51:53
 thread:1 rba:(0x1.2.0)
 enabled  threads:  01000000 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 #7) D:\ORACLE\ORADATA\EYGLE\DATAFILE\O1_MF_USERS_5WQNS3VW_.DBF
creation size=0 block size=8192 status=0xe head=7 tail=7 dup=1
 tablespace 4, index=4 krfil=4 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:533 scn: 0x0000.003582b1 06/29/2010 11:57:41
 Stop scn: 0xffff.ffffffff 06/28/2010 01:06:50
 Creation Checkpointed at scn:  0x0000.0000287d 03/14/2008 18:47:15
 thread:0 rba:(0x0.0.0)
 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000
.... 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Offline scn: 0x0000.00089c74 prev_range: 0
 Online Checkpointed at scn:  0x0000.00089c75 04/19/2010 11:51:53
 thread:1 rba:(0x1.2.0)
 enabled  threads:  01000000 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 #12) D:\ORACLE\ORADATA\EYGLE\DATAFILE\O1_MF_DADI_5Y5LJMP6_.DBF
creation size=131072 block size=8192 status=0xe head=12 tail=12 dup=1
 tablespace 6, index=6 krfil=5 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:266 scn: 0x0000.003582b1 06/29/2010 11:57:41
 Stop scn: 0xffff.ffffffff 06/28/2010 01:06:50
 Creation Checkpointed at scn:  0x0000.000cf5ea 05/06/2010 21:54:41
 thread:1 rba:(0x12.f1bd.10)
 enabled  threads:  01000000 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
 Hot Backup end marker scn: 0x0000.00000000
 aux_file is NOT DEFINED
DATA FILE #6:
  (name #13) D:\ORACLE\ORADATA\EYGLE\DATAFILE\O1_MF_DADI_5Y5LNQT2_.DBF
creation size=131072 block size=8192 status=0xe head=13 tail=13 dup=1
 tablespace 6, index=6 krfil=6 prev_file=5
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:266 scn: 0x0000.003582b1 06/29/2010 11:57:41
 Stop scn: 0xffff.ffffffff 06/28/2010 01:06:50
 Creation Checkpointed at scn:  0x0000.000cf65b 05/06/2010 21:56:53
 thread:1 rba:(0x12.f227.10)
 enabled  threads:  01000000 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
 Hot Backup end marker scn: 0x0000.00000000
 aux_file is NOT DEFINED
DATA FILE #7:
  (name #14) D:\ORACLE\ORADATA\EYGLE\DATAFILE\O1_MF_PERFSTAT_5Y7C6QO5_.DBF
creation size=131072 block size=8192 status=0xe head=14 tail=14 dup=1
 tablespace 7, index=7 krfil=7 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:256 scn: 0x0000.003582b1 06/29/2010 11:57:41
 Stop scn: 0xffff.ffffffff 06/28/2010 01:06:50
 Creation Checkpointed at scn:  0x0000.000e0eec 05/07/2010 14:02:40
 thread:1 rba:(0x1a.14e9.10)
 enabled  threads:  01000000 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
 Hot Backup end marker scn: 0x0000.00000000
 aux_file is NOT DEFINED
DATA FILE #8:
  (name #15) D:\ORACLE\ORADATA\EYGLE\DATAFILE\O1_MF_PERFSTAT_5Y7DB4XR_.DBF
creation size=131072 block size=8192 status=0xe head=15 tail=15 dup=1
 tablespace 7, index=7 krfil=8 prev_file=7
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:229 scn: 0x0000.003582b1 06/29/2010 11:57:41
 Stop scn: 0xffff.ffffffff 06/28/2010 01:06:50
 Creation Checkpointed at scn:  0x0000.000e58f2 05/07/2010 14:21:07
 thread:1 rba:(0x35.14296.10)
 enabled  threads:  01000000 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
 Hot Backup end marker scn: 0x0000.00000000
 aux_file is NOT DEFINED
DATA FILE #9:
  (name #16) D:\ORACLE\ORADATA\EYGLE\DATAFILE\O1_MF_PERFSTAT_5Y7DNKYQ_.DBF
creation size=131072 block size=8192 status=0xe head=16 tail=16 dup=1
 tablespace 7, index=7 krfil=9 prev_file=8
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:212 scn: 0x0000.003582b1 06/29/2010 11:57:41
 Stop scn: 0xffff.ffffffff 06/28/2010 01:06:50
 Creation Checkpointed at scn:  0x0000.0010661e 05/07/2010 14:27:01
 thread:1 rba:(0x48.30f.10)
 enabled  threads:  01000000 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
 Hot Backup end marker scn: 0x0000.00000000
 aux_file is NOT DEFINED
DATA FILE #10:
  (name #19) D:\ORACLE\ORADATA\EYGLE\DATAFILE\O1_MF_BBED_62GJ32CX_.DBF
creation size=1280 block size=8192 status=0xe head=19 tail=19 dup=1
 tablespace 8, index=8 krfil=10 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:13 scn: 0x0000.003582b1 06/29/2010 11:57:41
 Stop scn: 0xffff.ffffffff 06/28/2010 01:06:50
 Creation Checkpointed at scn:  0x0000.00348716 06/27/2010 20:13:22
 thread:1 rba:(0xe1.33f.10)
 enabled  threads:  01000000 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
 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 #11) D:\ORACLE\ORADATA\EYGLE\DATAFILE\O1_MF_TEMP_5WQNVGO7_.TMP
creation size=2560 block size=8192 status=0x1e head=11 tail=11 dup=1
 tablespace 3, index=5 krfil=1 prev_file=0
 unrecoverable scn: 0x0000.00089fa0 04/19/2010 11:52:14
 
 
 
 
***************************************************************************
TABLESPACE RECORDS
***************************************************************************
 (size = 68, compat size = 68, section max = 100, section in-use = 8,
  last-recid= 4, 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 DADI: recno=6
 First datafile link=6  Tablespace Flag=0
 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #7 PERFSTAT: recno=7
 First datafile link=9  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 #8 BBED: recno=8
 First datafile link=10  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)
eygle 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: 3
Init time: Avg: 38513074 us, Times measured: 4
File open time: Avg: 85478 us, Times measured: 28
Log block read time: Avg: 12 us, Times measured: 144597
Data block read/claim time: Avg: 170 us, Times measured: 1000
Data block write time: Avg: 390 us
1000 change vector apply time: Avg: 292758 us, Times measured: 10
Ratio Information:
# of log blocks measured: 637607
# of data blocks measured: 10366
# of change vectors measured: 609280
 
 
 
 
***************************************************************************
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 = 227,
  last-recid= 227, old-recno = 1, last-recno = 227)
 (extent = 1, blkno = 94, numrecs = 292)
Earliest record:
 RECID #1 Recno 1 Record timestamp  04/19/10 11:52:34 Thread=1 Seq#=1 Link-Recid=0 kccic-Recid=2
  Low scn: 0x0000.00089c75 04/19/10 11:51:53 Next scn: 0x0000.0008b98f
Latest record:
 RECID #227 Recno 227 Record timestamp  06/29/10 11:57:40 Thread=1 Seq#=227 Link-Recid=226 kccic-Recid=2
  Low scn: 0x0000.00352f82 06/28/10 00:46:32 Next scn: 0x0000.003582b0
 RECID #226 Recno 226 Record timestamp  06/28/10 00:46:32 Thread=1 Seq#=226 Link-Recid=225 kccic-Recid=2
  Low scn: 0x0000.0034dc9c 06/27/10 22:09:11 Next scn: 0x0000.00352f82
 RECID #225 Recno 225 Record timestamp  06/27/10 22:09:11 Thread=1 Seq#=225 Link-Recid=224 kccic-Recid=2
  Low scn: 0x0000.00348521 06/27/10 20:10:35 Next scn: 0x0000.0034dc9c
 RECID #224 Recno 224 Record timestamp  06/27/10 20:10:35 Thread=1 Seq#=224 Link-Recid=223 kccic-Recid=2
  Low scn: 0x0000.0034322a 06/13/10 15:56:02 Next scn: 0x0000.00348521
 RECID #223 Recno 223 Record timestamp  06/13/10 15:56:02 Thread=1 Seq#=223 Link-Recid=222 kccic-Recid=2
  Low scn: 0x0000.0034236c 06/13/10 12:09:14 Next scn: 0x0000.0034322a
 RECID #222 Recno 222 Record timestamp  06/13/10 12:09:14 Thread=1 Seq#=222 Link-Recid=221 kccic-Recid=2
  Low scn: 0x0000.0033cb54 06/12/10 16:39:26 Next scn: 0x0000.0034236c
 RECID #221 Recno 221 Record timestamp  06/12/10 16:39:26 Thread=1 Seq#=221 Link-Recid=220 kccic-Recid=2
  Low scn: 0x0000.0033c8a2 06/12/10 16:39:22 Next scn: 0x0000.0033cb54
 RECID #220 Recno 220 Record timestamp  06/12/10 16:39:22 Thread=1 Seq#=220 Link-Recid=219 kccic-Recid=2
  Low scn: 0x0000.0033884f 06/08/10 09:02:38 Next scn: 0x0000.0033c8a2
 RECID #219 Recno 219 Record timestamp  06/08/10 09:02:38 Thread=1 Seq#=219 Link-Recid=218 kccic-Recid=2
  Low scn: 0x0000.00332630 06/05/10 14:54:15 Next scn: 0x0000.0033884f
 RECID #218 Recno 218 Record timestamp  06/05/10 14:54:15 Thread=1 Seq#=218 Link-Recid=217 kccic-Recid=2
  Low scn: 0x0000.00317721 05/29/10 16:04:47 Next scn: 0x0000.00332630
 RECID #217 Recno 217 Record timestamp  05/29/10 16:04:47 Thread=1 Seq#=217 Link-Recid=216 kccic-Recid=2
  Low scn: 0x0000.003118fd 05/26/10 17:39:27 Next scn: 0x0000.00317721
 RECID #216 Recno 216 Record timestamp  05/26/10 17:39:27 Thread=1 Seq#=216 Link-Recid=215 kccic-Recid=2
  Low scn: 0x0000.0030f990 05/25/10 16:22:46 Next scn: 0x0000.003118fd
 RECID #215 Recno 215 Record timestamp  05/25/10 16:22:46 Thread=1 Seq#=215 Link-Recid=214 kccic-Recid=2
  Low scn: 0x0000.00308d4e 05/15/10 19:44:22 Next scn: 0x0000.0030f990
 RECID #214 Recno 214 Record timestamp  05/15/10 19:44:22 Thread=1 Seq#=214 Link-Recid=213 kccic-Recid=2
  Low scn: 0x0000.003037d8 05/15/10 09:01:06 Next scn: 0x0000.00308d4e
 RECID #213 Recno 213 Record timestamp  05/15/10 09:01:06 Thread=1 Seq#=213 Link-Recid=212 kccic-Recid=2
  Low scn: 0x0000.002e5b3e 05/15/10 00:44:33 Next scn: 0x0000.003037d8
 RECID #212 Recno 212 Record timestamp  05/15/10 00:44:33 Thread=1 Seq#=212 Link-Recid=211 kccic-Recid=2
  Low scn: 0x0000.002d8fa3 05/11/10 10:30:59 Next scn: 0x0000.002e5b3e
 RECID #211 Recno 211 Record timestamp  05/11/10 10:30:59 Thread=1 Seq#=211 Link-Recid=210 kccic-Recid=2
  Low scn: 0x0000.002d1894 05/10/10 14:58:16 Next scn: 0x0000.002d8fa3
 RECID #210 Recno 210 Record timestamp  05/10/10 14:58:16 Thread=1 Seq#=210 Link-Recid=209 kccic-Recid=2
  Low scn: 0x0000.002c34e8 05/08/10 21:28:14 Next scn: 0x0000.002d1894
 RECID #209 Recno 209 Record timestamp  05/08/10 21:28:14 Thread=1 Seq#=209 Link-Recid=208 kccic-Recid=2
  Low scn: 0x0000.002c0417 05/08/10 21:28:05 Next scn: 0x0000.002c34e8
 RECID #208 Recno 208 Record timestamp  05/08/10 21:28:05 Thread=1 Seq#=208 Link-Recid=207 kccic-Recid=2
  Low scn: 0x0000.002bd34a 05/08/10 21:27:56 Next scn: 0x0000.002c0417
 RECID #207 Recno 207 Record timestamp  05/08/10 21:27:56 Thread=1 Seq#=207 Link-Recid=206 kccic-Recid=2
  Low scn: 0x0000.002ba299 05/08/10 21:27:45 Next scn: 0x0000.002bd34a
 RECID #206 Recno 206 Record timestamp  05/08/10 21:27:45 Thread=1 Seq#=206 Link-Recid=205 kccic-Recid=2
  Low scn: 0x0000.002ad143 05/08/10 21:27:01 Next scn: 0x0000.002ba299
 RECID #205 Recno 205 Record timestamp  05/08/10 21:27:01 Thread=1 Seq#=205 Link-Recid=204 kccic-Recid=2
  Low scn: 0x0000.002aa0bf 05/08/10 21:26:49 Next scn: 0x0000.002ad143
 RECID #204 Recno 204 Record timestamp  05/08/10 21:26:49 Thread=1 Seq#=204 Link-Recid=203 kccic-Recid=2
  Low scn: 0x0000.002a7036 05/08/10 21:26:33 Next scn: 0x0000.002aa0bf
 RECID #203 Recno 203 Record timestamp  05/08/10 21:26:33 Thread=1 Seq#=203 Link-Recid=202 kccic-Recid=2
  Low scn: 0x0000.002a3fc4 05/08/10 21:26:21 Next scn: 0x0000.002a7036
 RECID #202 Recno 202 Record timestamp  05/08/10 21:26:21 Thread=1 Seq#=202 Link-Recid=201 kccic-Recid=2
  Low scn: 0x0000.00296f4f 05/08/10 21:25:31 Next scn: 0x0000.002a3fc4
 RECID #201 Recno 201 Record timestamp  05/08/10 21:25:31 Thread=1 Seq#=201 Link-Recid=200 kccic-Recid=2
  Low scn: 0x0000.00293e9e 05/08/10 21:25:19 Next scn: 0x0000.00296f4f
 RECID #200 Recno 200 Record timestamp  05/08/10 21:25:19 Thread=1 Seq#=200 Link-Recid=199 kccic-Recid=2
  Low scn: 0x0000.00290df0 05/08/10 21:25:01 Next scn: 0x0000.00293e9e
 RECID #199 Recno 199 Record timestamp  05/08/10 21:25:01 Thread=1 Seq#=199 Link-Recid=198 kccic-Recid=2
  Low scn: 0x0000.0028dd3c 05/08/10 21:24:46 Next scn: 0x0000.00290df0
 RECID #198 Recno 198 Record timestamp  05/08/10 21:24:46 Thread=1 Seq#=198 Link-Recid=197 kccic-Recid=2
  Low scn: 0x0000.00280c6f 05/08/10 21:23:44 Next scn: 0x0000.0028dd3c
 RECID #197 Recno 197 Record timestamp  05/08/10 21:23:44 Thread=1 Seq#=197 Link-Recid=196 kccic-Recid=2
  Low scn: 0x0000.0027dbee 05/08/10 21:23:32 Next scn: 0x0000.00280c6f
 RECID #196 Recno 196 Record timestamp  05/08/10 21:23:32 Thread=1 Seq#=196 Link-Recid=195 kccic-Recid=2
  Low scn: 0x0000.0027ab4d 05/08/10 21:23:19 Next scn: 0x0000.0027dbee
 RECID #195 Recno 195 Record timestamp  05/08/10 21:23:19 Thread=1 Seq#=195 Link-Recid=194 kccic-Recid=2
  Low scn: 0x0000.00277a95 05/08/10 21:23:07 Next scn: 0x0000.0027ab4d
 RECID #194 Recno 194 Record timestamp  05/08/10 21:23:07 Thread=1 Seq#=194 Link-Recid=193 kccic-Recid=2
  Low scn: 0x0000.0026a967 05/08/10 21:22:11 Next scn: 0x0000.00277a95
 RECID #193 Recno 193 Record timestamp  05/08/10 21:22:11 Thread=1 Seq#=193 Link-Recid=192 kccic-Recid=2
  Low scn: 0x0000.002678aa 05/08/10 21:22:02 Next scn: 0x0000.0026a967
 RECID #192 Recno 192 Record timestamp  05/08/10 21:22:02 Thread=1 Seq#=192 Link-Recid=191 kccic-Recid=2
  Low scn: 0x0000.002647f6 05/08/10 21:21:53 Next scn: 0x0000.002678aa
 RECID #191 Recno 191 Record timestamp  05/08/10 21:21:53 Thread=1 Seq#=191 Link-Recid=190 kccic-Recid=2
  Low scn: 0x0000.0026175b 05/08/10 21:21:44 Next scn: 0x0000.002647f6
 RECID #190 Recno 190 Record timestamp  05/08/10 21:21:44 Thread=1 Seq#=190 Link-Recid=189 kccic-Recid=2
  Low scn: 0x0000.00254657 05/08/10 21:21:06 Next scn: 0x0000.0026175b
 RECID #189 Recno 189 Record timestamp  05/08/10 21:21:06 Thread=1 Seq#=189 Link-Recid=188 kccic-Recid=2
  Low scn: 0x0000.00251588 05/08/10 21:20:56 Next scn: 0x0000.00254657
 RECID #188 Recno 188 Record timestamp  05/08/10 21:20:56 Thread=1 Seq#=188 Link-Recid=187 kccic-Recid=2
  Low scn: 0x0000.0024e4c9 05/08/10 21:20:43 Next scn: 0x0000.00251588
 RECID #187 Recno 187 Record timestamp  05/08/10 21:20:43 Thread=1 Seq#=187 Link-Recid=186 kccic-Recid=2
  Low scn: 0x0000.0024b3d3 05/08/10 21:20:35 Next scn: 0x0000.0024e4c9
 RECID #186 Recno 186 Record timestamp  05/08/10 21:20:35 Thread=1 Seq#=186 Link-Recid=185 kccic-Recid=2
  Low scn: 0x0000.0023e34a 05/08/10 21:19:55 Next scn: 0x0000.0024b3d3
 RECID #185 Recno 185 Record timestamp  05/08/10 21:19:55 Thread=1 Seq#=185 Link-Recid=184 kccic-Recid=2
  Low scn: 0x0000.0023b2c6 05/08/10 21:19:46 Next scn: 0x0000.0023e34a
 RECID #184 Recno 184 Record timestamp  05/08/10 21:19:46 Thread=1 Seq#=184 Link-Recid=183 kccic-Recid=2
  Low scn: 0x0000.0023822f 05/08/10 21:19:36 Next scn: 0x0000.0023b2c6
 RECID #183 Recno 183 Record timestamp  05/08/10 21:19:36 Thread=1 Seq#=183 Link-Recid=182 kccic-Recid=2
  Low scn: 0x0000.00235189 05/08/10 21:19:27 Next scn: 0x0000.0023822f
 RECID #182 Recno 182 Record timestamp  05/08/10 21:19:27 Thread=1 Seq#=182 Link-Recid=181 kccic-Recid=2
  Low scn: 0x0000.0022808a 05/08/10 21:18:45 Next scn: 0x0000.00235189
 RECID #181 Recno 181 Record timestamp  05/08/10 21:18:45 Thread=1 Seq#=181 Link-Recid=180 kccic-Recid=2
  Low scn: 0x0000.00224fd3 05/08/10 21:18:35 Next scn: 0x0000.0022808a
 RECID #180 Recno 180 Record timestamp  05/08/10 21:18:35 Thread=1 Seq#=180 Link-Recid=179 kccic-Recid=2
  Low scn: 0x0000.00221f2c 05/08/10 21:18:24 Next scn: 0x0000.00224fd3
 RECID #179 Recno 179 Record timestamp  05/08/10 21:18:24 Thread=1 Seq#=179 Link-Recid=178 kccic-Recid=2
  Low scn: 0x0000.0021ee92 05/08/10 21:18:13 Next scn: 0x0000.00221f2c
 RECID #178 Recno 178 Record timestamp  05/08/10 21:18:13 Thread=1 Seq#=178 Link-Recid=177 kccic-Recid=2
  Low scn: 0x0000.00211d75 05/08/10 21:17:31 Next scn: 0x0000.0021ee92
 RECID #177 Recno 177 Record timestamp  05/08/10 21:17:31 Thread=1 Seq#=177 Link-Recid=176 kccic-Recid=2
  Low scn: 0x0000.0020eca8 05/08/10 21:17:22 Next scn: 0x0000.00211d75
 RECID #176 Recno 176 Record timestamp  05/08/10 21:17:22 Thread=1 Seq#=176 Link-Recid=175 kccic-Recid=2
  Low scn: 0x0000.0020bbeb 05/08/10 21:17:13 Next scn: 0x0000.0020eca8
 RECID #175 Recno 175 Record timestamp  05/08/10 21:17:13 Thread=1 Seq#=175 Link-Recid=174 kccic-Recid=2
  Low scn: 0x0000.00208b66 05/08/10 21:17:04 Next scn: 0x0000.0020bbeb
 RECID #174 Recno 174 Record timestamp  05/08/10 21:17:04 Thread=1 Seq#=174 Link-Recid=173 kccic-Recid=2
  Low scn: 0x0000.001fbafe 05/08/10 21:16:26 Next scn: 0x0000.00208b66
 RECID #173 Recno 173 Record timestamp  05/08/10 21:16:26 Thread=1 Seq#=173 Link-Recid=172 kccic-Recid=2
  Low scn: 0x0000.001f8a85 05/08/10 21:16:17 Next scn: 0x0000.001fbafe
 RECID #172 Recno 172 Record timestamp  05/08/10 21:16:17 Thread=1 Seq#=172 Link-Recid=171 kccic-Recid=2
  Low scn: 0x0000.001f5a1b 05/08/10 21:16:06 Next scn: 0x0000.001f8a85
 RECID #171 Recno 171 Record timestamp  05/08/10 21:16:06 Thread=1 Seq#=171 Link-Recid=170 kccic-Recid=2
  Low scn: 0x0000.001f299b 05/08/10 21:15:54 Next scn: 0x0000.001f5a1b
 RECID #170 Recno 170 Record timestamp  05/08/10 21:15:54 Thread=1 Seq#=170 Link-Recid=169 kccic-Recid=2
  Low scn: 0x0000.001e59a5 05/08/10 21:15:04 Next scn: 0x0000.001f299b
 RECID #169 Recno 169 Record timestamp  05/08/10 21:15:04 Thread=1 Seq#=169 Link-Recid=168 kccic-Recid=2
  Low scn: 0x0000.001e292b 05/08/10 21:14:53 Next scn: 0x0000.001e59a5
 RECID #168 Recno 168 Record timestamp  05/08/10 21:14:53 Thread=1 Seq#=168 Link-Recid=167 kccic-Recid=2
  Low scn: 0x0000.001df8a6 05/08/10 21:14:42 Next scn: 0x0000.001e292b
 RECID #167 Recno 167 Record timestamp  05/08/10 21:14:42 Thread=1 Seq#=167 Link-Recid=166 kccic-Recid=2
  Low scn: 0x0000.001dc840 05/08/10 21:14:31 Next scn: 0x0000.001df8a6
 RECID #166 Recno 166 Record timestamp  05/08/10 21:14:31 Thread=1 Seq#=166 Link-Recid=165 kccic-Recid=2
  Low scn: 0x0000.001cf8be 05/08/10 21:13:47 Next scn: 0x0000.001dc840
 RECID #165 Recno 165 Record timestamp  05/08/10 21:13:47 Thread=1 Seq#=165 Link-Recid=164 kccic-Recid=2
  Low scn: 0x0000.001cc87a 05/08/10 21:13:37 Next scn: 0x0000.001cf8be
 RECID #164 Recno 164 Record timestamp  05/08/10 21:13:37 Thread=1 Seq#=164 Link-Recid=163 kccic-Recid=2
  Low scn: 0x0000.001c9831 05/08/10 21:13:28 Next scn: 0x0000.001cc87a
 
 
 
 
***************************************************************************
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 03/14/08 18:46:22
  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.00089c75 04/19/10 11:51:53
  Previous Resetlogs scn and time scn: 0x0000.00000001 03/14/08 18:46:22
 Incarnation (parent inc#, flag)=(1, 2)
 RECID #1 Recno 1 Record timestamp
  Resetlogs scn and time scn: 0x0000.00000001 03/14/08 18:46:22
  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 ***



-The End-

历史上的今天...
    >> 2015-06-29文章:
    >> 2012-06-29文章:
    >> 2009-06-29文章:
    >> 2008-06-29文章:
    >> 2006-06-29文章:
           这是一个作恶的时代

By eygle on 2010-06-29 16:57 | Comments (1) | FAQ | Internal | 2566 |

1 Comment

如果转载的话,不知道博主介意不。


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com