..experience – 第 3 页

centos 7中配置keepalived日志为别的路径

2018-10-18 没有评论

keepalived 安装：

cd <keepalived_sourcecode_path>
./configure --prefix=/usr/local/keepalived

make &&  make install

mkdir /etc/keepalived
mkdir /etc/keepalived/scripts
cp /usr/local/keepalived/etc/keepalived/keepalived.conf /etc/keepalived/
cp /root/keepalived-2.0.6/keepalived/etc/init.d/keepalived  /etc/init.d/
cp /usr/local/keepalived/sbin/keepalived /sbin/keepalived
cp /usr/local/keepalived/etc/sysconfig/keepalived /etc/sysconfig/
chmod +x /etc/init.d/keepalived

1

2

3

4

5

6

7

8

9

10

11

12

cd <keepalived_sourcecode_path>

./configure --prefix=/usr/local/keepalived

make && make install

mkdir /etc/keepalived

mkdir /etc/keepalived/scripts

cp /usr/local/keepalived/etc/keepalived/keepalived.conf /etc/keepalived/

cp /root/keepalived-2.0.6/keepalived/etc/init.d/keepalived /etc/init.d/

cp /usr/local/keepalived/sbin/keepalived /sbin/keepalived

cp /usr/local/keepalived/etc/sysconfig/keepalived /etc/sysconfig/

chmod +x /etc/init.d/keepalived

由于在默认状态下keepalived的日志会写入到/var/log/message中，我们需要将此剥离出来。在centos 6下可以：

（1）首先修改/etc/sysconfig/keepalived文件，注释掉如下，添加如下： 
#KEEPALIVED_OPTIONS="-D"
KEEPALIVED_OPTIONS="-D -d -S 0" 

（2）其次修改 /etc/rsyslog.conf 文件，添加如下：
local0.* /var/log/keepalived.log

1

2

3

4

5

6

（1）首先修改/etc/sysconfig/keepalived文件，注释掉如下，添加如下：

#KEEPALIVED_OPTIONS="-D"

KEEPALIVED_OPTIONS="-D -d -S 0"

（2）其次修改 /etc/rsyslog.conf 文件，添加如下：

local0.* /var/log/keepalived.log

[…]

..experience, Working case

pg数据库授权表给只读用户之后，权限慢慢消失

2017-11-16 2条评论

越来越多的互联网企业在使用postgresql数据库，我们也不例外。昨天开发请我建立了一个只读用户abc_tmp_test用户，并且将mkl_rw用户下的32个表授权给只读用户用。ok，请简单轻松的一个需求，很快就完成了。但是今天开发来和我说，昨天授权的几个表中，有部分表还是没有权限去读取，让我 […]

..experience, Working case

如何找到postgres中疯狂增长的wal日志的语句

2017-09-10 没有评论

很久以前，我写过一个文章，《如何查找疯狂增长arch的进程》，讲述在oracle数据库中如何查找导致当前疯狂增长arch的session。今天，我们在postgresql数据库中也遇到了类似的问题。在一个时间内，wal日志疯狂的增长，大约每分钟产生1G，而xlog疯狂cp去归档的结果，导致xlog […]

..experience, Working case

pg的跨库查询

2017-08-30 没有评论

