<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[crcz16618的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/crcz16618</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; crcz16618]]></copyright><item><title><![CDATA[rman异机恢复中遇到ora-01157（转储文件无法识别问题）]]></title><link>https://blog.youkuaiyun.com/crcz16618/article/details/100267561</link><guid>https://blog.youkuaiyun.com/crcz16618/article/details/100267561</guid><author>crcz16618</author><pubDate>Mon, 02 Jul 2018 17:14:56 +0800</pubDate><description><![CDATA[恢复脚本如下：



	


	恢复过程如下：



	


	此时，数据库处于mounted状态，查看控制文件中文件的路径信息如下：



	


	从以上操作中可以看出，控制文...]]></description><category></category></item><item><title><![CDATA[Oracle查看归档是否被备库应用]]></title><link>https://blog.youkuaiyun.com/crcz16618/article/details/100267564</link><guid>https://blog.youkuaiyun.com/crcz16618/article/details/100267564</guid><author>crcz16618</author><pubDate>Tue, 12 Jun 2018 17:08:07 +0800</pubDate><description><![CDATA[首先是查询v$archived_log视图，然后分析applied字段信息，官方说明如下：

Indicates whether an archived redo log file has been applied to t...]]></description><category></category></item><item><title><![CDATA[为什么mysql会经常出现主从同步不一致的情况]]></title><link>https://blog.youkuaiyun.com/crcz16618/article/details/100267552</link><guid>https://blog.youkuaiyun.com/crcz16618/article/details/100267552</guid><author>crcz16618</author><pubDate>Mon, 04 Jun 2018 14:52:55 +0800</pubDate><description><![CDATA[1. MySQL数据库主从同步延迟原理。


	


	答：谈到MySQL数据库主从同步延迟原理，得从mysql的数据库主从复制原理说起，mysql的主从复制都是单线程的操作，主库对所有DDL和 DML产生bi...]]></description><category></category></item><item><title><![CDATA[mysql5.6搭建主从过程中遇到主从server_uuid一致无法同步的问题]]></title><link>https://blog.youkuaiyun.com/crcz16618/article/details/100267551</link><guid>https://blog.youkuaiyun.com/crcz16618/article/details/100267551</guid><author>crcz16618</author><pubDate>Fri, 04 May 2018 11:11:59 +0800</pubDate><description><![CDATA[Beginning with MySQL 5.6, the server generates a true UUID in addition to the--server-idsupplied by the user. Th...]]></description><category></category></item><item><title><![CDATA[Linux7修改主机IP及主机名]]></title><link>https://blog.youkuaiyun.com/crcz16618/article/details/100267557</link><guid>https://blog.youkuaiyun.com/crcz16618/article/details/100267557</guid><author>crcz16618</author><pubDate>Fri, 27 Apr 2018 11:28:06 +0800</pubDate><description><![CDATA[修改IP，如下所示：


[root@cent1 ~]# cat /etc/sysconfig/network-scripts/ifcfg-eno16777736
TYPE=Ethernet
BOOTPROTO=...]]></description><category></category></item><item><title><![CDATA[python libclntsh.so.12.1: cannot open shared object file]]></title><link>https://blog.youkuaiyun.com/crcz16618/article/details/100267546</link><guid>https://blog.youkuaiyun.com/crcz16618/article/details/100267546</guid><author>crcz16618</author><pubDate>Thu, 15 Mar 2018 09:38:53 +0800</pubDate><description><![CDATA[手工执行python程序可以，但在执行定时任务过程中遇到如下错误


