<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[风中清淡]]></title><description><![CDATA[随心分享]]></description><link>https://blog.youkuaiyun.com/wanbin6470398</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; wanbin6470398]]></copyright><item><title><![CDATA[Oracle DRM]]></title><link>https://blog.youkuaiyun.com/wanbin6470398/article/details/86604924</link><guid>https://blog.youkuaiyun.com/wanbin6470398/article/details/86604924</guid><author>wanbin6470398</author><pubDate>Wed, 23 Jan 2019 16:30:59 +0800</pubDate><description><![CDATA[演示DRM过程修改相关隐含参数
修改相关隐含参数

]]></description><category></category></item><item><title><![CDATA[GI启动流程图CSS层面]]></title><link>https://blog.youkuaiyun.com/wanbin6470398/article/details/86539936</link><guid>https://blog.youkuaiyun.com/wanbin6470398/article/details/86539936</guid><author>wanbin6470398</author><pubDate>Fri, 18 Jan 2019 14:53:34 +0800</pubDate><description><![CDATA[


]]></description><category></category></item><item><title><![CDATA[GI启动流程图OHAS层面]]></title><link>https://blog.youkuaiyun.com/wanbin6470398/article/details/86522551</link><guid>https://blog.youkuaiyun.com/wanbin6470398/article/details/86522551</guid><author>wanbin6470398</author><pubDate>Thu, 17 Jan 2019 16:34:30 +0800</pubDate><description><![CDATA[GI启动流程图OHAS层面


]]></description><category></category></item><item><title><![CDATA[模拟私网问题导致节点宕机无法启动]]></title><link>https://blog.youkuaiyun.com/wanbin6470398/article/details/86493885</link><guid>https://blog.youkuaiyun.com/wanbin6470398/article/details/86493885</guid><author>wanbin6470398</author><pubDate>Tue, 15 Jan 2019 22:37:18 +0800</pubDate><description><![CDATA[模拟私网问题导致节点宕机无法启动目的分析过程GI alert日志ocssd.log 日志os日志
目的
本文章通过模拟私网问题，导致集群节点宕机，来进行日志分析。
# ifconfig eth1 down

分析过程
GI alert日志
&amp;amp;amp;amp;amp;lt;GI_HOME&amp;amp;amp;amp;amp;gt;/log/&amp;amp;amp;amp;amp;lt;节点名称&amp;amp;amp;amp;amp;gt;alert&amp;amp;amp;amp;am]]></description><category></category></item><item><title><![CDATA[模拟丢失OLR导致RAC节点不能启动]]></title><link>https://blog.youkuaiyun.com/wanbin6470398/article/details/86490845</link><guid>https://blog.youkuaiyun.com/wanbin6470398/article/details/86490845</guid><author>wanbin6470398</author><pubDate>Tue, 15 Jan 2019 13:55:15 +0800</pubDate><description><![CDATA[模拟丢失OLR导致RAC节点不能启动1. OLR2. OLR备份3. 模拟OLR丢失4. 问题分析4.1 确认GI启动阶段5. 恢复OLR文件参考文档
1. OLR
OLR是保存在本地的集群注册表。
OLR主要作用就是为ohasd守护进程提供集群的配置信息和初始化资源的定义信息。
当集群启动时会从/etc/oracle/olr.loc中读取OLR的位置，OLR默认保存在&amp;amp;lt;GI_HOME&amp;amp;gt...]]></description><category></category></item><item><title><![CDATA[Oracle 11g DBMS_SQLTUNE]]></title><link>https://blog.youkuaiyun.com/wanbin6470398/article/details/85006802</link><guid>https://blog.youkuaiyun.com/wanbin6470398/article/details/85006802</guid><author>wanbin6470398</author><pubDate>Sat, 15 Dec 2018 21:30:36 +0800</pubDate><description><![CDATA[Oracle 11g DBMS_SQLTUNE创建调优任务语法参考文档
创建调优任务
语法

SQL text format:DBMS_SQLTUNE.CREATE_TUNING_TASK(
  sql_text         IN CLOB,
  bind_list        IN sql_binds := NULL,
  user_name        IN VARCHAR2  := ...]]></description><category></category></item><item><title><![CDATA[如何在数据库hang住时收集诊断信息]]></title><link>https://blog.youkuaiyun.com/wanbin6470398/article/details/84945451</link><guid>https://blog.youkuaiyun.com/wanbin6470398/article/details/84945451</guid><author>wanbin6470398</author><pubDate>Mon, 10 Dec 2018 21:10:27 +0800</pubDate><description><![CDATA[如何在数据库hang住时收集诊断信息诊断“数据库hang住”问题需要什么？Dumps 和Traces文件Hanganalyze 和 Systemstate Dumps收集Hanganalyze 和 Systemstate DumpsHanganalyze和Systemstate级别的说明参考文档
