- 博客(15)
- 资源 (1)
- 收藏
- 关注
转载 少吃盐,一定要少吃盐!
出差在外,看着对面医院的大楼上打出条幅“盐与高血压——两个无声的杀手”,甚是感慨。有人也许会问,为人类提供美味的盐,为何成了人类的杀手呢? 当盐摄入增加,机体必须升高血压以利于多余的盐分排出,就如同排污增加时污水处理厂需要加紧工作一样。为此,世界卫生组织要求所有人群都应减少盐的摄入, 建议每日食盐量不超过6g。这一标准属于中等量,因为人们实际上需要的食
2009-04-21 09:02:00 1003
原创 SUN领导给我们的一封信。
Todays Sun/OracleAnnouncementThis is one of thetoughest emails Ive ever had to write.Its also one of themost hopeful about Suns future in theindustry.For 27 years, Su
2009-04-21 08:59:00 591
原创 ORACLE收购SUN了
甲骨文斥资74亿美元欲收购Sun收购Sun公司对ORACLE来说绝对是多赢之举。对我们ORACLE DBA来说也是一件大好事。
2009-04-21 08:51:00 575
原创 Test on quota
# cd /export/home/# >quotas# chmod 600 quotas # edquota oracle"/tmp/EdP.azHa4p1" 1 line, 72 characters fs /export/home blocks (soft = 0, hard = 0) inodes (soft = 10, hard = 10)"/tmp/EdP.az
2009-04-16 13:36:00 528
原创 准备好好复习一下SOLARIS。
一个建立ZONE的简单步骤刚刚在自己机器上测试通过:# zonecfg usage: zonecfg help zonecfg -z (interactive) zonecfg -z zonecfg -z -f Commands:add (global scope)add
2009-04-16 10:59:00 722
原创 ORA-01861: literal does not match format string 错误!
SQL> CREATE OR REPLACE PROCEDURE "SGREPORTS"."METRIC_DATA_ROLLUP" (rollup_time DATE) 2 AS 3 default_time DATE := rollup_time; 4 BEGIN 5 begin 6 EXECUTE IMMEDIATE (ALTER SESSION
2009-04-14 09:46:00 5639
原创 The standard way to recover the lost file.
SQL> startupORACLE instance started.Total System Global Area 1224736768 bytesFixed Size 1279916 bytesVariable Size 503318612 bytesDatabase Buffers 704643072 bytes
2009-04-09 11:25:00 870
原创 A test on RMAN new feather--recover.
-bash-3.00$ rman target /Recovery Manager: Release 10.2.0.2.0 - Production on Thu Apr 9 10:49:21 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.connected to target database: ORCL (DBID=120
2009-04-09 10:59:00 623
原创 Create an error!
Simulate a datafile was lost accidently.shutdown database then rm test01.dbf.startup the database again.SQL> SQL> SQL> SQL> startupORACLE instance started.Total System Global Area 1224736768 bytesFixe
2009-04-09 10:53:00 423
原创 Add another scenario for rman test:
Add another scenario:SQL> conn test/testConnected.SQL> insert into test select * from user_objects;1 row created.SQL> commit;Commit complete.SQL> select count(*) from test; COUNT(*)----------
2009-04-09 10:48:00 450
原创 A test on RMAN new feather--backup.
List the steps for backup with "backup incremental level 1 for recover of copy" command.Only list the steps.There is no many explaination on this.Modify the rman parameter first.$ rman target /R
2009-04-09 09:22:00 541
原创 Can not startup the second node on RAC.
Got the following error from alert log.Wed Apr 8 03:41:38 2009starting up 1 dispatcher(s) for network address (ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))...MMNL started with pid=23, OS id=26761Wed Apr
2009-04-08 15:52:00 1769
原创 QFS损坏,数据文件丢失的解决办法。
普通表使用MOVE。分区表使用exchange.BEFORE:select count(*) from sgreports.metric_data_daily partition (metric_data_daily_2009_feb) *ERROR at line 1:ORA-00376: file 91 cannot be rea
2009-04-08 13:05:00 552
原创 Solve RMAN-06056: could not access datafile 91
Got an error said the RMAN backup failed this morning.RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN
2009-04-03 09:09:00 1827
原创 来北京三年整。
公元2006的3月31日离开了我学习工作接近十年的大连,赶在06年4月1日这天早上6点来到北京。我喜欢4月1日这个日子,这个节日。“苹果”电脑创始人之一斯蒂夫·乔布斯 的演讲里有一句说得很好:"Stay Hungry. Stay Foolish."!翻译过来就更好了:“求知若饥,虚心若愚。”!到今天已经来北京三年了。时间飞逝,回首三年前的今天,我到达了这个伟大的城市,初来北京的情景
2009-04-01 12:57:00 643
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人