libclntsh.so.12.1: cannot open shared object file: No such file or direct...]]></description><category></category></item><item><title><![CDATA[oracle regexp_like用法与正则]]></title><link>https://blog.youkuaiyun.com/crcz16618/article/details/100267555</link><guid>https://blog.youkuaiyun.com/crcz16618/article/details/100267555</guid><author>crcz16618</author><pubDate>Tue, 06 Feb 2018 13:44:56 +0800</pubDate><description><![CDATA[ORACLE中的支持正则表达式的函数主要有下面四个：
1，REGEXP_LIKE ：与LIKE的功能相似
2，REGEXP_INSTR ：与INSTR的功能相似
3，REGEXP_SUBSTR ：与SUBSTR的功能...]]></description><category></category></item><item><title><![CDATA[mysql之pid文件]]></title><link>https://blog.youkuaiyun.com/crcz16618/article/details/100267577</link><guid>https://blog.youkuaiyun.com/crcz16618/article/details/100267577</guid><author>crcz16618</author><pubDate>Sun, 03 Dec 2017 16:46:55 +0800</pubDate><description><![CDATA[PID文件


	


	当mysql实例启动时，会将自己的进程ID写入一个文件中—该文件即为PID文件，该文件由参数pid_file控制。默认路径位于数据库目录下。





           ...]]></description><category></category></item><item><title><![CDATA[mysql基础概念之socket文件]]></title><link>https://blog.youkuaiyun.com/crcz16618/article/details/100267543</link><guid>https://blog.youkuaiyun.com/crcz16618/article/details/100267543</guid><author>crcz16618</author><pubDate>Sun, 03 Dec 2017 16:45:38 +0800</pubDate><description><![CDATA[套接字文件


	


	Unix系统下本地连接mysql可以采用Unix域套接字方式，这种方式需要一个套接字文件。套接字文件由参数socket控制。一般在/tmp目录下，名为mysql.sock



...]]></description><category></category></item><item><title><![CDATA[mysql的auto_increment_offset和auto_increment_increment配置]]></title><link>https://blog.youkuaiyun.com/crcz16618/article/details/100267553</link><guid>https://blog.youkuaiyun.com/crcz16618/article/details/100267553</guid><author>crcz16618</author><pubDate>Mon, 27 Nov 2017 14:28:17 +0800</pubDate><description><![CDATA[mysql中有自增长字段，在做数据库的主主同步时需要设置自增长的两个相关配置：auto_increment_offset和auto_increment_increment。


	
		auto_increment...]]></description><category></category></item><item><title><![CDATA[彻底弄懂oracle硬解析、软解析、软软解析]]></title><link>https://blog.youkuaiyun.com/crcz16618/article/details/100267548</link><guid>https://blog.youkuaiyun.com/crcz16618/article/details/100267548</guid><author>crcz16618</author><pubDate>Sat, 18 Nov 2017 14:41:59 +0800</pubDate><description><![CDATA[硬解析和软解析有相同的一步，而软软解析与硬解析、软解析完全不一样。先来说下理论上的东西，然后来做个实验。


	硬解析过程：


	  1.语法、语义及权限检查；


	  2.查询转换（通过应用...]]></description><category></category></item><item><title><![CDATA[日志管理程序时间订制版]]></title><link>https://blog.youkuaiyun.com/crcz16618/article/details/100267542</link><guid>https://blog.youkuaiyun.com/crcz16618/article/details/100267542</guid><author>crcz16618</author><pubDate>Tue, 31 Oct 2017 17:02:30 +0800</pubDate><description><![CDATA[#!/bin/bash
#author: Rui Zhang
#date: 2017-10-31
#email: sharpzhang_2008@126.com


dayom=`date +'%d'`
monoy...]]></description><category></category></item><item><title><![CDATA[编码与乱码]]></title><link>https://blog.youkuaiyun.com/crcz16618/article/details/100267550</link><guid>https://blog.youkuaiyun.com/crcz16618/article/details/100267550</guid><author>crcz16618</author><pubDate>Wed, 27 Sep 2017 10:32:48 +0800</pubDate><description><![CDATA[参考网址：https://zhuanlan.zhihu.com/p/24465635?refer=study-fe


