<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Lissen_Gan的博客]]></title><description><![CDATA[专注于数据库技术，更注重数据库技术的运用]]></description><link>https://blog.youkuaiyun.com/u011285708</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; u011285708]]></copyright><item><title><![CDATA[Perl脚本获取.bash_profile中变量]]></title><link>https://blog.youkuaiyun.com/u011285708/article/details/127822562</link><guid>https://blog.youkuaiyun.com/u011285708/article/details/127822562</guid><author>u011285708</author><pubDate>Sat, 12 Nov 2022 17:10:51 +0800</pubDate><description><![CDATA[Perl脚本获取.bash_profile中变量]]></description><category></category></item><item><title><![CDATA[Zabbix使用脚本批量增加自定义监控项]]></title><link>https://blog.youkuaiyun.com/u011285708/article/details/123055449</link><guid>https://blog.youkuaiyun.com/u011285708/article/details/123055449</guid><author>u011285708</author><pubDate>Mon, 21 Feb 2022 20:44:25 +0800</pubDate><description><![CDATA[1.1 准备脚本
vi /root/my_shell/get_os_info.sh

#!/bin/bash

#if [ $# -ne 1 ];then
#	echo "Usage: get_os_info.sh conn_cnt|total_mem|cpu_cnt"
#else
#	exit 1
#fi

case $1 in
	conn_cnt)
		w|awk 'NR==1{print $5}'
		;;
	total_mem)
		free -m | awk 'NR==2{print $2}'
	]]></description><category></category></item><item><title><![CDATA[OGG不同表指定不同extract、dump、replicat]]></title><link>https://blog.youkuaiyun.com/u011285708/article/details/122902701</link><guid>https://blog.youkuaiyun.com/u011285708/article/details/122902701</guid><author>u011285708</author><pubDate>Sat, 12 Feb 2022 21:51:47 +0800</pubDate><description><![CDATA[注意：每个extract对应一个dump和replicat，有多个个extract就有多少个dump和replicat

1.1 环境准备

create tablespace test_tbs datafile '/u01/app/oracle/oradata/ggg11g/test_tbs01.dbf' size 10M autoextend on maxsize unlimited;
create user test identified by test account unlock default.]]></description><category></category></item><item><title><![CDATA[Oracle RAC到RAC配置OGG单向同步]]></title><link>https://blog.youkuaiyun.com/u011285708/article/details/122528596</link><guid>https://blog.youkuaiyun.com/u011285708/article/details/122528596</guid><author>u011285708</author><pubDate>Sun, 16 Jan 2022 21:01:25 +0800</pubDate><description><![CDATA[CentOS6.8 Oracle 12.2.0.1 RAC到CentOS7.6 Oracle 19c RAC单项同步
/* OGG数据迁总体规划参考文档 */
https://cloud.tencent.com/developer/news/694510
一、创建共享目录
RAC环境下，OGG安装目录需要处于全部节点的共享目录下，可以使用ACFS或NFS。ACFS用于挂载一个共享目录(用于安装OGG软件)到2个节点，ACFS可以使用已经存在的磁盘组，也可以单独创建磁盘组。

**1、源端创建共享目录(NFS]]></description><category></category></item><item><title><![CDATA[PG创建的初始role不能登录问题]]></title><link>https://blog.youkuaiyun.com/u011285708/article/details/121463848</link><guid>https://blog.youkuaiyun.com/u011285708/article/details/121463848</guid><author>u011285708</author><pubDate>Mon, 22 Nov 2021 02:39:57 +0800</pubDate><description><![CDATA[PG创建的初始role不能登录问题
[pgsql@lissen-source-pg14 pgdata]$ psql -Ulissen2
psql: error: connection to server on socket "/postgresql/pgdata/.s.PGSQL.5432" failed: FATAL:  role "lissen2" is not permitted to log in

