<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cssg91583的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cssg91583</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cssg91583]]></copyright><item><title><![CDATA[使用Xtrabackup远程备份Mysql]]></title><link>https://blog.youkuaiyun.com/cssg91583/article/details/100508921</link><guid>https://blog.youkuaiyun.com/cssg91583/article/details/100508921</guid><author>cssg91583</author><pubDate>Wed, 08 May 2019 16:42:18 +0800</pubDate><description><![CDATA[参考：

https://www.percona.com/doc/percona-xtrabackup/2.4/howtos/recipes_ibkx_stream.html




https://blog....]]></description><category></category></item><item><title><![CDATA[Mysql 5.7在OL 6上以RPM包安装]]></title><link>https://blog.youkuaiyun.com/cssg91583/article/details/100508922</link><guid>https://blog.youkuaiyun.com/cssg91583/article/details/100508922</guid><author>cssg91583</author><pubDate>Mon, 25 Mar 2019 15:24:02 +0800</pubDate><description><![CDATA[系统:OL 6 X64


DB:Mysql 5.7





准备以下安装介质：mysql-5.7.25-1.el6.x86_64.rpm-bundle.tar，以及部分perl包，解压tar包，得到以下...]]></description><category></category></item><item><title><![CDATA[启用与禁用统计信息自动收集]]></title><link>https://blog.youkuaiyun.com/cssg91583/article/details/100508920</link><guid>https://blog.youkuaiyun.com/cssg91583/article/details/100508920</guid><author>cssg91583</author><pubDate>Tue, 03 Apr 2018 14:02:54 +0800</pubDate><description><![CDATA[适用于11g与12c



	
		
			点击(此处)折叠或打开
		
	
	
		
			
				11g的是 周一到周五 22：00-2：00 周六周日 6：00-4：00

			
			...]]></description><category></category></item><item><title><![CDATA[安装Cloud Control 12c]]></title><link>https://blog.youkuaiyun.com/cssg91583/article/details/100508919</link><guid>https://blog.youkuaiyun.com/cssg91583/article/details/100508919</guid><author>cssg91583</author><pubDate>Mon, 02 Apr 2018 18:04:33 +0800</pubDate><description><![CDATA[OS：Oracle Linux 6.6 x64
Cloud Control 12.1.0.5
DB:12.1.0.2

本次安装，将把OMS与OMR安装在同一主机上，系统准备可参考rdbms的安装
           ...]]></description><category></category></item><item><title><![CDATA[Trail文件中的序列号不匹配造成的进程中断]]></title><link>https://blog.youkuaiyun.com/cssg91583/article/details/100508916</link><guid>https://blog.youkuaiyun.com/cssg91583/article/details/100508916</guid><author>cssg91583</author><pubDate>Thu, 14 Jul 2016 12:29:01 +0800</pubDate><description><![CDATA[GoldenGate 12.2+Oracle 12.1.0.2

如果OGG因意外进程中断后，重启进程可能发生trail文件序列号不匹配的情况。可见如下报错：


	
		
			点击(此处)折叠或打开
		
...]]></description><category></category></item><item><title><![CDATA[12c中添加PDB后GoldenGate的配置]]></title><link>https://blog.youkuaiyun.com/cssg91583/article/details/100508914</link><guid>https://blog.youkuaiyun.com/cssg91583/article/details/100508914</guid><author>cssg91583</author><pubDate>Wed, 13 Jul 2016 16:33:05 +0800</pubDate><description><![CDATA[OS：Oracle Linux 6.6 x64 + Windows Server 2008 R2 x64
DB：Oracle RAC 12.1.0.2
GoldenGate：12.2

当前状态：
Linux上的RAC...]]></description><category></category></item><item><title><![CDATA[在RAC 12c下GoldenGate故障一则（共享文件系统文件锁）]]></title><link>https://blog.youkuaiyun.com/cssg91583/article/details/100508918</link><guid>https://blog.youkuaiyun.com/cssg91583/article/details/100508918</guid><author>cssg91583</author><pubDate>Sat, 09 Jul 2016 18:35:57 +0800</pubDate><description><![CDATA[OS：Oracle Linux 6.6 x64
DB：12.1.2.0
GoldenGate:12.2

