<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[congkai0287的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/congkai0287</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; congkai0287]]></copyright><item><title><![CDATA[几年前的一个关于 archive+parallel+append+nologging的一个测试]]></title><link>https://blog.youkuaiyun.com/congkai0287/article/details/100365017</link><guid>https://blog.youkuaiyun.com/congkai0287/article/details/100365017</guid><author>congkai0287</author><pubDate>Tue, 22 Jan 2013 15:06:49 +0800</pubDate><description><![CDATA[总结:





理论上讲,只要启用直接路径插入方式(所谓直接路径插入，就是绕过Buffer cache，直接将数据插入进表所在数据文件中),就几乎不产生undo,而redo不是不产生,只是产生...]]></description><category></category></item><item><title><![CDATA[gg]]></title><link>https://blog.youkuaiyun.com/congkai0287/article/details/100364882</link><guid>https://blog.youkuaiyun.com/congkai0287/article/details/100364882</guid><author>congkai0287</author><pubDate>Tue, 22 Jan 2013 15:06:49 +0800</pubDate><description><![CDATA[************************************************************************* Run Time Messages...]]></description><category></category></item><item><title><![CDATA[抓sql，取lob]]></title><link>https://blog.youkuaiyun.com/congkai0287/article/details/100364876</link><guid>https://blog.youkuaiyun.com/congkai0287/article/details/100364876</guid><author>congkai0287</author><pubDate>Tue, 22 Jan 2013 14:42:59 +0800</pubDate><description><![CDATA[DECLARE -- FILE1 UTL_FILE.FILE_TYPE; v_sql VARCHAR2(4000); file_name varchar2(100); v_buf...]]></description><category></category></item><item><title><![CDATA[使用outline固定执行计划]]></title><link>https://blog.youkuaiyun.com/congkai0287/article/details/100364883</link><guid>https://blog.youkuaiyun.com/congkai0287/article/details/100364883</guid><author>congkai0287</author><pubDate>Fri, 23 Nov 2012 15:01:14 +0800</pubDate><description><![CDATA[执行计划会根据数据库表的统计信息该表而改变,我们要使某个SQL固定不变的使用某个执行计划,可以通过oralce里的outline来实现,查询的SQL语句必须跟outline里定义的完全相同.

条件值固定的outl...]]></description><category></category></item><item><title><![CDATA[ASM实例管理]]></title><link>https://blog.youkuaiyun.com/congkai0287/article/details/100364881</link><guid>https://blog.youkuaiyun.com/congkai0287/article/details/100364881</guid><author>congkai0287</author><pubDate>Fri, 23 Nov 2012 14:56:33 +0800</pubDate><description><![CDATA[环境:
OS:Red Hat Linux As5
DB:10.2.0.4
RAC:两个节点

一、ASM实例管理
1.手工启动ASM实例(节点1)
$export ORACLE_SID=+ASM1
$s...]]></description><category></category></item><item><title><![CDATA[使用ASMCA添加磁盘组]]></title><link>https://blog.youkuaiyun.com/congkai0287/article/details/100364880</link><guid>https://blog.youkuaiyun.com/congkai0287/article/details/100364880</guid><author>congkai0287</author><pubDate>Fri, 23 Nov 2012 14:55:10 +0800</pubDate><description><![CDATA[环境:
OS:Red Hat Linux As 5
DB:11.2.0.1

1.查看当前磁盘情况(root用户)[root@hxl ~]# fdisk -l
Disk /dev/sda: 21.4 GB, 2147...]]></description><category></category></item><item><title><![CDATA[单实例ASM备份集在另一台普通文件管理的机器恢复]]></title><link>https://blog.youkuaiyun.com/congkai0287/article/details/100364879</link><guid>https://blog.youkuaiyun.com/congkai0287/article/details/100364879</guid><author>congkai0287</author><pubDate>Fri, 23 Nov 2012 14:52:14 +0800</pubDate><description><![CDATA[环境:
OS:Red Hat Linux As 5
原库:11.2.0.1(ASM)
目的库:11.2.0.1(普通文件)

