<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cuijiao4641</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cuijiao4641]]></copyright><item><title><![CDATA[VMware管理平台预设的账户和密码]]></title><link>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398632</link><guid>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398632</guid><author>cuijiao4641</author><pubDate>Tue, 03 Feb 2015 16:27:53 +0800</pubDate><description><![CDATA[Horizon Application Manager

http://IP or FQDN/SAAS/login/0
http://IP or FQDNHorizon Connector

https://IP...]]></description><category></category></item><item><title><![CDATA[监控DG视图v$managed_standby字段注解]]></title><link>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398626</link><guid>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398626</guid><author>cuijiao4641</author><pubDate>Thu, 16 Oct 2014 14:57:54 +0800</pubDate><description><![CDATA[一般DG安装完之后，或者在运行中，我们都会通过一个重要的视图v$managed_standby监控各进程的状态，以及归档应用情况。
比如下面在standby 上查询如下，这里主库是RAC：
SQL&gt; select pr...]]></description><category></category></item><item><title><![CDATA[归档日志大小统计]]></title><link>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398622</link><guid>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398622</guid><author>cuijiao4641</author><pubDate>Thu, 12 Jun 2014 19:53:29 +0800</pubDate><description><![CDATA[我们可能经常需要评估每天或每小时产生的归档日志量，那么怎样计算出大小呢？
So How can we calculate archivelog size each day/hour？
主要还是查询视图V$ARCHIVED_L...]]></description><category></category></item><item><title><![CDATA[备库自动删除已应用的归档日志]]></title><link>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398619</link><guid>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398619</guid><author>cuijiao4641</author><pubDate>Thu, 12 Jun 2014 19:22:40 +0800</pubDate><description><![CDATA[经常碰到数据库因为归档日志堆积而造成磁盘空间满的情况，这里如果备库归档不备份的话，则需要定期删除。
下面的脚本在AIX6.1上运行通过：
REPORT="/tmp/delArch.log"
logtokeep=40----...]]></description><category></category></item><item><title><![CDATA[归档日志until time和Completed、Before区别]]></title><link>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398672</link><guid>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398672</guid><author>cuijiao4641</author><pubDate>Thu, 12 Jun 2014 18:52:29 +0800</pubDate><description><![CDATA[先看maclean的解释，V$ARCHIVED_LOG: 
FIRST_TIME   DATE  Timestamp of the first change
NEXT_TIME  ...]]></description><category></category></item><item><title><![CDATA[AIX6.1系统11203RAC节点down机]]></title><link>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398612</link><guid>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398612</guid><author>cuijiao4641</author><pubDate>Sat, 11 Jan 2014 09:20:46 +0800</pubDate><description><![CDATA[alert里大量的
Wed Jan 08 16:42:14 2014
IPC Send timeout detected. Sender: ospid 23396530 [oracle@ptms3db1]
Receiver...]]></description><category></category></item><item><title><![CDATA[一些生活哲学]]></title><link>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398614</link><guid>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398614</guid><author>cuijiao4641</author><pubDate>Fri, 14 Jun 2013 17:15:32 +0800</pubDate><description><![CDATA[【一手置天】银行家的儿子问爸爸：“爸爸，银行里的钱都是客户和储户的。那你是怎样赚来房子、奔驰车和游艇的呢？”银行家：“儿子，冰箱里有一块肥肉，你把它拿来。”儿子拿来了。“再放回去吧。”儿子问：“什么意思？”银行家说：“你...]]></description><category></category></item><item><title><![CDATA[Oracle 11gR2 RAC的关闭和启动]]></title><link>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398621</link><guid>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398621</guid><author>cuijiao4641</author><pubDate>Sat, 25 May 2013 02:18:36 +0800</pubDate><description><![CDATA[之前记录了10g RAC的手工关闭和启动，现在经常接触的11g R2的RAC，因为版本差别很大，所以关闭的方式区别也大，具体是11g RAC更简单了。
先转一段具体描述：在Oracle 11gR2 下的RAC，架构发生了变化。...]]></description><category></category></item><item><title><![CDATA[CRS and Voting模拟丢失后恢复]]></title><link>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398611</link><guid>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398611</guid><author>cuijiao4641</author><pubDate>Tue, 14 May 2013 14:23:49 +0800</pubDate><description><![CDATA[a) CRS loss
rm –f /oracle01/oracrs/ocr.dbf

[oracle@oracle crsd]$ rm -f /oracle01/oracrs/ocr.dbf
Impact: No i...]]></description><category></category></item><item><title><![CDATA[转载详细的Oracle ASH/AWR介绍及报告分析]]></title><link>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398610</link><guid>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398610</guid><author>cuijiao4641</author><pubDate>Fri, 10 May 2013 17:40:49 +0800</pubDate><description><![CDATA[http://space.itpub.net/?uid-35489-action-viewspace-itemid-697546
http://space.itpub.net/?uid-35489-action-viewspa...]]></description><category></category></item><item><title><![CDATA[Oracle Database 11G R2 标准版 企业版 下载地址]]></title><link>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398618</link><guid>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398618</guid><author>cuijiao4641</author><pubDate>Thu, 25 Apr 2013 13:29:48 +0800</pubDate><description><![CDATA[oracle 11.2.0.3 下载地址:Linuxx64 :https://updates.oracle.com/Orion/Services/download/p10404530_112030_Linux-x86-64_1...]]></description><category></category></item><item><title><![CDATA[Three commands for OCR maintenance]]></title><link>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398608</link><guid>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398608</guid><author>cuijiao4641</author><pubDate>Mon, 25 Mar 2013 11:03:47 +0800</pubDate><description><![CDATA[1, ocrconfig,For ocrconfig,we can use the following options for repository maintenance:backuploc. 这个选项可以改变OCR...]]></description><category></category></item><item><title><![CDATA[count(*) 和count(column)之区别]]></title><link>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398601</link><guid>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398601</guid><author>cuijiao4641</author><pubDate>Thu, 06 Dec 2012 23:42:23 +0800</pubDate><description><![CDATA[select count (*)、count(1)、count(column)的区别如下：•count(1) 中的 1 并不是表示为第一个 column•count(*) 跟 count(1) 的结果一样，包...]]></description><category></category></item><item><title><![CDATA[转个分区表Local索引Rebuild的总结]]></title><link>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398598</link><guid>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398598</guid><author>cuijiao4641</author><pubDate>Tue, 06 Nov 2012 18:41:29 +0800</pubDate><description><![CDATA[今天一个脚本里面的一条build index老是出现ORA-00054: resource busy and acquire with NOWAIT specified 错误，错误本身比较容易理解，肯定是有排他锁限制了对Part...]]></description><category></category></item><item><title><![CDATA[drop表空间以及对应的数据文件后空间不释放的问题]]></title><link>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398615</link><guid>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398615</guid><author>cuijiao4641</author><pubDate>Thu, 25 Oct 2012 18:36:45 +0800</pubDate><description><![CDATA[执行drop tablespace PSGLOG INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;后，在磁盘上可以看到对应的datafile已经不存在了，但是d...]]></description><category></category></item><item><title><![CDATA[Oracle什么情况下需要rebuild index]]></title><link>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398609</link><guid>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398609</guid><author>cuijiao4641</author><pubDate>Wed, 08 Aug 2012 14:52:52 +0800</pubDate><description><![CDATA[主要还是看index的扁平程度,Rebuild the index when : - deleted entries represent 20% or more of the current entries -...]]></description><category></category></item><item><title><![CDATA[Oracle数据库维护常用的SQL代码示例(zt)]]></title><link>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398607</link><guid>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398607</guid><author>cuijiao4641</author><pubDate>Sun, 01 Jul 2012 00:52:39 +0800</pubDate><description><![CDATA[1、求当前会话的SID，SERIAL#SELECT Sid, Serial# FROM V$session WHERE Audsid = Sys_Context('USERENV', 'SESSIONID');2、查询...]]></description><category></category></item><item><title><![CDATA[RAC环境Library Cache Lock的处理方法(zt)]]></title><link>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398604</link><guid>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398604</guid><author>cuijiao4641</author><pubDate>Wed, 27 Jun 2012 17:23:26 +0800</pubDate><description><![CDATA[我要监控某个Job,该session 处于 Library cache lock 等待中数据库有2个节点SQL&gt; select inst_id from gv$instance; INST_ID-------...]]></description><category></category></item><item><title><![CDATA[表外键未加索引之处理]]></title><link>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398644</link><guid>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398644</guid><author>cuijiao4641</author><pubDate>Mon, 18 Jun 2012 16:13:11 +0800</pubDate><description><![CDATA[就像在Tom编程艺术中提到的，如果数据库中确实存在死锁，那么需要查看是否存在未加索引的外键，而且在99%的情况下都会发现表中确实存在这个问题。只需对外键加索引，死锁（以及大量其他的竞争问题）都会烟消云散。下面的例子就展...]]></description><category></category></item><item><title><![CDATA[How to disable data guard]]></title><link>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398613</link><guid>https://blog.youkuaiyun.com/cuijiao4641/article/details/100398613</guid><author>cuijiao4641</author><pubDate>Thu, 14 Jun 2012 19:50:04 +0800</pubDate><description><![CDATA[如果启用了DGRMGL，那么需要先disable it.Asuming you can use DGMGRL start dgmgrl and connect to the primary database.
For exam...]]></description><category></category></item></channel></rss>