mysql和mssql的跨库查询，基本只需要dbname.schema.table_name就可以实现，而pg的跨库查询，和oracle一样，需要通过类似dblink的方式来实现。pg在9.3之前建议使用dblink，在9.3之后，建议使用postgres_fwd(foreign-data wrap […]

..experience, Working case

利用Oracle存储过程发送邮件

2017-08-21 没有评论

/**配置ACL***/ begin dbms_network_acl_admin.create_acl ( acl => ‘smtp_permissions.xml’, — or any other name description => ‘SMTP […]

..experience, Working case

ASM添加磁盘最佳实践

2017-08-21 4条评论

当FRA区或者DATA区磁盘空间不够的时候，我们需要为ASM添加磁盘。添加磁盘的high level的步骤为： 1. SA分配共享磁盘，要求在多个节点都能看到这些磁盘。 2. 将共享磁盘分区，将分区后的磁盘，创建成asmdisk 3. 将asmdisk加入到asm的diskgroup中下面是具体 […]

..experience, Working case

令人误解的ORA-16047: DGID mismatch between destination setting and target database

2017-06-29 没有评论

今天为一个Rac onenode的主库搭建好一个dg库之后，一直没有传日志，在主库的alertlog中，有报错：

Thu Jun 29 14:55:34 2017
ALTER SYSTEM SET log_archive_dest_state_2='DEFER' SCOPE=BOTH;
Thu Jun 29 14:55:44 2017
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;
Thu Jun 29 14:55:44 2017
Errors in file /data/prd/oracle/diag/rdbms/payroll/payroll_2/trace/payroll_2_tt00_27554.trc:
ORA-16047: DGID mismatch between destination setting and target database
Thu Jun 29 14:55:44 2017
Errors in file /data/prd/oracle/diag/rdbms/payroll/payroll_2/trace/payroll_2_tt00_27554.trc:
ORA-16047: DGID mismatch between destination setting and target database
Thu Jun 29 14:55:44 2017
Errors in file /data/prd/oracle/diag/rdbms/payroll/payroll_2/trace/payroll_2_tt00_27554.trc:
ORA-16047: DGID mismatch between destination setting and target database
Thu Jun 29 14:55:45 2017
Thread 2 advanced to log sequence 632 (LGWR switch)
  Current log# 7 seq# 632 mem# 0: +DATA/PAYROLL/ONLINELOG/group_7.303.946836271
  Current log# 7 seq# 632 mem# 1: +FRA/PAYROLL/ONLINELOG/group_7.791.946836271
Thu Jun 29 14:55:45 2017

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

Thu Jun 29 14:55:34 2017

ALTER SYSTEM SET log_archive_dest_state_2='DEFER' SCOPE=BOTH;

Thu Jun 29 14:55:44 2017

ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;

Thu Jun 29 14:55:44 2017

Errors in file /data/prd/oracle/diag/rdbms/payroll/payroll_2/trace/payroll_2_tt00_27554.trc:

ORA-16047: DGID mismatch between destination setting and target database

Thu Jun 29 14:55:44 2017

Errors in file /data/prd/oracle/diag/rdbms/payroll/payroll_2/trace/payroll_2_tt00_27554.trc:

ORA-16047: DGID mismatch between destination setting and target database

Thu Jun 29 14:55:44 2017

Errors in file /data/prd/oracle/diag/rdbms/payroll/payroll_2/trace/payroll_2_tt00_27554.trc:

ORA-16047: DGID mismatch between destination setting and target database

Thu Jun 29 14:55:45 2017

Thread 2 advanced to log sequence 632 (LGWR switch)

Current log# 7 seq# 632 mem# 0: +DATA/PAYROLL/ONLINELOG/group_7.303.946836271

Current log# 7 seq# 632 mem# 1: +FRA/PAYROLL/ONLINELOG/group_7.791.946836271

Thu Jun 29 14:55:45 2017

根据oerr的报错信息：

SQL> !oerr ora 16047
16047, 00000, "DGID mismatch between destination setting and target database"
// *Cause:  The DB_UNIQUE_NAME specified for the destination did not match
//          the DB_UNIQUE_NAME at the target database.
// *Action: Make sure the DB_UNIQUE_NAME specified in the LOG_ARCHIVE_DEST_n
//          parameter matches the DB_UNIQUE_NAME parameter defined at the
//          destination.

SQL>

1

2

3

4

5

6

7

8

9

SQL> !oerr ora 16047

16047, 00000, "DGID mismatch between destination setting and target database"

// *Cause: The DB_UNIQUE_NAME specified for the destination did not match

// the DB_UNIQUE_NAME at the target database.

// *Action: Make sure the DB_UNIQUE_NAME specified in the LOG_ARCHIVE_DEST_n

// parameter matches the DB_UNIQUE_NAME parameter defined at the

// destination.

SQL>

检查了主库和备库的db_un […]

..experience, Working case

Oracle在12.1.0.2开始改变了补丁策略

2017-06-09 没有评论

Oracle在12.1.0.2开始，改变了补丁策略：在12.1.0.2之前，即12.1.0.1，11.2.0.4或者更早的版本之前，是推荐使用PSU的补丁策略的。但是从12.1.0.2开始，oracle更推荐使用Database Proactive Bundle Patches（简称DPBP）。 D […]

..experience, Working case

在阿里云上创建dataguard+FSFO

2017-05-14 没有评论

在阿里云上创建rac或者rac onenode，共享存储比较麻烦，需要配iSCSI，我们可以用dataguard+fsfo架构来类似的实现高可用方案。本文介绍了在阿里云上oracle 12.1.0.2 dataguard+fsfo的搭建过程。（一）、基础工作序列：阿里云上创建Oracle […]

..experience, Working case

多核还是多线程？

2017-05-14 一条评论

数据库选型，是用多核主机还是多线程主机？我是否可以用比较便宜的单核超线程（Hyper-Threading,HT）的机器，来替代双核非HT的机器？回答这个问题，我们由浅入深的来看。一，术语：槽位（socket）：指机器上可以容纳物理CPU个数的空间。一般也成为多少多少“路”，英文除了socket […]

..experience, Working case

关于11g和12c数据库初始化参数的一些最佳实践参考

2017-04-20 没有评论

Base on 11.2.0.4 : Base on 12.1.0.2 :

..experience, Working case

关于MSSQL AlwaysOn 主从Lag监控的一些探讨

2017-03-21 没有评论

alwayson数据同步流程图（以SAP应用为例）：上图中： Step 1: In a typical case the SAP application would send a commit to finalize a transaction. Step 2: The commit record […]