07 2021 档案
摘要:环境: OS:Centos 7 DB:18C 2节点RAC的ADG 下面的操作在rac的一个节点上执行即可 1.检查闪回是否开启SQL> select flashback_on from V$database; FLASHBACK_ON NO 2.查看当前是否设置了闪回的相关参数SQL> show
阅读全文
摘要:1.查看当前主库配置的trail情况 GGSCI (rac01) 23> info exttrail * Extract Trail: ./dirdat/ep Seqno Length: 9 Flip Seqno Length: no Extract: DPEP Seqno: 79 RBA: 891
阅读全文
摘要:(error) CROSSSLOT Keys in request don’t hash to the same slot 解决办法: /usr/local/services/redis/bin/redis-cli -h 192.168.1.1 -p 7001 -a ptest KEYS "test
阅读全文
摘要:1.主库的scn与备库的scn做比较,得出时间差 select (to_date(to_char(scn_to_timestamp((select current_scn from v$database)), 'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI
阅读全文
摘要:环境: OS:Centos 7 DB:18.3.0.0 在做2节点rac到2节点rac的dataguard的时候,第一次配置完成后,同步是正常的但是机器重启后,发现一个实例无法自动启动asm(手工是可以的),查看报错的信息: Trace file /u01/grid/grid_base/diag/c
阅读全文
摘要:startup mount pfile='/tmp/pfile0722.txt' 错误信息:Fatal NI connect error 12547, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01/grid/grid
阅读全文
摘要:环境: OS:Centos 7 DB:18.3.0.0 问题:Errors in file /u01/oracle/app/diag/rdbms/slnngk/slnngk1/trace/slnngk1_j000_949.trc:ORA-12012: error on auto execute of
阅读全文
摘要:1.备份数据库db_test/opt/mysql5729/bin/mysqldump -h localhost -uroot -pmysql -P13306 -S /opt/mysql5729/mysql.sock db_vaccination --default-character-set=utf
阅读全文
摘要:环境: DB:18.3.0.0 OS:Centos 7 在做2节点rac-rac的时候,备库一个节点无法启动,报错信息如下:1.报错信息2021-07-19T04:20:26.842539-04:00ALTER SYSTEM SET remote_listener=' rac-scan:1521'
阅读全文
摘要:环境: DB:18C RAC 1.查看数据库当前的配置[grid@rac01 ~]$ crsctl stat res ora.slnngk.db -p|grep AUTO_STARTAUTO_START=restore其中restore表示还原、恢复的含义,是把实例状态恢复到CRS停止前的状态。 2
阅读全文
摘要:判断某个目录下半小时内是否有新文件 #!/bin/bash timenow=`date +"%Y-%m-%d %H:%M:%S";` ##timeago=`date -d "1 hour ago" +"%Y-%m-%d %H:%M:%S";` timeago=`date -d "30 minute
阅读全文
摘要:环境: OS:Centos 7 1.添加磁盘虚拟机添加磁盘设备,接口类型选择SATA 2.多路径查看磁盘设备[root@localhost data]# multipath -llmpatha (VMware_Virtual_SATA_Hard_Drive_00000000000000000001)
阅读全文
摘要:以下步骤需要在2个节点上做同样的配置 1.虚拟机添加新的磁盘虚拟机添加磁盘后,让系统扫描到新的磁盘,或是重启动系统 2.系统重启后相应的配置项会自动生成[root@rac01 ~]# more /etc/multipath/wwids# Multipath wwids, Version : 1.0#
阅读全文
摘要:当前版本:20.8.13 新版本:21.6.6 1.下载更新的rpm包下载地址:https://mirrors.tuna.tsinghua.edu.cn/clickhouse/rpm/stable/x86_64/ 2.将下载的包上传到服务器的相应目录[root@localhost ck21]# ls
阅读全文
摘要:环境: OS:Centos 7/Centos 6 安装grafana 1.安装 [root@localhost soft]# rpm -ivh grafana-5.2.1-1.x86_64.rpm warning: grafana-5.2.1-1.x86_64.rpm: Header V4 RSA/
阅读全文
摘要:1.在线安装[root@localhost plugins]#grafana-cli plugins install vertamedia-clickhouse-datasource[root@localhost plugins]#systemctl restart grafana-server.s
阅读全文
摘要:切换成集成模式 GGSCI (ora11g) 77> stop repepGGSCI (ora11g) 63> alter repep, integrated 2021-07-01 14:05:58 INFO OGG-06594 Replicat REPEP has been altered. Ev
阅读全文
摘要:ogg版本:12.3.0.1 1.停掉主库的相关进程GGSCI (rac01 as goldengate@slnngk1) 30> stop dpepSending STOP request to EXTRACT DPEP ...Request processed. GGSCI (rac01 as
阅读全文