解决办法：
postgres=# alter role lissen2 with login;


]]></description><category></category></item><item><title><![CDATA[PXB初始化从库，需要跳过多个事务如何解决(使用GTID搭建从库)？]]></title><link>https://blog.youkuaiyun.com/u011285708/article/details/121315914</link><guid>https://blog.youkuaiyun.com/u011285708/article/details/121315914</guid><author>u011285708</author><pubDate>Sun, 14 Nov 2021 12:13:39 +0800</pubDate><description><![CDATA[问题：PXB初始化从库，需要跳过多个事务如何解决(使用GTID搭建从库)？
解决方案：
可以批量来跳过事务，关键在于找到最后需要的跳过的事务.
主库使用PXB全备前，记录主库GTID，从库使用PXB恢复后跳过事务到前面记录的GTID

主库
记录PXB全备前GTID
mysql[(none)]&gt; show master status\G;
*************************** 1. row ***************************
             File: ]]></description><category></category></item><item><title><![CDATA[Oracle审计篇——统一审计[转]]]></title><link>https://blog.youkuaiyun.com/u011285708/article/details/118102307</link><guid>https://blog.youkuaiyun.com/u011285708/article/details/118102307</guid><author>u011285708</author><pubDate>Tue, 22 Jun 2021 10:52:43 +0800</pubDate><description><![CDATA[一、 统一审计作用 
统一审计跟踪从各种来源捕获审计信息。通过统一审计，您可以从以下来源捕获审计记录： 
来自统一审计策略和AUDIT设置中的审计记录（包括sys的审计记录）来自DBMS_FGA的细粒度审计记录Oracle Database Real Application Security审计记录Oracle Recovery Manager审计记录Oracle Database Vault审计记录Oracle ...]]></description><category></category></item><item><title><![CDATA[B树索引概念]]></title><link>https://blog.youkuaiyun.com/u011285708/article/details/117913243</link><guid>https://blog.youkuaiyun.com/u011285708/article/details/117913243</guid><author>u011285708</author><pubDate>Mon, 14 Jun 2021 21:42:54 +0800</pubDate><description><![CDATA[一、B树索引组件
B树索引是一个典型的树结构，其包含的组件主要是：
1、根节点(最顶端的索引分支块)：包含指向其他索引分支块或索引叶子块的指针和索引键值列。
2、索引分支节点(索引分支块)：包含指向其他索引分支块或索引叶子块的指针和索引键值列。
3、索引叶子节点(索引叶子块)：索引叶子块包含被索引键值和用于定位该索引键值所在的数据行在表中实际物理存储位置的ROWID。
（这里得指针是指相关索引分支块和索引叶子块的块地址RDBA）

二、Oracle访问B-Tree索引顺序
ROOT（LMC B C 索引根节]]></description><category></category></item><item><title><![CDATA[MySQL双1参数innodb_flush_log_at_trx_commit、sync_binlog和两阶段提交]]></title><link>https://blog.youkuaiyun.com/u011285708/article/details/117246012</link><guid>https://blog.youkuaiyun.com/u011285708/article/details/117246012</guid><author>u011285708</author><pubDate>Tue, 25 May 2021 07:46:53 +0800</pubDate><description><![CDATA[一、双1参数
1、innodb_flush_log_at_trx_commit
innodb_flush_log_at_trx_commit这个参数控制MySQL在事务提交时将内存中的Redo log file从Redo log buffer刷新到磁盘(Redo log file)的方式。

value: 0 1 2

1）0