在ASM管理的数据库上使用RMAN备份集,将该备份集COPY到另一台机器上(普通文...]]></description><category></category></item><item><title><![CDATA[使用duplicate database 创建物理standby database]]></title><link>https://blog.youkuaiyun.com/congkai0287/article/details/100364878</link><guid>https://blog.youkuaiyun.com/congkai0287/article/details/100364878</guid><author>congkai0287</author><pubDate>Fri, 23 Nov 2012 14:42:05 +0800</pubDate><description><![CDATA[piece handle=/u01/app/oracle/duplicate/al_t775282475_s98_p1 tag=TAG20120215T041426channel ORA_AUX_DISK_1: restore ...]]></description><category></category></item><item><title><![CDATA[物理standby database的日常维护]]></title><link>https://blog.youkuaiyun.com/congkai0287/article/details/100364877</link><guid>https://blog.youkuaiyun.com/congkai0287/article/details/100364877</guid><author>congkai0287</author><pubDate>Fri, 23 Nov 2012 14:40:52 +0800</pubDate><description><![CDATA[环境:
OS:Red Hat Linux As5
DB:10.2.0.1

1.停止Standby
select process, status from v$managed_standby; --查看备库是...]]></description><category></category></item><item><title><![CDATA[Latch入门]]></title><link>https://blog.youkuaiyun.com/congkai0287/article/details/100364874</link><guid>https://blog.youkuaiyun.com/congkai0287/article/details/100364874</guid><author>congkai0287</author><pubDate>Wed, 21 Nov 2012 10:53:41 +0800</pubDate><description><![CDATA[(入门1)一直想点文章关于Latch的，又一直没写，一是因为懒，二是一直觉得现在关于Latch的书那么多，还有必要写吗？后来，看到了一些帖子：1.一个帖子，帖主发现了大量cache buffer chain，检查...]]></description><category></category></item><item><title><![CDATA[shell提示符的个性化设定]]></title><link>https://blog.youkuaiyun.com/congkai0287/article/details/100364972</link><guid>https://blog.youkuaiyun.com/congkai0287/article/details/100364972</guid><author>congkai0287</author><pubDate>Wed, 21 Nov 2012 10:06:21 +0800</pubDate><description><![CDATA[shell提示符的个性化设定（二）：终端显示颜色的设置
PS1="\[\033[1;32;40m[\033[0;32;40m\u@\h:\033[1;35;40m\w\033[1;32;40m]\033[1;31;40m\$\...]]></description><category></category></item><item><title><![CDATA[Linux awk命令说明]]></title><link>https://blog.youkuaiyun.com/congkai0287/article/details/100364924</link><guid>https://blog.youkuaiyun.com/congkai0287/article/details/100364924</guid><author>congkai0287</author><pubDate>Tue, 20 Nov 2012 14:10:27 +0800</pubDate><description><![CDATA[一. AWK 说明 awk是一种编程语言，用于在linux/unix下对文本和数据进行处理。数据可以来自标准输入、一个或多个文件，或其它命令的输出。它支持用户自定义函数和动态正则表达式等先进功能，是linux/un...]]></description><category></category></item><item><title><![CDATA[Unix sar 命令]]></title><link>https://blog.youkuaiyun.com/congkai0287/article/details/100509569</link><guid>https://blog.youkuaiyun.com/congkai0287/article/details/100509569</guid><author>congkai0287</author><pubDate>Tue, 20 Nov 2012 14:05:27 +0800</pubDate><description><![CDATA[在使用UNIX操作系统的过程中，我们常常会用到各种各样的问题，比如系统运行速度突然变慢，系统容易死机或者主机所带的终端常出现死机，这时我们常常猜测，是硬盘空间太小，还是内存不足？I/O出现瓶颈，或者是系统的核心参数出了问题？这时...]]></description><category></category></item><item><title><![CDATA[stty 命令]]></title><link>https://blog.youkuaiyun.com/congkai0287/article/details/100364923</link><guid>https://blog.youkuaiyun.com/congkai0287/article/details/100364923</guid><author>congkai0287</author><pubDate>Tue, 20 Nov 2012 13:32:03 +0800</pubDate><description><![CDATA[UNIX系统的命令很多，下面讲解stty.该命令是一个用来改变并打印终端行设置的常用命令。
1．stty(settty，设置tty)命令用于检查和修改当前注册的终端的通信参数。UNIX系统为键盘的输入和终端的输出提供了...]]></description><category></category></item><item><title><![CDATA[oracle中的with as语法]]></title><link>https://blog.youkuaiyun.com/congkai0287/article/details/100364875</link><guid>https://blog.youkuaiyun.com/congkai0287/article/details/100364875</guid><author>congkai0287</author><pubDate>Mon, 19 Nov 2012 17:55:49 +0800</pubDate><description><![CDATA[语法：WITH query_name AS (subquery) [, query_name AS (subquery) ]...使用在主select关键字前，oracle将其当做一个内联视图或者临时表使用。
例子...]]></description><category></category></item><item><title><![CDATA[rman基本命令]]></title><link>https://blog.youkuaiyun.com/congkai0287/article/details/100364871</link><guid>https://blog.youkuaiyun.com/congkai0287/article/details/100364871</guid><author>congkai0287</author><pubDate>Tue, 06 Nov 2012 16:38:02 +0800</pubDate><description><![CDATA[RMAN1. cataloggrant recover_catalog_owner to rman;rman catalog rman/rmanRMAN&gt;create catalog tablespace ora...]]></description><category></category></item><item><title><![CDATA[rman迁移库]]></title><link>https://blog.youkuaiyun.com/congkai0287/article/details/100364872</link><guid>https://blog.youkuaiyun.com/congkai0287/article/details/100364872</guid><author>congkai0287</author><pubDate>Tue, 06 Nov 2012 16:33:31 +0800</pubDate><description><![CDATA[步骤
环境
执行时间
具体操作
注意事项

