February 27, 2007
结束假期 回到北京
作者:eygle
出处:http://blog.eygle.com
我们回来了，回到了北京。
坐着南航的小飞机，在漫天迷雾中，叮叮咣咣的降落在北京机场。南方和北方的差异是那么的明显，一个潮湿、一个干燥，回到北京马上就感觉到触手可及的静电无处不在，而在广东，天气一直都是那么潮湿温热，虽然是冬天。
婚礼热闹而快乐，我的家人和Julia的家人欢聚一堂，气氛热烈而幸福，度过了一个愉快的假期。
Julia的很多朋友从外地赶来参加婚礼，从香港、美国、广州...，非常感谢这些朋友：）
回到北京，新的一年、新的生活重新开始。
希望这一年能有更多的收获。
先Show一张我的新娘：
老婆的相册里有一些照片，刚刚上传的，婚纱照太大，还没有整理好。
http://picasaweb.google.com/Julia.hhj
-No End-
Posted by eygle at 9:19 AM | Comments (26)
February 17, 2007
新年快乐-百度已至 谷歌未达
作者:eygle
出处:http://blog.eygle.com
新年已经来到了，今天下午，我们就要离开北京，飞往广东，在此祝贺所有的朋友们新年快乐,万事如意!
顺便看了一下Baidu的新年Logo，一个粉娃娃和粉猪猪，煞是可爱：
可析看不到Google的，谷歌的Logo没变化，Google.com一上去，马上就被封，GFW仍然强劲。
虽然Google已经在中国作出了大量的让步和努力，但是谷歌仍然是一块鸡肋，难怪一度传说Google会调整在华的战略。
只好回顾一下去年Google的造型：
补充一下Google的新年Logo：
你好2007!
-The End-
Posted by eygle at 9:37 AM | Comments (7)
February 15, 2007
ORA-00701 warmstarting对象的另类解决方法
作者:eygle
出处:http://blog.eygle.com
有朋友在ITPUB问到一个问题，如何resize一个SYSTEM表空间。
从常规来说，如果我们希望resize一个文件，这个文件能够resize的部分必然是没有数据，未被使用的，也就是说，我们需要找到一个文件最高的Extent号，这个Extent之外的空间是可以被resize的,以下一个查询可以帮我们找到一个文件最末端的对象:
col segment_name for a30
col owner for a10
SELECT *
FROM (SELECT owner, segment_name,segment_type,block_id, blocks
FROM dba_extents
WHERE tablespace_name = 'SYSTEM' and file_id='&fileid'
ORDER BY block_id DESC)
WHERE ROWNUM < 11;
看一下我的一个数据库:
SQL> col segment_name for a30
SQL> col owner for a10
SQL> SELECT *
2 FROM (SELECT owner, segment_name,segment_type,block_id, blocks
3 FROM dba_extents
4 WHERE tablespace_name = 'SYSTEM' and file_id='&fileid'
5 ORDER BY block_id DESC)
6 WHERE ROWNUM < 11;
Enter value for fileid: 1
old 4: WHERE tablespace_name = 'SYSTEM' and file_id='&fileid'
new 4: WHERE tablespace_name = 'SYSTEM' and file_id='1'
OWNER SEGMENT_NAME SEGMENT_TYPE BLOCK_ID BLOCKS
---------- ------------------------------ ------------------ ---------- ----------
SYS EYGLE_IP TABLE 25609 128
SYS EYGLE_IP TABLE 25481 128
SYS EYGLE_IP TABLE 25353 128
SYS I_H_OBJ#_COL# INDEX 25305 8
SYS TEST TABLE 25297 8
SYS I_TEST INDEX 25289 8
SYS TEST TABLE 25281 8
SYS T TABLE 25273 8
SYS EYGLE_IP TABLE 25265 8
SYS EYGLE_IP TABLE 25257 8
10 rows selected.
我们注意到高水位上有些索引是可以通过rebuild来改变其位置的，但是在正常模式下，Oracle不允许rebuild这些索引:
SQL> alter index I_H_OBJ#_COL# rebuild;
alter index I_H_OBJ#_COL# rebuild
*
ERROR at line 1:
ORA-00701: object necessary for warmstarting database cannot be altered
有两种方式可以使得这些对象允许被重建:
1.通过migrate模式
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup migrate;
ORACLE instance started.Total System Global Area 139531744 bytes
Fixed Size 452064 bytes
Variable Size 121634816 bytes
Database Buffers 16777216 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> alter index I_H_OBJ#_COL# rebuild;Index altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.Total System Global Area 139531744 bytes
Fixed Size 452064 bytes
Variable Size 121634816 bytes
Database Buffers 16777216 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
2.通过一个内部事件
SQL> alter system set event='38003 trace name context forever, level 10' scope=spfile;System altered.
SQL> startup force;
ORACLE instance started.Total System Global Area 139531744 bytes
Fixed Size 452064 bytes
Variable Size 121634816 bytes
Database Buffers 16777216 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> alter index i_h_obj#_col# rebuild;Index altered.
38003事件的作用是:CBO Disable column stats for the dictionary objects in recursive SQL
也就是说可以将部分对象从启动的bootstrap$需要里剥离出来，从而可以被在线rebuild.
这个事件能够影响的对象很有限，这类操作也是极其危险的，所以不在这里详细列出。
-The End-
Posted by eygle at 10:07 AM | Comments (4)
February 14, 2007
新年 新婚
作者:eygle
出处:http://blog.eygle.com
办公室里的人已经渐渐少起来，很多同事都已经回家过年。
我们也要开始计划行程，去年这个时候，正为一张票而烦恼，今年的新年将在江门度过，我和Julia将在那里举行婚礼；早早就订好了机票，只等起飞的那一天。
爸爸妈妈、姐姐姐夫，还有小外甥都会一起到江门，举家南下，50年所未有之盛况:)
婚礼的日期定在初六（2月23日），经多方查证，那是一个幸运的日子。希望以后长长的一生里，我和Julia以及将来的Baby都能幸福且幸运：）
去年的2.13日，从江门看Julia回到北京；所以2006年的今日是一个人在北京度过的；转眼就是一年，今年的这个日子，终于可以和亲爱的人一起度过。
幻想着婚礼那一天的情景，一定是热闹、快乐而幸福的，想起给朋友做伴郎的那个婚礼，虽然喧闹、劳累，但是婚礼真的是神圣，幸福、责任、家庭在那一刻落地生根，两个人从此有了一个姓氏...
Posted by eygle at 10:08 AM | Comments (56)
February 13, 2007
阵列增加硬盘导致IO错误一例
作者:eygle
出处:http://blog.eygle.com
前几天一个朋友的数据库出了点问题，传来的一段警告日志包含如下错误信息:
ORA-01114: IO error writing block to file 15 (block # 1)
ORA-27041: unable to open file
Linux Error: 30: Read-only file system
Additional information: 3
Thu Feb 8 15:57:58 2007
Errors in file /oracle/admin/ccdb/udump/ccdb_ora_30307.trc:
ORA-01110: data file 14: '/data/system05.dbf'
ORA-01114: IO error writing block to file 14 (block # 1)
ORA-27041: unable to open file
Linux Error: 30: Read-only file system
Additional information: 3
Thu Feb 8 15:57:58 2007
Errors in file /oracle/admin/ccdb/udump/ccdb_ora_30307.trc:
ORA-01110: data file 13: '/data/system04.dbf'
ORA-01114: IO error writing block to file 13 (block # 1)
ORA-27041: unable to open file
Linux Error: 30: Read-only file system
Additional information: 3
....
Thu Feb 8 15:57:58 2007
Errors in file /oracle/admin/ccdb/bdump/ccdb_dbw0_30282.trc:
ORA-01186: file 11 failed verification tests
ORA-01122: database file 11 failed verification check
ORA-01110: data file 11: '/data/system02.dbf'
ORA-01208: data file is an old version - not accessing current version
Thu Feb 8 15:57:58 2007
File 11 not verified due to error ORA-01122
Thu Feb 8 15:57:58 2007
ORA-1221 signalled during: ALTER DATABASE OPEN...
一系列的错误提示都表明IO出了问题，经过询问得知，用户正在更换硬盘IBM的盘阵，刚刚插入了5块硬盘，结果发现数据库出现了问题，关闭之后就无法启动。
让用户把刚加入的硬盘拔掉，reboot一下盘阵，数据库恢复了正常。
不清楚是IBM什么型号的盘阵，加硬盘导致故障还是第一次遇到，记录一下.
-The End-
Posted by eygle at 10:59 PM | Comments (3)
February 12, 2007
旧书以及新书 新年以及旧年
作者:eygle
出处:http://blog.eygle.com
今天和我的《深入浅出Oracle》一书的编辑聊了一会，了解了一下这本书的销售情况。
截至到目前，本书共印刷了8000册，库存尚有1200册，也就是卖出或在途/在店的一共有6800册。
我说:哇，滞销了。
编辑说:没有了，Tom的《Oracle9i&10g编程艺术》也差不多，同样印了8000册，Tom的书库存还有1700册。
这下平衡了，不管怎样，销量能和Tom的书差的不太远我就满足了。
前几天和wzy等ACE们一起吃饭，大家一致认为写书能发财,问我写一本书能赚多少钱。
我告诉他们具体数字之后，大家又异口同声的说:精神收获更重要!
恩，不管玩笑也好，认真也好，还真是精神收获更重要，趁自己还没忘却的时候，把自己的知识拿出来和大家分享，是一种快乐，更是另一种形式的收获。
所以现在计划再写下去，在新的一年来临的时候，把这本书作为另外一件礼物....
而写作，已经有了另外一种象征。
-The End-
Posted by eygle at 3:01 PM | Comments (6)
Oracle10g 控制文件的改变
作者:eygle
出处:http://blog.eygle.com
前几天说过，Oracle10g Events CONTROLF的改变，当时猜测控制文件的变化可能是为了满足Oracle10g Grid运算支持大量并行实例的需要。
单实例节点控制文件转储包含的位图如下:
Database checkpoint: Thread=1 scn: 0x0000.0007276a
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
今天转储了一个RAC数据库的控制文件，验证了这个猜测：
***************************************************************************
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)
12/27/2006 16:25:27
DB Name "EYGLE"
Database flags = 0x00404000 0x00001000
Controlfile Creation Timestamp 12/27/2006 16:25:30
Incmplt recovery scn: 0x0000.00000000
Resetlogs scn: 0x0000.00000001 Resetlogs Timestamp 12/27/2006 16:25:27
Prior resetlogs scn: 0x0000.00000000 Prior resetlogs Timestamp 01/01/1988 00:00:00
Redo Version: compatible=0xa200100
#Data files = 5, #Online files = 5
Database checkpoint: Thread=2 scn: 0x0000.008a8531
Threads: #Enabled=2, #Open=2, Head=2, Tail=1
enabled threads: 01100000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
Oracle不断的将位图引入数据库的各个管理单元，显然旨在性能提高。
-The End-
Posted by eygle at 10:48 AM | Comments (0)
February 9, 2007
幸运的以及更幸运的
作者:eygle
出处:http://blog.eygle.com
今天下午公司举行Annual Party,晚会历来大家最关心的就是抽奖。所以一众人等坚持熬到最后，看着ipod被同事拿走，又看着手机被同事拿走，再看着DC被同事拿走....这些都是幸运的人....
可是还有更幸运的，晚会最后，老板们现场发挥，决定捐钱出来抽奖，造就一个Lucky One，于是CEO,CFO....争相解囊，最后集资33,666￥，这个幸运大奖最终被公司财务部的一位女同事拿走。这位同事是更幸运的人。
可是，也许还有更幸运的人吧。
晚会现场，公司的很多艺人到达现场，包括黄征、韩东等人，当然还有张靓颖。
靓颖简简单单的一件夹克衫，小女孩一般，可是赢得的是最多的喝彩和关注，很多人拿到了她的签名，我想对于凉粉来说，他们也是最幸运的人吧。
各种奖品没俺的份，想想已经习惯了，历年的晚会抽奖从来没中过，不过俺的没中奖却使得其他的人更加幸运，也算是功德一件吧，阿弥陀佛!
-The End-
Posted by eygle at 10:04 PM | Comments (6)
February 8, 2007
Oracle ACE China的一个小小聚会
作者:eygle
出处:http://blog.eygle.com
昨晚，Oracle广州的Jack.Han来到北京，大家在雕刻时光·丽都店有了一个小小的聚会。
到场的有Kamus、Coolyl、Yangtingkun、Wzy，再加上 Eygle + Julia，这次聚会算是ACE China的一个Party（除了Fenng没有到场），这些刚成为ACE的兄弟们都是Jack.Han推荐的，他目前负责Oracle中国的开发者论坛工作，ACE的遴选和推荐也是他的工作之一。
感谢Jack.Han的推荐，我也有幸获得了Oracle的ACE称号。
一度有朋友问ACE这个词是什么意思，其实ACE就是扑克牌里的A，从金山词霸上可以得到如下一些解释：
ace [eis] n. (纸牌、骰子等的)么, 同花色中最大的牌
一点, 小点, 微粒
爱斯(假设的基本粒子)
杰出的人才
战斗成绩卓著的空军战斗员, 王牌飞行员(从第一次世界大战起, 美、法均将击落5架以上敌机的飞行员授予“王牌”称号, 德国为10架, 英国无此称号)
(网球赛中的)一分
Oracle这样解释其ACE计划:
Oracle ACE 计划旨在确认并奖励为倡导和推广 Oracle 技术做出贡献的 Oracle 开发人员和 DBA。ACE 的获奖者将基于其在 Oracle 技术社区中所作贡献大小来定。
目前的ACE名单上包含很多大名鼎鼎的人物：Kyte Tom,Lewis Jonathan,Rogers Howard J ....
和这些专家并列，是一种荣誉更是一种激励，我们需要更多的努力不断提升自己，以使得这个称号更具实际意义。
当然国内有很多技术专家没有参加这次的推荐活动，像biti,chao_ping,dcba,piner...都是这个领域的成名人物，希望将来有越来越多的中国人称为ACE。
-The End-
Posted by eygle at 9:17 AM | Comments (6)
February 7, 2007
Oracle10g Events CONTROLF的改变
作者:eygle
出处:http://blog.eygle.com
《深入浅出Oracle》的一个读者在我的留言板上提出一个问题，他说以下这条命令运行生成的跟踪文件和我书上的结果完全不同：
alter session set events 'immediate trace name controlf level 10';
注意一下他的输出:
DUMP OF CONTROL FILES, Seq # 2017 = 0x7e1
V10 STYLE FILE HEADER:
Compatibility Vsn = 169869568=0xa200100
Db ID=2395540743=0x8ec90d07, Db Name='TESTDB'
Activation ID=0=0x0
Control Seq=2017=0x7e1, File size=932=0x3a4
File Number=0, Blksiz=16384, File Type=1 CONTROL
原来是V10 Style的输出，这是Oracle10g的数据库，我书中第一章的测试来自Oracle9iR2，由于events是Oracle的内部事件，其行为在不同的版本中可能不同。
在Oracle10g中，使用Level 8的trace，得到以下的输出.
在这个输出中，和Oracle9i最大的不同是enabled threads部分增强了位图信息，这个信息的增加我猜测是为了满足Oracle10g Grid运算支持大量并行实例的需要.Level 10及的trace将包含DUMP memory的信息，可读性又有所降低了。
记录一下，还有待于进一步研究：
DUMP OF CONTROL FILES, Seq # 522 = 0x20a
V10 STYLE FILE HEADER:
Compatibility Vsn = 169869568=0xa200100
Db ID=1417824532=0x54824914, Db Name='EYGLE'
Activation ID=0=0x0
Control Seq=522=0x20a, 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)
08/17/2006 19:41:08
DB Name "EYGLE"
Database flags = 0x00404000 0x00001000
Controlfile Creation Timestamp 08/17/2006 19:41:09
Incmplt recovery scn: 0x0000.00000000
Resetlogs scn: 0x0000.00000001 Resetlogs Timestamp 08/17/2006 19:41:08
Prior resetlogs scn: 0x0000.00000000 Prior resetlogs Timestamp 01/01/1988 00:00:00
Redo Version: compatible=0xa200100
#Data files = 4, #Online files = 4
Database checkpoint: Thread=1 scn: 0x0000.0007276a
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.0005a8ebscn: 0x0000.00000000
Activation ID: 1417764628
Controlfile Checkpointed at scn: 0x0000.0007281d 02/07/2007 10:20:47
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:24
low cache rba:(0x17.14dc8.0) on disk rba:(0x17.14df3.0)
on disk scn: 0x0000.0007335c 02/07/2007 11:34:28
resetlogs scn: 0x0000.00000001 08/17/2006 19:41:08
heartbeat: 613912496 mount id: 1433005479
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)=17/ 8/2006
Next AutoBackup sequence= 0
Database recovery target inc#:1, Last open inc#:1
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
***************************************************************************
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:2 last used seq#:0x17
enabled at scn: 0x0000.00000001 08/17/2006 19:41:33
disabled at scn: 0x0000.00000000 01/01/1988 00:00:00
opened at 02/07/2007 10:20:31 by instance eygle
Checkpointed at scn: 0x0000.0007276a 02/07/2007 10:20:31
thread:1 rba:(0x17.13a4d.10)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
....
log history: 22
***************************************************************************
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 #1) D:\ORADATA\EYGLE\ONLINELOG\O1_MF_1_2G8OGOQG_.LOG
(name #2) D:\ORADATA\FLASH_RECOVERY_AREA\EYGLE\ONLINELOG\O1_MF_1_2G8OGTJH_.LOG
Thread 1 redo log links: forward: 2 backward: 0
siz: 0x19000 seq: 0x00000016 hws: 0xd bsz: 512 nab: 0x6ed8 flg: 0x0 dup: 2
Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.0005a8eb
Low scn: 0x0000.00063e6d 01/25/2007 17:15:06
Next scn: 0x0000.0006b865 02/02/2007 10:44:31
LOG FILE #2:
(name #3) D:\ORADATA\EYGLE\ONLINELOG\O1_MF_2_2G8OGZKN_.LOG
(name #4) D:\ORADATA\FLASH_RECOVERY_AREA\EYGLE\ONLINELOG\O1_MF_2_2G8OH3JL_.LOG
Thread 1 redo log links: forward: 3 backward: 1
siz: 0x19000 seq: 0x00000017 hws: 0x11 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 2
Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.00063e6d
Low scn: 0x0000.0006b865 02/02/2007 10:44:31
Next scn: 0xffff.ffffffff 01/01/1988 00:00:00
LOG FILE #3:
(name #5) D:\ORADATA\EYGLE\ONLINELOG\O1_MF_3_2G8OH65Q_.LOG
(name #6) D:\ORADATA\FLASH_RECOVERY_AREA\EYGLE\ONLINELOG\O1_MF_3_2G8OH8XX_.LOG
Thread 1 redo log links: forward: 0 backward: 2
siz: 0x19000 seq: 0x00000015 hws: 0xf bsz: 512 nab: 0x18ffd flg: 0x0 dup: 2
Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.000591bc
Low scn: 0x0000.0005a8eb 01/25/2007 11:22:46
Next scn: 0x0000.00063e6d 01/25/2007 17:15:06
***************************************************************************
DATA FILE RECORDS
***************************************************************************
(size = 428, compat size = 428, section max = 100, section in-use = 4,
last-recid= 9, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 11, numrecs = 100)
DATA FILE #1:
(name #7) D:\ORADATA\EYGLE\DATAFILE\O1_MF_SYSTEM_2G8OHFX6_.DBF
creation size=38400 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:86 scn: 0x0000.0007276a 02/07/2007 10:20:31
Stop scn: 0xffff.ffffffff 02/05/2007 16:41:32
Creation Checkpointed at scn: 0x0000.00000009 08/17/2006 19:41:47
thread:1 rba:(0x1.3.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
....
00000000 00000000 00000000 00000000 00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
DATA FILE #2:
(name #8) D:\ORADATA\EYGLE\DATAFILE\O1_MF_UNDOTBS1_2G8OJ6NB_.DBF
creation size=25600 block size=8192 status=0xe head=8 tail=8 dup=1
tablespace 1, index=2 krfil=2 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:86 scn: 0x0000.0007276a 02/07/2007 10:20:31
Stop scn: 0xffff.ffffffff 02/05/2007 16:41:32
Creation Checkpointed at scn: 0x0000.000013cc 08/17/2006 19:42:07
thread:1 rba:(0x1.4a1b.10)
enabled threads: 01000000 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
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
DATA FILE #3:
(name #9) D:\ORADATA\EYGLE\DATAFILE\O1_MF_SYSAUX_2G8OJHP9_.DBF
creation size=15360 block size=8192 status=0xe head=9 tail=9 dup=1
tablespace 2, index=3 krfil=3 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:86 scn: 0x0000.0007276a 02/07/2007 10:20:31
Stop scn: 0xffff.ffffffff 02/05/2007 16:41:32
Creation Checkpointed at scn: 0x0000.0000144e 08/17/2006 19:42:13
thread:1 rba:(0x1.4ac4.10)
enabled threads: 01000000 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
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
DATA FILE #4:
(name #11) D:\ORADATA\EYGLE\DATAFILE\O1_MF_USERS_2G8OJYYS_.DBF
creation size=640 block size=8192 status=0xe head=11 tail=11 dup=1
tablespace 4, index=5 krfil=4 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:85 scn: 0x0000.0007276a 02/07/2007 10:20:31
Stop scn: 0xffff.ffffffff 02/05/2007 16:41:32
Creation Checkpointed at scn: 0x0000.00001f92 08/17/2006 19:42:23
thread:1 rba:(0x1.74f7.10)
enabled threads: 01000000 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
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 = 2,
last-recid= 5, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 89, numrecs = 100)
TEMP FILE #1: External File #201
(name #10) D:\ORADATA\EYGLE\DATAFILE\O1_MF_TEMP_2G8OJPDX_.TMP
creation size=2560 block size=8192 status=0x1e head=10 tail=10 dup=1
tablespace 3, index=4 krfil=1 prev_file=0
unrecoverable scn: 0x0000.00001654 08/17/2006 19:42:14
TEMP FILE #2: External File #202
creation size=128000 block size=8192 status=0xc head=0 tail=0 dup=0
tablespace 5, index=6 krfil=1 prev_file=0
unrecoverable scn: 0x0000.0003320a 01/08/2007 16:43:52
***************************************************************************
TABLESPACE RECORDS
***************************************************************************
(size = 68, compat size = 68, section max = 100, section in-use = 6,
last-recid= 9, 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 #3 TEMP: recno=4
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 #4 USERS: recno=5
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 #2147483647 TEMP1: recno=6
First datafile link=0 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
***************************************************************************
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: 27724313 us, Times measured: 4
File open time: Avg: 112894 us, Times measured: 16
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: 143264 us, Times measured: 28
Ratio Information:
# of log blocks measured: 698471
# of data blocks measured: 32871
# of change vectors measured: 1457654
***************************************************************************
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 = 22,
last-recid= 22, old-recno = 1, last-recno = 22)
(extent = 1, blkno = 94, numrecs = 292)
Earliest record:
RECID #1 Recno 1 Record timestamp 08/17/06 19:45:30 Thread=1 Seq#=1 Link-Recid=0 kccic-Recid=1
Low scn: 0x0000.00000001 08/17/06 19:41:33 Next scn: 0x0000.0000850a
Latest record:
RECID #22 Recno 22 Record timestamp 02/02/07 10:44:31 Thread=1 Seq#=22 Link-Recid=21 kccic-Recid=1
Low scn: 0x0000.00063e6d 01/25/07 17:15:06 Next scn: 0x0000.0006b865
RECID #21 Recno 21 Record timestamp 01/25/07 17:15:06 Thread=1 Seq#=21 Link-Recid=20 kccic-Recid=1
Low scn: 0x0000.0005a8eb 01/25/07 11:22:46 Next scn: 0x0000.00063e6d
RECID #20 Recno 20 Record timestamp 01/25/07 11:22:47 Thread=1 Seq#=20 Link-Recid=19 kccic-Recid=1
Low scn: 0x0000.000591bc 01/25/07 11:21:16 Next scn: 0x0000.0005a8eb
RECID #19 Recno 19 Record timestamp 01/25/07 11:21:17 Thread=1 Seq#=19 Link-Recid=18 kccic-Recid=1
Low scn: 0x0000.00055826 01/25/07 11:20:02 Next scn: 0x0000.000591bc
RECID #18 Recno 18 Record timestamp 01/25/07 11:20:02 Thread=1 Seq#=18 Link-Recid=17 kccic-Recid=1
Low scn: 0x0000.00052492 01/25/07 11:16:18 Next scn: 0x0000.00055826
RECID #17 Recno 17 Record timestamp 01/25/07 11:16:18 Thread=1 Seq#=17 Link-Recid=16 kccic-Recid=1
Low scn: 0x0000.0004fb00 01/25/07 11:03:35 Next scn: 0x0000.00052492
RECID #16 Recno 16 Record timestamp 01/25/07 11:03:36 Thread=1 Seq#=16 Link-Recid=15 kccic-Recid=1
Low scn: 0x0000.0004b072 01/13/07 15:53:08 Next scn: 0x0000.0004fb00
RECID #15 Recno 15 Record timestamp 01/13/07 15:53:08 Thread=1 Seq#=15 Link-Recid=14 kccic-Recid=1
Low scn: 0x0000.00045da5 01/13/07 15:30:39 Next scn: 0x0000.0004b072
RECID #14 Recno 14 Record timestamp 01/13/07 15:30:40 Thread=1 Seq#=14 Link-Recid=13 kccic-Recid=1
Low scn: 0x0000.0003eaff 01/12/07 15:27:28 Next scn: 0x0000.00045da5
RECID #13 Recno 13 Record timestamp 01/12/07 15:27:28 Thread=1 Seq#=13 Link-Recid=12 kccic-Recid=1
Low scn: 0x0000.00039857 01/09/07 15:09:27 Next scn: 0x0000.0003eaff
RECID #12 Recno 12 Record timestamp 01/09/07 15:09:27 Thread=1 Seq#=12 Link-Recid=11 kccic-Recid=1
Low scn: 0x0000.0003100e 09/25/06 10:19:55 Next scn: 0x0000.00039857
RECID #11 Recno 11 Record timestamp 09/25/06 10:19:55 Thread=1 Seq#=11 Link-Recid=10 kccic-Recid=1
Low scn: 0x0000.0002c06a 08/22/06 10:46:44 Next scn: 0x0000.0003100e
RECID #10 Recno 10 Record timestamp 08/22/06 10:46:44 Thread=1 Seq#=10 Link-Recid=9 kccic-Recid=1
Low scn: 0x0000.00026213 08/17/06 20:13:42 Next scn: 0x0000.0002c06a
RECID #9 Recno 9 Record timestamp 08/17/06 20:13:42 Thread=1 Seq#=9 Link-Recid=8 kccic-Recid=1
Low scn: 0x0000.00022efa 08/17/06 20:11:46 Next scn: 0x0000.00026213
RECID #8 Recno 8 Record timestamp 08/17/06 20:11:47 Thread=1 Seq#=8 Link-Recid=7 kccic-Recid=1
Low scn: 0x0000.0001f3d5 08/17/06 19:57:06 Next scn: 0x0000.00022efa
RECID #7 Recno 7 Record timestamp 08/17/06 19:57:06 Thread=1 Seq#=7 Link-Recid=6 kccic-Recid=1
Low scn: 0x0000.0001b362 08/17/06 19:53:44 Next scn: 0x0000.0001f3d5
RECID #6 Recno 6 Record timestamp 08/17/06 19:53:44 Thread=1 Seq#=6 Link-Recid=5 kccic-Recid=1
Low scn: 0x0000.00017065 08/17/06 19:52:02 Next scn: 0x0000.0001b362
RECID #5 Recno 5 Record timestamp 08/17/06 19:52:02 Thread=1 Seq#=5 Link-Recid=4 kccic-Recid=1
Low scn: 0x0000.000150ed 08/17/06 19:49:57 Next scn: 0x0000.00017065
RECID #4 Recno 4 Record timestamp 08/17/06 19:49:58 Thread=1 Seq#=4 Link-Recid=3 kccic-Recid=1
Low scn: 0x0000.00012232 08/17/06 19:48:01 Next scn: 0x0000.000150ed
RECID #3 Recno 3 Record timestamp 08/17/06 19:48:01 Thread=1 Seq#=3 Link-Recid=2 kccic-Recid=1
Low scn: 0x0000.0000e17f 08/17/06 19:46:46 Next scn: 0x0000.00012232
RECID #2 Recno 2 Record timestamp 08/17/06 19:46:47 Thread=1 Seq#=2 Link-Recid=1 kccic-Recid=1
Low scn: 0x0000.0000850a 08/17/06 19:45:30 Next scn: 0x0000.0000e17f
RECID #1 Recno 1 Record timestamp 08/17/06 19:45:30 Thread=1 Seq#=1 Link-Recid=0 kccic-Recid=1
Low scn: 0x0000.00000001 08/17/06 19:41:33 Next scn: 0x0000.0000850a
***************************************************************************
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 = 1,
last-recid= 1, old-recno = 1, last-recno = 1)
(extent = 1, blkno = 138, numrecs = 292)
Earliest record:
RECID #1 Recno 1 Record timestamp
Resetlogs scn and time scn: 0x0000.00000001 08/17/06 19:41:08
Previous Resetlogs scn and time scn: 0x0000.00000000 01/01/88 00:00:00
Incarnation (parent inc#, flag)=(0, 2)
Latest record:
RECID #1 Recno 1 Record timestamp
Resetlogs scn and time scn: 0x0000.00000001 08/17/06 19:41:08
Previous Resetlogs scn and time scn: 0x0000.00000000 01/01/88 00:00:00
Incarnation (parent inc#, flag)=(0, 2)
***************************************************************************
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-
Posted by eygle at 11:28 AM | Comments (0)