<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[congnan2123的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/congnan2123</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; congnan2123]]></copyright><item><title><![CDATA[Redhat For Oracle11.2.0.4 RAC]]></title><link>https://blog.youkuaiyun.com/congnan2123/article/details/100366216</link><guid>https://blog.youkuaiyun.com/congnan2123/article/details/100366216</guid><author>congnan2123</author><pubDate>Wed, 27 Jun 2018 09:27:20 +0800</pubDate><description><![CDATA[Redhat For Oracle11G RAC


	一、软件准备


	##oracle包


	p13390677_112040_Linux-x86-64_1of7.zip


	p13390...]]></description><category></category></item><item><title><![CDATA[MySQL源码安装]]></title><link>https://blog.youkuaiyun.com/congnan2123/article/details/100366209</link><guid>https://blog.youkuaiyun.com/congnan2123/article/details/100366209</guid><author>congnan2123</author><pubDate>Thu, 14 Dec 2017 17:58:57 +0800</pubDate><description><![CDATA[1，下载源码安装包


	http://dev.mysql.com/downloads/mysql/ Source Code


	https://cmake.org/download/ ...]]></description><category></category></item><item><title><![CDATA[PowerDesigner版本控制]]></title><link>https://blog.youkuaiyun.com/congnan2123/article/details/100366206</link><guid>https://blog.youkuaiyun.com/congnan2123/article/details/100366206</guid><author>congnan2123</author><pubDate>Thu, 14 Dec 2017 17:51:35 +0800</pubDate><description><![CDATA[一，环境配置


	1，安装32位JDK，64位的可能配JDBC数据源时连不上, 然后PD配置,工具--&gt;常规选项


2，下载mysql驱动，配置数据源。数据库--&gt;Configure Conne...]]></description><category></category></item><item><title><![CDATA[OGG搭建步骤]]></title><link>https://blog.youkuaiyun.com/congnan2123/article/details/100366205</link><guid>https://blog.youkuaiyun.com/congnan2123/article/details/100366205</guid><author>congnan2123</author><pubDate>Wed, 06 Dec 2017 19:40:51 +0800</pubDate><description><![CDATA[AIX--&gt;HP-UX
1，下载GGS安装
tar -xvf ggs_AIX_ppc_ora102_64bit_v11_1_1_0_0_078.tar

2，创建目录
GGSCI (test4-154) 1&g...]]></description><category></category></item><item><title><![CDATA[拆分replicate]]></title><link>https://blog.youkuaiyun.com/congnan2123/article/details/100366207</link><guid>https://blog.youkuaiyun.com/congnan2123/article/details/100366207</guid><author>congnan2123</author><pubDate>Wed, 06 Dec 2017 19:38:49 +0800</pubDate><description><![CDATA[GG的抽取进程每小时大约可以抽取30-50G的日志量，而Replicat进程每小时大约只能投递一小时的日志量。
业务高峰时，数据库产生大量日志。容灾端会产生大量的堆积，replicat出现延时，需要进行拆分增加入库的速...]]></description><category></category></item><item><title><![CDATA[常用命令]]></title><link>https://blog.youkuaiyun.com/congnan2123/article/details/100366203</link><guid>https://blog.youkuaiyun.com/congnan2123/article/details/100366203</guid><author>congnan2123</author><pubDate>Wed, 06 Dec 2017 19:34:20 +0800</pubDate><description><![CDATA[查看长事务
GGSCI &gt; send extract &lt;抽取进程名&gt; , showtrans [thread n] [count n]
eg: 查看ext_1进程中节点1上最长的10个交易
ggsci &...]]></description><category></category></item><item><title><![CDATA[MAA （rac+dg）环境搭建]]></title><link>https://blog.youkuaiyun.com/congnan2123/article/details/100366199</link><guid>https://blog.youkuaiyun.com/congnan2123/article/details/100366199</guid><author>congnan2123</author><pubDate>Tue, 01 Dec 2015 00:25:52 +0800</pubDate><description><![CDATA[平台OS：linux redhaORACLE:11GR2 两个正常的RAC环境
instance node 
primary RACDB  rac...]]></description><category></category></item><item><title><![CDATA[RAC中ASM磁盘组管理]]></title><link>https://blog.youkuaiyun.com/congnan2123/article/details/100366202</link><guid>https://blog.youkuaiyun.com/congnan2123/article/details/100366202</guid><author>congnan2123</author><pubDate>Fri, 20 Nov 2015 19:13:00 +0800</pubDate><description><![CDATA[1，添加磁盘后，fdisk分区/dev/sdd (linux)
2，创建ASM磁盘
 service oracleasm createdisk VOL1 /dev/sdd1
 service ora...]]></description><category></category></item><item><title><![CDATA[SQL及SESSION 跟踪分析]]></title><link>https://blog.youkuaiyun.com/congnan2123/article/details/100366201</link><guid>https://blog.youkuaiyun.com/congnan2123/article/details/100366201</guid><author>congnan2123</author><pubDate>Thu, 12 Nov 2015 21:10:07 +0800</pubDate><description><![CDATA[1，set autotrace on/traceonly ..  