当数据库看起来hang住时，从数据库收集信息以确定hang住的根本原因很有用。 hang住的根本原因通...]]></description><category></category></item><item><title><![CDATA[在有位图索引的表上进行DML操作与enq: TX - row lock contention等待事件问题分析]]></title><link>https://blog.youkuaiyun.com/wanbin6470398/article/details/84870116</link><guid>https://blog.youkuaiyun.com/wanbin6470398/article/details/84870116</guid><author>wanbin6470398</author><pubDate>Fri, 07 Dec 2018 11:29:18 +0800</pubDate><description><![CDATA[在位图索引的表上进行DML操作与enq: TX - row lock contention等待事件问题分析前言模拟场景总结
前言
本文通过模拟实验，来分析 有位图索引的表的DML操作 对数据库造成的影响。
模拟场景


生成数据
SQL&amp;amp;gt; create table bm_table (id number, name varchar2(20), gender varchar2(1));
SQL...]]></description><category></category></item><item><title><![CDATA[用Merge改写优化Update]]></title><link>https://blog.youkuaiyun.com/wanbin6470398/article/details/84851817</link><guid>https://blog.youkuaiyun.com/wanbin6470398/article/details/84851817</guid><author>wanbin6470398</author><pubDate>Thu, 06 Dec 2018 15:51:20 +0800</pubDate><description><![CDATA[用Merge改写优化Update1. 多列关联更新改写示例2. 用Merge改写有聚合操作的Update
1. 多列关联更新改写示例
1. 模拟数据
create table t_objects as select * from dba_objects;
create table t_tables as select * from dba_tables;
alter table t_objects...]]></description><category></category></item><item><title><![CDATA[Oracle BBED工具及坏块修复]]></title><link>https://blog.youkuaiyun.com/wanbin6470398/article/details/84761478</link><guid>https://blog.youkuaiyun.com/wanbin6470398/article/details/84761478</guid><author>wanbin6470398</author><pubDate>Mon, 03 Dec 2018 22:26:03 +0800</pubDate><description><![CDATA[Oracle BBED工具及坏块修复1. BBED简介2. BBED安装3. 启动BBED4. 使用bbed模拟数据块损坏5. 修复坏块
1. BBED简介
BBED是Block Browser/Editor的缩写，是Oracle的一个内部工具，不对外发布文档及支持。 BBED随软件发布，但是我们需要进行简单的relink才能使用。
2. BBED安装


在使用bbed前，需进行编译连接。但由于...]]></description><category></category></item><item><title><![CDATA[Silent Install Oracle 12cR2 Rac on Centos7]]></title><link>https://blog.youkuaiyun.com/wanbin6470398/article/details/84651433</link><guid>https://blog.youkuaiyun.com/wanbin6470398/article/details/84651433</guid><author>wanbin6470398</author><pubDate>Fri, 30 Nov 2018 16:45:51 +0800</pubDate><description><![CDATA[Silent Install Oracle 12cR2 Rac on Centos71. 配置操作系统2. 准备Oracle RAC的集群节点3. 准备Oracle RAC的共享存储4. 配置互信5. 静默安装 GI 软件6. 静默安装 Oracle DB软件
1. 配置操作系统
参考博客 https://blog.youkuaiyun.com/wanbin6470398/article/details/84...]]></description><category></category></item><item><title><![CDATA[Install Oracle 12c R2 RAC On CentOS 7]]></title><link>https://blog.youkuaiyun.com/wanbin6470398/article/details/84615454</link><guid>https://blog.youkuaiyun.com/wanbin6470398/article/details/84615454</guid><author>wanbin6470398</author><pubDate>Fri, 30 Nov 2018 11:12:15 +0800</pubDate><description><![CDATA[Install Oracle 12c RAC On CentOS 71. 准备Oracle RAC的集群节点1.1 用户账户
1. 准备Oracle RAC的集群节点
1.1 用户账户

使用以下命令创建OS组。 以“root”用户身份输入以下命令：# /usr/sbin/groupadd oinstall
# /usr/sbin/groupadd dba
# /usr/sbin/groupadd...]]></description><category></category></item><item><title><![CDATA[Install Oracle 12C R2 On CentOS 7]]></title><link>https://blog.youkuaiyun.com/wanbin6470398/article/details/84578979</link><guid>https://blog.youkuaiyun.com/wanbin6470398/article/details/84578979</guid><author>wanbin6470398</author><pubDate>Wed, 28 Nov 2018 22:28:26 +0800</pubDate><description><![CDATA[Install Oracle 12C On CentOS 7前言Oracle 在此版本的变更1. Oracle数据库安装核对表2. 检查和配置Oracle数据库的服务器硬件2.1 使用X Window系统登录远程系统2.2 检查服务器硬件和内存配置3. 使用Oracle预安装RPM自动配置Oracle Linux4. 在Linux上配置Oracle数据库的操作系统4. 1 `x86-64 Linu...]]></description><category></category></item><item><title><![CDATA[aix命令tar包命令应用]]></title><link>https://blog.youkuaiyun.com/wanbin6470398/article/details/83990206</link><guid>https://blog.youkuaiyun.com/wanbin6470398/article/details/83990206</guid><author>wanbin6470398</author><pubDate>Mon, 12 Nov 2018 12:54:34 +0800</pubDate><description><![CDATA[打包并压缩gzip格式，利用ftp传输到远程服务器上
tar cvf - /ciod/appuser  | gzip -qc&amp;amp;amp;amp;amp;gt; /ciod/appuser.tar.gzip