每秒钟将内存中Redo log File从Redo Log Buffer刷新到OS Buffer并调用fsync()将OS Buffer刷新到磁盘(数据库宕机时，可能会有数据丢失)]]></description><category></category></item><item><title><![CDATA[数据库通用学习线路(方法论)]]></title><link>https://blog.youkuaiyun.com/u011285708/article/details/117171948</link><guid>https://blog.youkuaiyun.com/u011285708/article/details/117171948</guid><author>u011285708</author><pubDate>Sat, 22 May 2021 21:28:24 +0800</pubDate><description><![CDATA[一、安装部署
1、单机安装：rpm、二进制、yum安装、docker安装
2、环境变量设置
3、配置远程登录
4、连接数据库的命令行工具
5、db和实例的关系
6、升级(大版本升级、小版本升级)
二、体系结构
1、物理结构：物理文件
2、逻辑结构：逻辑组件
3、内存结构：
4、进程结构：
5、存储结构：
三、备份恢复(注意客户端和服务端工具)
1、逻辑备份
2、物理备份(全量和增量)
3、文件导出和导入
4、闪回
四、高可用
1、物理复制(DG、流复制)
2、逻辑复制(逻辑DG、逻辑订阅、MySQL主从复制]]></description><category></category></item><item><title><![CDATA[MySQL修改Undo表空间存储目录]]></title><link>https://blog.youkuaiyun.com/u011285708/article/details/117171848</link><guid>https://blog.youkuaiyun.com/u011285708/article/details/117171848</guid><author>u011285708</author><pubDate>Sat, 22 May 2021 21:21:25 +0800</pubDate><description><![CDATA[1、查询源undo表空间目录
mysql[(none)]&gt;show variables like 'innodb_undo%';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| innodb_undo_directory    | ./    |
| innodb_undo_log_encrypt  | OFF   |
| i]]></description><category></category></item><item><title><![CDATA[以逻辑卷方式挂载已安装的MySQL目录]]></title><link>https://blog.youkuaiyun.com/u011285708/article/details/117146875</link><guid>https://blog.youkuaiyun.com/u011285708/article/details/117146875</guid><author>u011285708</author><pubDate>Sat, 22 May 2021 07:31:21 +0800</pubDate><description><![CDATA[一、关闭MySQL
systemctl stop mysqld
ls -ld /var/lib/mysql
二、创建一个卷组、创建一个逻辑卷用于挂载MySQL目录
[root@docker ~]# vgs
VG        #PV #LV #SN Attr   VSize   VFree
centos      1   4   0 wz–n-  98.00g     0
vg-docker   9   1   0 wz–n- 449.96g 49.96g
vg-mysql    9   1   0 wz–]]></description><category></category></item><item><title><![CDATA[RHEL6.5_Oracle_11.2.0.4 RAC 删除和添加节点]]></title><link>https://blog.youkuaiyun.com/u011285708/article/details/116973039</link><guid>https://blog.youkuaiyun.com/u011285708/article/details/116973039</guid><author>u011285708</author><pubDate>Tue, 18 May 2021 07:57:54 +0800</pubDate><description><![CDATA[6.12 RHEL6.5_Oracle_11.2.0.4 RAC 删除和添加节点
6.12.1 RAC中删除和保留节点信息
保留节点：		节点1
删除的节点：		节点2
重新添加的节点：	节点2
6.12.2 删除节点
6.12.2.1 保留节点备份OCR
ocrconfig -showbackup;
ocrconfig -manualbackup;
ocrconfig -local -manualbackup;
ocrconfig -export “/u01/app/11.2.0.4/grid/cdata]]></description><category></category></item><item><title><![CDATA[打补丁时父补丁和子补丁相关安装回滚问题]]></title><link>https://blog.youkuaiyun.com/u011285708/article/details/115277202</link><guid>https://blog.youkuaiyun.com/u011285708/article/details/115277202</guid><author>u011285708</author><pubDate>Sun, 28 Mar 2021 10:33:25 +0800</pubDate><description><![CDATA[打补丁时父补丁和子补丁相关安装回滚问题
[oracle@lissen-n2 32119931]$ $ORACLE_HOME/OPatch/opatch lspatches
30138470;Database Oct 2019 Release Update : 12.2.0.1.191015 (30138470)
30122814;OCW OCT 2019 RELEASE UPDATE 12.2.0.1.191015 (30122814)
30133625;OJVM RELEASE UPDATE: 12.2.]]></description><category></category></item><item><title><![CDATA[Linux7.4_x86_64 Oracle 12.2.0.1 RAC环境打RU打时候报错处理]]></title><link>https://blog.youkuaiyun.com/u011285708/article/details/115218546</link><guid>https://blog.youkuaiyun.com/u011285708/article/details/115218546</guid><author>u011285708</author><pubDate>Thu, 25 Mar 2021 21:01:54 +0800</pubDate><description><![CDATA[Linux7.4_x86_64 Oracle 12.2.0.1 RAC环境打RU打时候报错处理
在使用opatchauto使用nonrolling方式手动打补丁的时候报错
Execution of [OPatchAutoBinaryAction] patch action failed, check log for more details. Failures:
Patch Target : lissen-n1-&gt;/u01/app/oracle/product/12.2.0.1/dbhome_1 Ty]]></description><category></category></item><item><title><![CDATA[Linux7.4设置默认启动模式]]></title><link>https://blog.youkuaiyun.com/u011285708/article/details/112167457</link><guid>https://blog.youkuaiyun.com/u011285708/article/details/112167457</guid><author>u011285708</author><pubDate>Mon, 04 Jan 2021 07:29:40 +0800</pubDate><description><![CDATA[1、获取启动相关信息
[root@aaa etc]# cat /etc/inittab
# inittab is no longer used when using systemd.
#
# ADDING CONFIGURATION HERE WILL HAVE NO EFFECT ON YOUR SYSTEM.
#
# Ctrl-Alt-Delete is handled by /usr/lib/systemd/system/ctrl-alt-del.target
#
# systemd uses 'ta]]></description><category></category></item><item><title><![CDATA[MySQL修改配置文件增加表空间个数导致系统无法启动[转]]]></title><link>https://blog.youkuaiyun.com/u011285708/article/details/104604015</link><guid>https://blog.youkuaiyun.com/u011285708/article/details/104604015</guid><author>u011285708</author><pubDate>Mon, 02 Mar 2020 02:51:15 +0800</pubDate><description><![CDATA[修改配置文件启动MySQL报错:
2017-05-31T10:31:05.945111Z 0 [Note] InnoDB: Need to create a new innodb_system data file 'ibdata2'.
2017-05-31T10:31:05.945126Z 0 [Note] InnoDB: Need to create a new innodb_system da...]]></description><category></category></item><item><title><![CDATA[MySQL中MyISAM和InnoDB存储引擎区别[转]]]></title><link>https://blog.youkuaiyun.com/u011285708/article/details/104585443</link><guid>https://blog.youkuaiyun.com/u011285708/article/details/104585443</guid><author>u011285708</author><pubDate>Sun, 01 Mar 2020 00:12:24 +0800</pubDate><description><![CDATA[MyISAM和InnoDB两者区别如下:
1) 事...]]></description><category></category></item><item><title><![CDATA[MySQL5.7 Linux7.4主从切换]]></title><link>https://blog.youkuaiyun.com/u011285708/article/details/104585222</link><guid>https://blog.youkuaiyun.com/u011285708/article/details/104585222</guid><author>u011285708</author><pubDate>Sat, 29 Feb 2020 23:52:48 +0800</pubDate><description><![CDATA[1、检查原主库和原备库是否正常
原主库：
mysql&gt; show master status\G;
*************************** 1. row ***************************
             File: mysql-bin.000009
         Position: 4868
     Binlog_Do_DB: test_...]]></description><category></category></item><item><title><![CDATA[Oracle分区表使用详解]]></title><link>https://blog.youkuaiyun.com/u011285708/article/details/104544951</link><guid>https://blog.youkuaiyun.com/u011285708/article/details/104544951</guid><author>u011285708</author><pubDate>Thu, 27 Feb 2020 21:21:17 +0800</pubDate><description><![CDATA[一、分区表的概念
分区表：

当表中的数据量不断增大，查询数据的速度就会变慢，应用程序的性能就会下降，这时就应该考虑对表进行分区。表进行分区后，逻辑上表仍然是一张完整的表，只是将表中的数据在物理上存放到多个“表空间”(物理文件上)，这样查询数据时，不至于每次都扫描整张表而只是从当前的分区查到所要的数据大大提高了数据查询的速度。

"""分区表的具体作用"""

Oracle的表分区功能通过改善可管...]]></description><category></category></item></channel></rss>