SQL&gt; @$ORACLE_HOME/rdbms/admin/utlxplan
SQL&gt; @$ORACLE_HOME/sqlplus/adm...]]></description><category></category></item><item><title><![CDATA[常见等待事件]]></title><link>https://blog.youkuaiyun.com/congnan2123/article/details/100366198</link><guid>https://blog.youkuaiyun.com/congnan2123/article/details/100366198</guid><author>congnan2123</author><pubDate>Thu, 12 Nov 2015 00:20:13 +0800</pubDate><description><![CDATA[1，buffer busy waits
  该等待事件的产生仅说明一个会话在等待一个buffer数据块。常见的原因有
  a,当一个会话准备修改一个数据块时，其被另一个会话修改；
  b,当一个会话读取一个数据...]]></description><category></category></item><item><title><![CDATA[Oracle 性能报告的三种收集方式]]></title><link>https://blog.youkuaiyun.com/congnan2123/article/details/100366196</link><guid>https://blog.youkuaiyun.com/congnan2123/article/details/100366196</guid><author>congnan2123</author><pubDate>Wed, 11 Nov 2015 23:25:44 +0800</pubDate><description><![CDATA[一、StatsPack (10g前常用的)
1，新建prefstat用户
 SQL&gt; @?/rdbms/admin/spcreate.sql  --执行该脚本自动生成用户
 ...]]></description><category></category></item><item><title><![CDATA[UNDO 表空间小结]]></title><link>https://blog.youkuaiyun.com/congnan2123/article/details/100366195</link><guid>https://blog.youkuaiyun.com/congnan2123/article/details/100366195</guid><author>congnan2123</author><pubDate>Mon, 02 Nov 2015 22:58:26 +0800</pubDate><description><![CDATA[一、UNDO表空间
 数据的四种状态
1）active： 表示transaction还没有结束，不可覆盖，
 2）unexpired:由已经commit或rollback的数据转换...]]></description><category></category></item><item><title><![CDATA[Linux修改IP和主机名]]></title><link>https://blog.youkuaiyun.com/congnan2123/article/details/100366192</link><guid>https://blog.youkuaiyun.com/congnan2123/article/details/100366192</guid><author>congnan2123</author><pubDate>Mon, 02 Nov 2015 21:41:57 +0800</pubDate><description><![CDATA[su - root


	vi /etc/sysconfig/network-scripts/ifcfg-eth0