ftp -v -n 192.1.1.48&amp;amp;amp;amp;amp;lt;&amp;amp;amp;amp;amp;lt;EOF 
user root xxxxx
bin
cd /ciod
lcd /ciod
prompt
mput *.gz
close
bye
EOF


]]></description><category></category></item><item><title><![CDATA[InnoDB体系结构]]></title><link>https://blog.youkuaiyun.com/wanbin6470398/article/details/83789607</link><guid>https://blog.youkuaiyun.com/wanbin6470398/article/details/83789607</guid><author>wanbin6470398</author><pubDate>Wed, 07 Nov 2018 17:28:57 +0800</pubDate><description><![CDATA[InnoDB体系结构内存结构Buffer poolBuffer Pool LRU 算法配置 Buffer PoolChange BufferAdaptive Hash IndexRedo Log Buffer磁盘结构
下图显示了构成InnoDB存储引擎体系结构的内存和磁盘结构。

内存结构
InnoDB内存包含Buffer Pool， Change Buffer， Adaptive Hash In...]]></description><category></category></item><item><title><![CDATA[基于Inception搭建MySQL SQL审核平台Yearing]]></title><link>https://blog.youkuaiyun.com/wanbin6470398/article/details/83544159</link><guid>https://blog.youkuaiyun.com/wanbin6470398/article/details/83544159</guid><author>wanbin6470398</author><pubDate>Thu, 01 Nov 2018 13:49:04 +0800</pubDate><description><![CDATA[# cmake -DWITH_DEBUG=OFF -DCMAKE_INSTALL_PREFIX=./mysql -DMYSQL_DATADIR=./mysql/data -DWITH_SSL=bundled -DCMAKE_BUILD_TYPE=RELEASE -DWITH_ZLIB=bundled -DMY_MAINTAINER_CXX_WARNINGS=&amp;amp;amp;amp;quot;-Wall -Wextra -Wunu...]]></description><category></category></item><item><title><![CDATA[MySQL数据库主从切换脚本自动化]]></title><link>https://blog.youkuaiyun.com/wanbin6470398/article/details/83508134</link><guid>https://blog.youkuaiyun.com/wanbin6470398/article/details/83508134</guid><author>wanbin6470398</author><pubDate>Mon, 29 Oct 2018 17:06:04 +0800</pubDate><description><![CDATA[MySQL数据库主从切换脚本自动化
本文转载自：https://blog.youkuaiyun.com/weixin_36135773/article/details/79514507
在一些实际环境中，如何实现主从的快速切换，在没有MHA等工具的辅助下，如何避免影响线上的业务，一般都会在在业务低峰期进行主从切换，本脚本主要利用MySQL自带的命令行工具(FLUSH TABLES WITH READ LOCK...]]></description><category></category></item><item><title><![CDATA[利用sysbench工具测试MHA]]></title><link>https://blog.youkuaiyun.com/wanbin6470398/article/details/83506876</link><guid>https://blog.youkuaiyun.com/wanbin6470398/article/details/83506876</guid><author>wanbin6470398</author><pubDate>Mon, 29 Oct 2018 16:02:51 +0800</pubDate><description><![CDATA[利用sysbench工具测试MHA1. sysbench准备数据2. sysbench开始压测3. master模拟意外宕机4. mysqldb2 上观察mha状态5. 手工failover切换master6. 原mysqldb1手工加入集群7. 手工在线切换
1. sysbench准备数据
sysbench /usr/share/sysbench/oltp_read_write.lua \
--...]]></description><category></category></item><item><title><![CDATA[MHA]]></title><link>https://blog.youkuaiyun.com/wanbin6470398/article/details/83303930</link><guid>https://blog.youkuaiyun.com/wanbin6470398/article/details/83303930</guid><author>wanbin6470398</author><pubDate>Mon, 29 Oct 2018 14:56:43 +0800</pubDate><description><![CDATA[MHA配置互信
配置互信
1） 在三台机器上生成各自的key文件
[root@mysqldb1 11:10:53 /root]
# ssh-keygen -t rsa
[root@mysqldb2 11:10:56 /root]
# ssh-keygen -t rsa
[root@mysqldb3 11:10:58 /root]
# ssh-keygen -t rsa

2）用ssh-copy-i...]]></description><category></category></item><item><title><![CDATA[percona-toolkit工具使用介绍]]></title><link>https://blog.youkuaiyun.com/wanbin6470398/article/details/83178755</link><guid>https://blog.youkuaiyun.com/wanbin6470398/article/details/83178755</guid><author>wanbin6470398</author><pubDate>Mon, 22 Oct 2018 16:32:15 +0800</pubDate><description><![CDATA[percona-toolkit工具使用介绍1. pt-hearbeat
1. pt-hearbeat

]]></description><category></category></item></channel></rss>