维护时间开始处理，通知运营停止应用
AIX测试环境(z3bi1050)
　
　
　

将数据库起到read only模式...]]></description><category></category></item><item><title><![CDATA[起库操作手册]]></title><link>https://blog.youkuaiyun.com/congkai0287/article/details/100364873</link><guid>https://blog.youkuaiyun.com/congkai0287/article/details/100364873</guid><author>congkai0287</author><pubDate>Tue, 06 Nov 2012 16:30:13 +0800</pubDate><description><![CDATA[注意，时间点需要提前复核，其他的可以做完再一起复核。
一、启库(1至4步第一轮搭建需要，之后不需要）1.生成profile文件。Copy原库的profile并修改SID。再根据实际情况修改ORACLE_HOME, ORACL...]]></description><category></category></item><item><title><![CDATA[自动删除archielog的脚本]]></title><link>https://blog.youkuaiyun.com/congkai0287/article/details/100364869</link><guid>https://blog.youkuaiyun.com/congkai0287/article/details/100364869</guid><author>congkai0287</author><pubDate>Tue, 06 Nov 2012 16:28:52 +0800</pubDate><description><![CDATA[删除archivelog的脚本和cron设置
g2cs6010:10g:dmbecif &gt; pwd
/paic/bank/becif/data/otbecif/.cronjob
g2cs6010:10g:dmbe...]]></description><category></category></item><item><title><![CDATA[查看日志sequence，追log]]></title><link>https://blog.youkuaiyun.com/congkai0287/article/details/100364870</link><guid>https://blog.youkuaiyun.com/congkai0287/article/details/100364870</guid><author>congkai0287</author><pubDate>Tue, 06 Nov 2012 16:24:33 +0800</pubDate><description><![CDATA[select max(sequence#)+1,min(sequence#)-1,thread# from v$log_history where  first_time  and first_time&gt...]]></description><category></category></item></channel></rss>