DEVICE=eth0
BOOTPROTO=static
IPADDR=192.168.1...]]></description><category></category></item><item><title><![CDATA[RMAN 复制数据库 Duplicate Database]]></title><link>https://blog.youkuaiyun.com/congnan2123/article/details/100366197</link><guid>https://blog.youkuaiyun.com/congnan2123/article/details/100366197</guid><author>congnan2123</author><pubDate>Mon, 02 Nov 2015 21:29:15 +0800</pubDate><description><![CDATA[RMAN Duplicate Database 用于测试的database
一、基于RMAN备份，利用RMAN备份创建辅助库
二、基于RMAN网络，从源数据库通过网络rman直接创建辅助库
三、duplicate目前还不支...]]></description><category></category></item><item><title><![CDATA[手工 完全恢复 AND 不完全恢复]]></title><link>https://blog.youkuaiyun.com/congnan2123/article/details/100366254</link><guid>https://blog.youkuaiyun.com/congnan2123/article/details/100366254</guid><author>congnan2123</author><pubDate>Mon, 26 Oct 2015 21:23:44 +0800</pubDate><description><![CDATA[一、完全恢复
1，通过备份、归档日志、current log，将database恢复到failure 前最后一次commit状态
2，恢复步骤：a) CP还原所有或部分datafile; b)利用归档日志和当前日志做恢复
...]]></description><category></category></item><item><title><![CDATA[exp,imp/expdp,impdp]]></title><link>https://blog.youkuaiyun.com/congnan2123/article/details/100366193</link><guid>https://blog.youkuaiyun.com/congnan2123/article/details/100366193</guid><author>congnan2123</author><pubDate>Thu, 22 Oct 2015 20:43:41 +0800</pubDate><description><![CDATA[一、EXP\IMP
导出和导入数据库对象的四种模式是： 

	1，数据库模式：导出和导入整个数据库中的所有对象 


	2，表空间模式：导出和导入一个或多个指定的表空间中的所有对象 


	3，用户模式：导出...]]></description><category></category></item><item><title><![CDATA[查看表空间已使用和剩余空间大小]]></title><link>https://blog.youkuaiyun.com/congnan2123/article/details/100366194</link><guid>https://blog.youkuaiyun.com/congnan2123/article/details/100366194</guid><author>congnan2123</author><pubDate>Fri, 16 Oct 2015 21:07:15 +0800</pubDate><description><![CDATA[--表空间的总容量和空闲空间,表空间的碎片个数和最大的碎片
select t.tablespace_name,TOTAL_MB-FREE_MB userd_mb,FREE_MB,TOTAL_MB,number_space...]]></description><category></category></item><item><title><![CDATA[实例进程]]></title><link>https://blog.youkuaiyun.com/congnan2123/article/details/100366188</link><guid>https://blog.youkuaiyun.com/congnan2123/article/details/100366188</guid><author>congnan2123</author><pubDate>Tue, 13 Jan 2015 19:06:49 +0800</pubDate><description><![CDATA[1，实例是由内存和后台进程组成 


	2，实例是访问数据库的方法
 


	3，初始化参数控制实例的行为 


	


	4，启动实例不需要数据库，产品安装好有初始化参数文件，就可...]]></description><category></category></item><item><title><![CDATA[树状JSON]]></title><link>https://blog.youkuaiyun.com/congnan2123/article/details/100366190</link><guid>https://blog.youkuaiyun.com/congnan2123/article/details/100366190</guid><author>congnan2123</author><pubDate>Tue, 13 Aug 2013 11:34:43 +0800</pubDate><description><![CDATA[package test;


	import java.util.ArrayList;
import java.util.Comparator;
import java.util....]]></description><category></category></item><item><title><![CDATA[JAVA遍历文件夹，内容插入数据库]]></title><link>https://blog.youkuaiyun.com/congnan2123/article/details/100366191</link><guid>https://blog.youkuaiyun.com/congnan2123/article/details/100366191</guid><author>congnan2123</author><pubDate>Mon, 29 Jul 2013 17:00:46 +0800</pubDate><description><![CDATA[public class ReadFile {
private static ArrayList fileList = new ArrayList();public static void main(String[...]]></description><category></category></item></channel></rss>