<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[DBDoctor的博客]]></title><description><![CDATA[专注数据库架构、运维、调优。]]></description><link>https://blog.youkuaiyun.com/DBDoctor</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; DBDoctor]]></copyright><item><title><![CDATA[ORACLE 11gR2 RAC添加控制文件]]></title><link>https://blog.youkuaiyun.com/DBDoctor/article/details/53905998</link><guid>https://blog.youkuaiyun.com/DBDoctor/article/details/53905998</guid><author>DBDoctor</author><pubDate>Wed, 28 Dec 2016 10:05:13 +0800</pubDate><description><![CDATA[版本SQL> select * from v$version;BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQ]]></description><category></category></item><item><title><![CDATA[Mysql几种日志简介]]></title><link>https://blog.youkuaiyun.com/DBDoctor/article/details/53184019</link><guid>https://blog.youkuaiyun.com/DBDoctor/article/details/53184019</guid><author>DBDoctor</author><pubDate>Wed, 16 Nov 2016 11:13:55 +0800</pubDate><description><![CDATA[Mysql的日志包括如下几种日志：
错误日志
普通查询日志
二进制日志
慢查询日志
Mysql版本此文档测试mysql的版本为[root@mysql-dev01 bin]# ./mysql -V
./mysql  Ver 14.14 Distrib 5.7.14, for Linux (x86_64) using  EditLine wrapper错误日志 error logMysql错误日志主要记]]></description><category></category></item><item><title><![CDATA[oracle trigger中的before和after]]></title><link>https://blog.youkuaiyun.com/DBDoctor/article/details/53167736</link><guid>https://blog.youkuaiyun.com/DBDoctor/article/details/53167736</guid><author>DBDoctor</author><pubDate>Tue, 15 Nov 2016 08:53:15 +0800</pubDate><description><![CDATA[before：(insert、update)可以对new进行修改;after不能对new进行修改，两者都不能修改old数据。对于INSERT语句, 只有NEW是合法的；对于DELETE语句，只有OLD才合法；对于UPDATE语句，NEW、OLD可以同时使用。修改为before，可以顺利执行create or replace trigger trg_t6103_insert
  before inse]]></description><category></category></item><item><title><![CDATA[[ERROR] You have enabled the binary log, but you haven't provided the mandatory server-id.]]></title><link>https://blog.youkuaiyun.com/DBDoctor/article/details/52422637</link><guid>https://blog.youkuaiyun.com/DBDoctor/article/details/52422637</guid><author>DBDoctor</author><pubDate>Sat, 03 Sep 2016 12:56:19 +0800</pubDate><description><![CDATA[MySQL在开启bin-log时报错，信息如下：[ERROR] You have enabled the binary log, but you haven’t provided the mandatory server-id. Please refer to the proper server start-up parameters documentation 
2016-09-03T03:17:]]></description><category></category></item><item><title><![CDATA[oracle隐含参数查询 $ksppi 和x$ksppcv]]></title><link>https://blog.youkuaiyun.com/DBDoctor/article/details/52399039</link><guid>https://blog.youkuaiyun.com/DBDoctor/article/details/52399039</guid><author>DBDoctor</author><pubDate>Thu, 01 Sep 2016 13:53:21 +0800</pubDate><description><![CDATA[oracle数据库的初始化参数，主要来源于两个Oracle内部数据字典表X$KSPI和X$KSPPCV; 
通常我们查询的V$Parameter视图或使用show parameter命令都是就来源于这两个系统表的，但通过这两种方式不能查询隐含参数。X$KSPPCV用以记录当前的设置的值,及是否使用了缺省值等信息,X$KSPPI则是一个基础表,用于记录参数名、参数说明等简单的信息。X$KSPPIADD]]></description><category></category></item><item><title><![CDATA[ORA-03137: TTC protocol internal error : [12333] [7] [120] [116] [] [] [] []]]></title><link>https://blog.youkuaiyun.com/DBDoctor/article/details/52398985</link><guid>https://blog.youkuaiyun.com/DBDoctor/article/details/52398985</guid><author>DBDoctor</author><pubDate>Thu, 01 Sep 2016 13:47:05 +0800</pubDate><description><![CDATA[数据库版本：SQL> select * from v$version;BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
P]]></description><category></category></item><item><title><![CDATA[oracle版本升级路线]]></title><link>https://blog.youkuaiyun.com/DBDoctor/article/details/52382186</link><guid>https://blog.youkuaiyun.com/DBDoctor/article/details/52382186</guid><author>DBDoctor</author><pubDate>Wed, 31 Aug 2016 10:07:04 +0800</pubDate><description><![CDATA[oracle版本升级路线，记录备用！]]></description><category></category></item><item><title><![CDATA[Oracle Backup（三）：数据库归档设置]]></title><link>https://blog.youkuaiyun.com/DBDoctor/article/details/52356856</link><guid>https://blog.youkuaiyun.com/DBDoctor/article/details/52356856</guid><author>DBDoctor</author><pubDate>Mon, 29 Aug 2016 21:45:18 +0800</pubDate><description><![CDATA[oracle结束一个联机重做日志的写入并开始写入另一个联机重做日志时，会发生日志切换。如果数据库处于ARCHIVELOG模式下，日志切换的结果是生成联机重做日志的副本，这个副本叫做归档日志，数据库在介质恢复的期间，会采用归档日志来执行恢复。第一章 归档模式切换1.1.  查看日志是否归档#方法一：
SQL> archive log list;
Database log mode          A]]></description><category></category></item><item><title><![CDATA[Centos6.5源码编译安装Mysql5.7.14]]></title><link>https://blog.youkuaiyun.com/DBDoctor/article/details/52345181</link><guid>https://blog.youkuaiyun.com/DBDoctor/article/details/52345181</guid><author>DBDoctor</author><pubDate>Sun, 28 Aug 2016 14:00:39 +0800</pubDate><description><![CDATA[本文安装环境为Centos6.5 + Mysql5.7.14，安装方式采用源码编译的方式进行安装，主要考虑到修改mysql rpm安装文件夹太乱的问题，因为本人有较为严重的强迫症。第一章 安装准备1.1.  安装依赖包yum -y install gcc-c++ ncurses-devel cmake make perl \ gcc autoconf automake zlib libxml lib]]></description><category></category></item><item><title><![CDATA[Oracle Backup（二）：RMAN体系概述]]></title><link>https://blog.youkuaiyun.com/DBDoctor/article/details/52313629</link><guid>https://blog.youkuaiyun.com/DBDoctor/article/details/52313629</guid><author>DBDoctor</author><pubDate>Thu, 25 Aug 2016 13:07:11 +0800</pubDate><description><![CDATA[RMAN（Recovery Manager）是服务器管理恢复（Server-Managed Recovery,SMR）的一种实现。SMR是一种数据库执行所需的操作以确保自身备份成功的能力，依赖于RDBMS内核中的内置代码可以完成这一功能。第一章 RMAN体系结构
1.1. 内存
RMAN使用一些PL/SQL程序包执行操作，这些程序包与其它程序包相同，必须加载到共享池中。如果共享池不够大或者结构比较零]]></description><category></category></item><item><title><![CDATA[kewastUnPackStats(): bad magic 1]]></title><link>https://blog.youkuaiyun.com/DBDoctor/article/details/52230316</link><guid>https://blog.youkuaiyun.com/DBDoctor/article/details/52230316</guid><author>DBDoctor</author><pubDate>Wed, 17 Aug 2016 13:56:11 +0800</pubDate><description><![CDATA[11.2.0.1数据库alert中存在如下错误信息Wed Aug 17 12:19:09 2016
kewastUnPackStats(): bad magic 1 (0x7f5b783f4dc7, 0)
kewastUnPackStats(): bad magic 1 (0x7f5b783f4dc7, 0)
kewastUnPackStats(): bad magic 1 (0x7f5b783f4]]></description><category></category></item><item><title><![CDATA[Oracle Backup（一）：基础概念]]></title><link>https://blog.youkuaiyun.com/DBDoctor/article/details/52185424</link><guid>https://blog.youkuaiyun.com/DBDoctor/article/details/52185424</guid><author>DBDoctor</author><pubDate>Thu, 11 Aug 2016 18:33:47 +0800</pubDate><description><![CDATA[备份就是冗余，本质就是将当前的数据复制几份到其他地方，这样当原始数据文件由于各种原因导致损坏的时候，我们就可以通过备份的文件恢复到备份时的状态。备份的类型根据数据库数据导出方式划分1、物理备份（Physical Backups)2、逻辑备份（Logical Backups）物理备份物理备份就是复制文件，对于oracle来说的话，需要将关键的文件（以下称key file）做物理的拷贝到其它地方。]]></description><category></category></item><item><title><![CDATA[ORA-20011 ORA-29913 KUP-11024问题处理]]></title><link>https://blog.youkuaiyun.com/DBDoctor/article/details/52181720</link><guid>https://blog.youkuaiyun.com/DBDoctor/article/details/52181720</guid><author>DBDoctor</author><pubDate>Thu, 11 Aug 2016 13:18:26 +0800</pubDate><description><![CDATA[问题发现数据库版本SQL> select * from v$version;BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Productio]]></description><category></category></item><item><title><![CDATA[Oracle 11gR2 RAC 使用scan IP无法连接数据库（ORA-12545）]]></title><link>https://blog.youkuaiyun.com/DBDoctor/article/details/52163742</link><guid>https://blog.youkuaiyun.com/DBDoctor/article/details/52163742</guid><author>DBDoctor</author><pubDate>Tue, 09 Aug 2016 16:16:50 +0800</pubDate><description><![CDATA[简介oracle 11gR2 RAC安装配置scan ip有三种方式， 
 1、DNS 
 2、GNS 
 3、hosts文件 
 通常情况下我们采用DNS的方式，但是平时测试的时候我们一般均采用hosts文件的方式，使用hosts时，安装完数据库scan ip通常访问不了。环境[root@rac-orcl01 ~]# cat /etc/hosts