GoldenGate目录安装在共享的ACFS上。
在ggserr.log中发现：


	
		
			...]]></description><category></category></item><item><title><![CDATA[使用GI Agent(XAG）实现GoldenGate的高可用性（二）]]></title><link>https://blog.youkuaiyun.com/cssg91583/article/details/100508915</link><guid>https://blog.youkuaiyun.com/cssg91583/article/details/100508915</guid><author>cssg91583</author><pubDate>Fri, 08 Jul 2016 17:03:52 +0800</pubDate><description><![CDATA[OS：Oracle Linux 6.6 x64，Windows Server 2008 R2 x64
DB：Oracle 12.1.2.0

参考：使用GI Agent(XAG）实现GoldenGate的高可用性（一）...]]></description><category></category></item><item><title><![CDATA[12c ASM中创建ACFS]]></title><link>https://blog.youkuaiyun.com/cssg91583/article/details/100508910</link><guid>https://blog.youkuaiyun.com/cssg91583/article/details/100508910</guid><author>cssg91583</author><pubDate>Fri, 08 Jul 2016 13:59:19 +0800</pubDate><description><![CDATA[从11g开始，可以在ASM中创建文件系统ACFS，由RAC各节点共享访问。

基本步骤：
1）grid用户进入asmca，grid用户需是asmadmin组；
2）创建磁盘组；
3）用磁盘组创建ADVM；
4）用AD...]]></description><category></category></item><item><title><![CDATA[12c多租户架构下部署GoldenGate 12c]]></title><link>https://blog.youkuaiyun.com/cssg91583/article/details/100508911</link><guid>https://blog.youkuaiyun.com/cssg91583/article/details/100508911</guid><author>cssg91583</author><pubDate>Wed, 06 Jul 2016 12:17:55 +0800</pubDate><description><![CDATA[OS：Oracle Linux 6.6 x64和Windows Server 2008 R2 x64

DB：Oracle 12.1.2.0

GoldenGate：12.2.0.1.1


注意：先参考
...]]></description><category></category></item><item><title><![CDATA[12c恢复表到指定时刻]]></title><link>https://blog.youkuaiyun.com/cssg91583/article/details/100509027</link><guid>https://blog.youkuaiyun.com/cssg91583/article/details/100509027</guid><author>cssg91583</author><pubDate>Fri, 01 Jul 2016 13:51:41 +0800</pubDate><description><![CDATA[在12c之前，TSPITR只能恢复表空间，对于其中的schema对象则无能为力。比如一个表空间中有多个schema，如果想还原其中一个schema到之前的状态，则整个表空间内的其他schema也要还原到以前的状态。

从1...]]></description><category></category></item><item><title><![CDATA[12c跨平台传输表空间]]></title><link>https://blog.youkuaiyun.com/cssg91583/article/details/100509025</link><guid>https://blog.youkuaiyun.com/cssg91583/article/details/100509025</guid><author>cssg91583</author><pubDate>Thu, 30 Jun 2016 17:11:28 +0800</pubDate><description><![CDATA[从12c开始，跨平台传输表空间的方式有所不同，11g可见：http://blog.itpub.net/22621861/viewspace-1419810/

如果尾数字节相同，则可以传输整个数据库；如果尾数字节不同，则只能...]]></description><category></category></item><item><title><![CDATA[RAC 12c中为PDB创建服务]]></title><link>https://blog.youkuaiyun.com/cssg91583/article/details/100509024</link><guid>https://blog.youkuaiyun.com/cssg91583/article/details/100509024</guid><author>cssg91583</author><pubDate>Thu, 30 Jun 2016 15:52:56 +0800</pubDate><description><![CDATA[OS：Oracle Linux 6.6 x64

DB：Oracle 12.1.0.2


使用oracle用户创建




			点击(

此处

)折叠或...]]></description><category></category></item><item><title><![CDATA[使用12c物理Standby跨网络还原丢失文件]]></title><link>https://blog.youkuaiyun.com/cssg91583/article/details/100509020</link><guid>https://blog.youkuaiyun.com/cssg91583/article/details/100509020</guid><author>cssg91583</author><pubDate>Wed, 29 Jun 2016 12:14:14 +0800</pubDate><description><![CDATA[OS：Oracle Linux 6.6 x64
DB：Oracle 12.1.0.2