在浏览器上查看网页，偶尔会看到一些网站出现乱码的情况。这里用通俗易懂的语言聊一聊编码的那些事

...]]></description><category></category></item><item><title><![CDATA[日志管理程序]]></title><link>https://blog.youkuaiyun.com/crcz16618/article/details/100267545</link><guid>https://blog.youkuaiyun.com/crcz16618/article/details/100267545</guid><author>crcz16618</author><pubDate>Fri, 22 Sep 2017 11:19:43 +0800</pubDate><description><![CDATA[#!/bin/bash
#author: Rui Zhang
#date: 2017-09-22
#email: sharpzhang_2008@126.com


function restore_log(){
...]]></description><category></category></item><item><title><![CDATA[日志删除脚本]]></title><link>https://blog.youkuaiyun.com/crcz16618/article/details/100267549</link><guid>https://blog.youkuaiyun.com/crcz16618/article/details/100267549</guid><author>crcz16618</author><pubDate>Fri, 22 Sep 2017 11:07:12 +0800</pubDate><description><![CDATA[#!/bin/bash


function clear_log(){


dir_name=$1
log_name=$2




cd $dir_name




echo dir_name...]]></description><category></category></item><item><title><![CDATA[python paramiko模块管理SSH]]></title><link>https://blog.youkuaiyun.com/crcz16618/article/details/100267541</link><guid>https://blog.youkuaiyun.com/crcz16618/article/details/100267541</guid><author>crcz16618</author><pubDate>Wed, 20 Sep 2017 16:20:39 +0800</pubDate><description><![CDATA[参考地址：http://lihuipeng.blog.51cto.com/3064864/1071125/


	下面是两种使用paramiko连接到linux服务器的代码


	方式一：


	
		ssh...]]></description><category></category></item><item><title><![CDATA[数据库补丁索引]]></title><link>https://blog.youkuaiyun.com/crcz16618/article/details/100267893</link><guid>https://blog.youkuaiyun.com/crcz16618/article/details/100267893</guid><author>crcz16618</author><pubDate>Thu, 14 Sep 2017 17:25:41 +0800</pubDate><description><![CDATA[MOSID 2118136.2
                                                            
                    
               ...]]></description><category></category></item><item><title><![CDATA[日志转储脚本]]></title><link>https://blog.youkuaiyun.com/crcz16618/article/details/100267892</link><guid>https://blog.youkuaiyun.com/crcz16618/article/details/100267892</guid><author>crcz16618</author><pubDate>Wed, 13 Sep 2017 16:08:40 +0800</pubDate><description><![CDATA[#!/bin/bash




function restore_log(){


tday_num=`date +'%F-%s'`


dir_name=$1


log_name=$2


...]]></description><category></category></item><item><title><![CDATA[获取两天内的告警日志（AIX|ksh|shell|oracle）]]></title><link>https://blog.youkuaiyun.com/crcz16618/article/details/100267890</link><guid>https://blog.youkuaiyun.com/crcz16618/article/details/100267890</guid><author>crcz16618</author><pubDate>Fri, 01 Sep 2017 10:11:41 +0800</pubDate><description><![CDATA[#!/usr/bin/ksh
#author: Rui Zhang
#date: 2017-08-09
#email: sharpzhang_2008@126.com


export LANG=en_US.UTF...]]></description><category></category></item><item><title><![CDATA[获取两天内的告警日志（bash|shell|oracle）]]></title><link>https://blog.youkuaiyun.com/crcz16618/article/details/100267891</link><guid>https://blog.youkuaiyun.com/crcz16618/article/details/100267891</guid><author>crcz16618</author><pubDate>Thu, 17 Aug 2017 14:50:33 +0800</pubDate><description><![CDATA[#!/bin/bash
#author: Rui Zhang
#date: 2017-08-09
#email: sharpzhang_2008@126.com
export LANG=en_US.UTF-8

...]]></description><category></category></item></channel></rss>