127.0.0.1   localhost loc]]></description><category></category></item><item><title><![CDATA[oracle 11R2 ADG LGWR: Error 16086 opening RFS destination for reconnect]]></title><link>https://blog.youkuaiyun.com/DBDoctor/article/details/52105295</link><guid>https://blog.youkuaiyun.com/DBDoctor/article/details/52105295</guid><author>DBDoctor</author><pubDate>Wed, 03 Aug 2016 17:00:27 +0800</pubDate><description><![CDATA[问题出现数据库版本SQL> select * from v$version;BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Productio]]></description><category></category></item><item><title><![CDATA[GoldenGate单向复制配置(支持DDL复制)]]></title><link>https://blog.youkuaiyun.com/DBDoctor/article/details/51943483</link><guid>https://blog.youkuaiyun.com/DBDoctor/article/details/51943483</guid><author>DBDoctor</author><pubDate>Mon, 18 Jul 2016 16:59:41 +0800</pubDate><description><![CDATA[版本说明                   Source               Target
Oracle             11.2.0.4.0           11.2.0.4.0
GoldenGate         12.2.0.1.1           12.2.0.1.1
OS                 CentOS 6.5           CentOS 6]]></description><category></category></item><item><title><![CDATA[expdp之ORA-39006: internal error]]></title><link>https://blog.youkuaiyun.com/DBDoctor/article/details/51920956</link><guid>https://blog.youkuaiyun.com/DBDoctor/article/details/51920956</guid><author>DBDoctor</author><pubDate>Fri, 15 Jul 2016 20:53:37 +0800</pubDate><description><![CDATA[数据库版本SQL> select * from v$version;BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL]]></description><category></category></item><item><title><![CDATA[oracle内存管理手动到自动]]></title><link>https://blog.youkuaiyun.com/DBDoctor/article/details/51909217</link><guid>https://blog.youkuaiyun.com/DBDoctor/article/details/51909217</guid><author>DBDoctor</author><pubDate>Thu, 14 Jul 2016 14:41:23 +0800</pubDate><description><![CDATA[数据库版本SQL> select * from v$version;BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL]]></description><category></category></item><item><title><![CDATA[oracle修改字符集（WE8MSWIN1252 -->ZHS16GBK）]]></title><link>https://blog.youkuaiyun.com/DBDoctor/article/details/51909047</link><guid>https://blog.youkuaiyun.com/DBDoctor/article/details/51909047</guid><author>DBDoctor</author><pubDate>Thu, 14 Jul 2016 14:26:26 +0800</pubDate><description><![CDATA[查看数据库当前字符集SQL> select userenv('language') from dual;USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.WE8MSWIN1252将数据库置于restricted mode下SQL> alter system enable]]></description><category></category></item><item><title><![CDATA[oracle的restricted mode(受限模式)]]></title><link>https://blog.youkuaiyun.com/DBDoctor/article/details/51907531</link><guid>https://blog.youkuaiyun.com/DBDoctor/article/details/51907531</guid><author>DBDoctor</author><pubDate>Thu, 14 Jul 2016 11:13:29 +0800</pubDate><description><![CDATA[概述在查看oracle的v$instance视图中发现有logins列，我们可以看下contents中对此列的定义。![这里写图片描述](http://img.blog.youkuaiyun.com/20160714104516544)实例启动有两种模式，一种为allowed，一种为restricted模式。Restricted Mode of Instance StartupYou can start an]]></description><category></category></item></channel></rss>