从12c开始，可以使用物理备库中的对象，直接restore或recover主库中对应的对象，包括database,tablespace...]]></description><category></category></item><item><title><![CDATA[12c下使用备份集完成RMAN Duplicate]]></title><link>https://blog.youkuaiyun.com/cssg91583/article/details/100509023</link><guid>https://blog.youkuaiyun.com/cssg91583/article/details/100509023</guid><author>cssg91583</author><pubDate>Wed, 29 Jun 2016 11:31:58 +0800</pubDate><description><![CDATA[OS:Oracle Linux 6.6 x64
DB：Oracle 12.1.0.2

在12c以前，Duplicate使用的是映像备份，容量大，占用网络叫多。从12c开始，可以使用备份集来完成数据库的Duplicate。...]]></description><category></category></item><item><title><![CDATA[11g DataGuard实现故障转移（Failover）]]></title><link>https://blog.youkuaiyun.com/cssg91583/article/details/100509021</link><guid>https://blog.youkuaiyun.com/cssg91583/article/details/100509021</guid><author>cssg91583</author><pubDate>Tue, 28 Jun 2016 09:35:39 +0800</pubDate><description><![CDATA[OS：Oracle Linux 6.6 x64
DB：Oracle 11.2.0.4


假设是物理备库。如果有多个备用库，选择SYNC备用数据库（即最高可用或最大保护模式），如果是ASYNC，比较哪个备库最新：

...]]></description><category></category></item><item><title><![CDATA[physru脚本实现11g DataGuard简易滚动升级]]></title><link>https://blog.youkuaiyun.com/cssg91583/article/details/100509018</link><guid>https://blog.youkuaiyun.com/cssg91583/article/details/100509018</guid><author>cssg91583</author><pubDate>Fri, 24 Jun 2016 17:36:14 +0800</pubDate><description><![CDATA[OS：Oracle Linux 6u6 x64
DB：Oracle 11.2.0.3.0 -&gt; 11.2.0.4.0

参考MOS文档：
ID 949322.1
内有PDF文档（MAA Best Practice...]]></description><category></category></item><item><title><![CDATA[搭建逻辑Data Guard 12c]]></title><link>https://blog.youkuaiyun.com/cssg91583/article/details/100509019</link><guid>https://blog.youkuaiyun.com/cssg91583/article/details/100509019</guid><author>cssg91583</author><pubDate>Mon, 20 Jun 2016 21:28:30 +0800</pubDate><description><![CDATA[参考：http://docs.oracle.com/database/121/SBYDB/create_ls.htm#SBYDB4741

一些注意：逻辑Standby同步不如物理Standby及时，并且收到头几个日志时似乎...]]></description><category></category></item><item><title><![CDATA[使用SQL Apply实现滚动升级]]></title><link>https://blog.youkuaiyun.com/cssg91583/article/details/100509017</link><guid>https://blog.youkuaiyun.com/cssg91583/article/details/100509017</guid><author>cssg91583</author><pubDate>Mon, 20 Jun 2016 21:22:38 +0800</pubDate><description><![CDATA[OS：Oracle Linux 6.6 x64
DB：Oracle 12.1.0.1.0 -&gt; 12.1.0.2.0

参考：http://docs.oracle.com/database/121/SBYDB/rol...]]></description><category></category></item><item><title><![CDATA[12c创建Far Sync]]></title><link>https://blog.youkuaiyun.com/cssg91583/article/details/100509013</link><guid>https://blog.youkuaiyun.com/cssg91583/article/details/100509013</guid><author>cssg91583</author><pubDate>Thu, 16 Jun 2016 15:13:45 +0800</pubDate><description><![CDATA[从12c开始，Data Guard有了Far Sync特性。主库站点新建一个Far Sync实例，主库与Far Sync实例同步传输，Far Sync实例再与远程实例异步传输，避免了之前版本直接与远程实例同步传输会因网络延迟造成...]]></description><category></category></item></channel></rss>