<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cuilingqiao0657的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cuilingqiao0657</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cuilingqiao0657]]></copyright><item><title><![CDATA[不为人知的技术--Oracle并行异步执行存储过程]]></title><link>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492644</link><guid>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492644</guid><author>cuilingqiao0657</author><pubDate>Tue, 04 Jun 2019 11:07:25 +0800</pubDate><description><![CDATA[背景：



最近遇到一个case，Client端程式调用存储过程SP1，过程SP1执行完成后返回结果到Client。


因为过程SP1执行时间要5秒钟，时间太长Client用户无法接受。


分析...]]></description><category></category></item><item><title><![CDATA[SQL书写规范(通用)]]></title><link>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492574</link><guid>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492574</guid><author>cuilingqiao0657</author><pubDate>Mon, 27 May 2019 18:19:40 +0800</pubDate><description><![CDATA[SQL语句是访问DB中数据的主要途径和方式，所以SQL的书写对访问数据库时的速度和性能起着至关重要的作用。




本文针对SQL日常书写中遇到的一些常见问题和注意事项做说明。







注...]]></description><category></category></item><item><title><![CDATA[Redis Sentinel哨兵模式原理及配置]]></title><link>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492575</link><guid>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492575</guid><author>cuilingqiao0657</author><pubDate>Tue, 21 May 2019 16:17:48 +0800</pubDate><description><![CDATA[之前文章介绍了redis replication主从高可用架构，

现在延伸下，本文讨论redis replication架构下实现自动故障切换(automatic failover)的技术--Sentinel

...]]></description><category></category></item><item><title><![CDATA[为SQL Server快照snapshot DB建立login访问]]></title><link>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492613</link><guid>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492613</guid><author>cuilingqiao0657</author><pubDate>Mon, 20 May 2019 17:12:41 +0800</pubDate><description><![CDATA[为了提供sql server的报表查询功能，通常在备库mirror上建立定时snapshot job以提供web查询。





但是众所周知的是快照DB只读不可写，所以直接在备库建立login mapping及...]]></description><category></category></item><item><title><![CDATA[Redis replication主从复制原理及配置]]></title><link>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492612</link><guid>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492612</guid><author>cuilingqiao0657</author><pubDate>Wed, 15 May 2019 12:15:59 +0800</pubDate><description><![CDATA[本文主要介绍Redis replication 主从复制原理和配置及基本操作

等





主要参考官方文档：





https://redis.io/topics/replicatio...]]></description><category></category></item><item><title><![CDATA[Oracle standby的ORA-01578 ORA-01110 ORA-26040 坑爹的NOLOGGING]]></title><link>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492607</link><guid>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492607</guid><author>cuilingqiao0657</author><pubDate>Wed, 08 May 2019 17:44:35 +0800</pubDate><description><![CDATA[异常：








DB: Oracle 11.2.0.1 --版本够low的


五一假期时给用户DB做了switch over主备切换后，用了发现切换后新的主库DB中报错如下：

...]]></description><category></category></item><item><title><![CDATA[Oracle12C ORA-01516报错可能是没有切换到PDB]]></title><link>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492616</link><guid>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492616</guid><author>cuilingqiao0657</author><pubDate>Tue, 26 Mar 2019 11:22:46 +0800</pubDate><description><![CDATA[一次问题：Oracle 12C DB因为主备库server数据文件所在路径不一致，在主库新增datafile后报错：




Thu Mar 22 10:36:06 2019

Errors in file /...]]></description><category></category></item><item><title><![CDATA[Zabbix系统MySQL数据库分区表的设定--精简说明]]></title><link>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492640</link><guid>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492640</guid><author>cuilingqiao0657</author><pubDate>Wed, 20 Mar 2019 17:14:36 +0800</pubDate><description><![CDATA[Zabbix监控中对后台MySQL DB几张历史大表依照时间进行分区无疑可以提高zabbix by时间查询时的性能，可以在zabbix后台DB在安装之初就将table设定为分区表，也可以在使用一段时间后已经有时间的情况下设定...]]></description><category></category></item><item><title><![CDATA[SQL Server ceiling向上取小数]]></title><link>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492610</link><guid>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492610</guid><author>cuilingqiao0657</author><pubDate>Fri, 01 Mar 2019 14:58:56 +0800</pubDate><description><![CDATA[用户需求：向上取小数


比如: 70.0123 取70.02

      15.3689 取15.37

      70.0100 取70.01



就是說小...]]></description><category></category></item><item><title><![CDATA[非域环境下SQL Server mirror建立]]></title><link>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492573</link><guid>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492573</guid><author>cuilingqiao0657</author><pubDate>Fri, 22 Feb 2019 09:49:35 +0800</pubDate><description><![CDATA[环境：





SQLServer2012SP1




主：10.202.11.47




备：10.202.11.49




不配置见证服务器




...]]></description><category></category></item><item><title><![CDATA[MAC address(物理地址)重复导致的网络故障]]></title><link>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492604</link><guid>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492604</guid><author>cuilingqiao0657</author><pubDate>Fri, 22 Feb 2019 09:37:02 +0800</pubDate><description><![CDATA[这两天用户向IT反映

Client

程式访问DB时经常出现了超时，SA,DBA检查DB server和相关网络均正常。


初步怀疑时

Client

程式所在PC相关的异常。




...]]></description><category></category></item><item><title><![CDATA[Flashback database必须要有之前的archivelog吗？]]></title><link>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492602</link><guid>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492602</guid><author>cuilingqiao0657</author><pubDate>Sat, 19 Jan 2019 15:33:03 +0800</pubDate><description><![CDATA[有人问开启了DB级别的flashback(

alter database flashback on

)后，因为误操作想还原DB到之前的某个正常的时间点，这个时间点前的flashback log存在但

arc...]]></description><category></category></item><item><title><![CDATA[SQL Server建立dblink至MySQL]]></title><link>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492572</link><guid>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492572</guid><author>cuilingqiao0657</author><pubDate>Thu, 10 Jan 2019 17:18:16 +0800</pubDate><description><![CDATA[在SQL Server 建立Linked server至MySQL访问数据，和linked server至Oracle类似，操作如下


软件版本：


SQL Server 2012


MySQL 5....]]></description><category></category></item><item><title><![CDATA[Oracle 12C RAC的单机Standby returning error ORA-16191]]></title><link>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492634</link><guid>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492634</guid><author>cuilingqiao0657</author><pubDate>Mon, 10 Dec 2018 12:04:07 +0800</pubDate><description><![CDATA[寒风凌厉大雪节气的周末冻得出不了门，坐在家中喝热茶，突然接到朋友从公司打来的电话：为Oracle 12C RAC主库安装好的单机standby DB日志无法和主库同步报错ORA-16191





DB版本：O...]]></description><category></category></item><item><title><![CDATA[standby上增加tempfile报错ORA-00604,ORA-16000解决方法]]></title><link>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492606</link><guid>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492606</guid><author>cuilingqiao0657</author><pubDate>Tue, 31 Jul 2018 15:33:26 +0800</pubDate><description><![CDATA[众所周知在DG中对primary增加tempfile不会同步到standby上，所以增加tempfile需要在standby上操作，但这次在standby上增加tempfile却报错ORA-00604 ORA-16000 (...]]></description><category></category></item><item><title><![CDATA[因为CPU数变化导致执行sar命令报错：Invalid system activity file: /var/log/sa/saxx]]></title><link>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492571</link><guid>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492571</guid><author>cuilingqiao0657</author><pubDate>Mon, 30 Jul 2018 08:59:16 +0800</pubDate><description><![CDATA[29号早上9点对一台Linux redhat 6 的VM(虚拟机)在调整CPU数(2-&gt;8)后发现，sar 查看当天CPU loading时，报错：





[root@vswhInd4DBt ~]# s...]]></description><category></category></item><item><title><![CDATA[Windows下安装PostgreSQL初体验(使用Installer)]]></title><link>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492569</link><guid>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492569</guid><author>cuilingqiao0657</author><pubDate>Wed, 18 Jul 2018 14:58:51 +0800</pubDate><description><![CDATA[Windows下使用图形化的Installer安装PostgreSQL 9.6







下载




进入官网后

https://www.postgresql.org/download...]]></description><category></category></item><item><title><![CDATA[SQLSERVER 2012从2000还原失败：Restore of database failed]]></title><link>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492570</link><guid>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492570</guid><author>cuilingqiao0657</author><pubDate>Mon, 02 Jul 2018 15:59:26 +0800</pubDate><description><![CDATA[一次系统迁移，需要将SQLSERVER 2000 DB备份还原到SQLSERVER 2012，对SQL2000 DB backup后在SQL2012 SSMS中resotre时失败了并报错：

TITLE: Micro...]]></description><category></category></item><item><title><![CDATA[主库到standby报错解决：Error 12154 received logging on to the standby ORA-12154]]></title><link>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492567</link><guid>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492567</guid><author>cuilingqiao0657</author><pubDate>Thu, 14 Jun 2018 15:29:33 +0800</pubDate><description><![CDATA[背景：
笔者建库无数，但今天对Oracle 11.2.0.3库使用duplicate新建standby后，主库redo无法通过RFS传输至standby

主库alert.log报错： 
Thu Jun 14 14:05...]]></description><category></category></item><item><title><![CDATA[通过RMAN备份standby database成功恢复还原]]></title><link>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492566</link><guid>https://blog.youkuaiyun.com/cuilingqiao0657/article/details/100492566</guid><author>cuilingqiao0657</author><pubDate>Tue, 08 May 2018 16:20:45 +0800</pubDate><description><![CDATA[前言：为了提升系统安全，通常会在primary DB+standbyDB之外再做一份备份。但直接对primary DB备份可能会带来性能问题，所以决定在standby DB(open_mode:READ ONLY WITH A...]]></description><category></category></item></channel></rss>