01 2019 档案

摘要:1.输出binlog到文件mysqlbinlog --base64-output=decode-rows -v /home/mysql/binlog/binlog.000011>/tmp/aa.txt 2.查看某个pos后的多少行show binlog events IN 'binlog.00001 阅读全文
posted @ 2019-01-25 09:02 slnngk 阅读(137) 评论(0) 推荐(0) 编辑
摘要:根据现有ES版本,安装对应版本的插件 [es@hxl ~]$ cd elasticsearch[es@hxl elasticsearch]$ ./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sq 阅读全文
posted @ 2019-01-24 18:26 slnngk 阅读(1238) 评论(0) 推荐(0) 编辑
摘要:1.下载 elastichd下载地址:https://github.com/360EntSecGroup-Skylar/ElasticHD/releases或是直接在linux下下载wget https://github.com/360EntSecGroup-Skylar/ElasticHD/rel 阅读全文
posted @ 2019-01-24 16:51 slnngk 阅读(1461) 评论(0) 推荐(0) 编辑
摘要:#!/bin/bash now_date=`date "+%Y-%m-%d,%H:%M:%S"` flag_old=`cat /home/oracle/scripts/flag.txt|cut -d '|' -f 1` flag_new=`mysql -P3306 -hlocalhost -uroot -ptestpwd -D mysql -e "show slave status\G"... 阅读全文
posted @ 2019-01-24 14:35 slnngk 阅读(291) 评论(0) 推荐(0) 编辑
摘要:1.停掉从库/opt/mysql57_slave/bin/mysqladmin -h localhost -uroot -P13306 -pmysql -S /opt/mysql57_slave/mysql.sock shutdown 2.主库上创建同步账号 grant replication sl 阅读全文
posted @ 2019-01-24 11:22 slnngk 阅读(982) 评论(0) 推荐(0) 编辑
摘要:DB:5.6.15 主从库没有采用GTID案例1:从库对象不存在mysql> show slave status \G;*************************** 1. row *************************** Slave_IO_State: Waiting for 阅读全文
posted @ 2019-01-23 17:02 slnngk 阅读(470) 评论(0) 推荐(0) 编辑
摘要:1.列出物理机器上安装的虚拟[root@localhost ~]# virsh list --all Id Name State 2 kvm-CentOS-7-119 running 3 kvm-CentOS-7-120 running 4 kvm-CentOS-7-121 running 9 kv 阅读全文
posted @ 2019-01-21 08:50 slnngk 阅读(341) 评论(0) 推荐(0) 编辑
摘要:python版本[testuser@localhost tmp]$ python -VPython 2.7.5 需要提前安装RDS[root@localhost ~]# yum -y install epel-release[root@localhost ~]# yum -y install pyt 阅读全文
posted @ 2019-01-18 10:15 slnngk 阅读(429) 评论(0) 推荐(0) 编辑
摘要:es参考手册地址: https://www.elastic.co/guide/en/elasticsearch/reference/6.8/indices-get-mapping.html 1.查看es日志curl -XGET http://10.26.41.60:9200/xdm-logs-201 阅读全文
posted @ 2019-01-17 10:45 slnngk 阅读(926) 评论(0) 推荐(0) 编辑
摘要:deletearchlog.sh #!/bin/sh export PATH TABLE='v$archived_log' sqlplus -silent "/ as sysdba" /home/oracle/script/deleteorclarch.sh set heading off; set pagesize 0; set term off; set feedback off; s... 阅读全文
posted @ 2019-01-16 15:17 slnngk 阅读(440) 评论(0) 推荐(0) 编辑
摘要:wget http://downloads.sourceforge.net/project/sshpass/sshpass/1.05/sshpass-1.05.tar.gztar xvzf sshpass-1.05.tar.gzcd sshpass-1.05./configure makemake 阅读全文
posted @ 2019-01-16 08:59 slnngk 阅读(4156) 评论(0) 推荐(0) 编辑
摘要:安装expectcd /tmp wget http://core.tcl.tk/tcl/zip/release/tcl.zipwget https://jaist.dl.sourceforge.net/project/expect/Expect/5.45.3/expect5.45.3.tar.gz 阅读全文
posted @ 2019-01-16 08:55 slnngk 阅读(532) 评论(0) 推荐(0) 编辑
摘要:set head offset echo offset feed offset heads offset pages 50000SET NEWPAGE NONEcolumn yesterday new_value checkdate noprint;select to_char(sysdate-1, 阅读全文
posted @ 2019-01-15 17:41 slnngk 阅读(223) 评论(0) 推荐(0) 编辑
摘要:1.从备份集恢复某个归档日志到指定的目录 run{allocate channel ci type disk;set archivelog destination to '/home/oracle/myarchlog';restore archivelog sequence 299;release 阅读全文
posted @ 2019-01-15 09:20 slnngk 阅读(439) 评论(0) 推荐(0) 编辑
摘要:1.退出日志应用模式[oracle@localhost ~]$ sqlplus /nolog SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 14 16:09:16 2019 Copyright (c) 1982, 2013, Oracle. A 阅读全文
posted @ 2019-01-14 16:23 slnngk 阅读(467) 评论(0) 推荐(0) 编辑
摘要:准备工作,使用如下脚本进行数据库的全备份[oracle@localhost ~]$ more rman_backup.sh #!/bin/sh RMAN_OUTPUT_LOG=/home/oracle/rman_output.logRMAN_ERROR_LOG=/home/oracle/rman_e 阅读全文
posted @ 2019-01-14 15:36 slnngk 阅读(730) 评论(0) 推荐(0) 编辑
摘要:1.从库复制进程报如下错误 ************************************************************************* Run Time Messages ******************************************** 阅读全文
posted @ 2019-01-12 21:58 slnngk 阅读(4698) 评论(0) 推荐(0) 编辑
摘要:环境: OS:Red Hat Linux As 5 1.find 11.查找当前目录以及子目录下包含ORA字符的文件 find . -type f|xargs grep "ORA"2.查看当前目录占用空间大小[root@localhost soft]# pwd/soft[root@localhost 阅读全文
posted @ 2019-01-12 21:51 slnngk 阅读(1303) 评论(0) 推荐(0) 编辑
摘要:1.压缩和解压 tar压缩tar -czf hxl_product.tar.gz ./product tar解压tar -xzvf hxl_app.tar.gz z选项会将该压缩文件直接解压到目录,要是想先解压成tar后缀的文件可以使用如下命令: gunzip hxl_app.tar.gz 查看ta 阅读全文
posted @ 2019-01-10 22:38 slnngk 阅读(210) 评论(0) 推荐(0) 编辑
摘要:1.全备份例子 #!/bin/sh RMAN_OUTPUT_LOG=/home/oracle/rman_output.logRMAN_ERROR_LOG=/home/oracle/rman_error.logrman target / log=/home/oracle/rman_output.log 阅读全文
posted @ 2019-01-09 19:25 slnngk 阅读(245) 评论(0) 推荐(0) 编辑
摘要:1.数据库开启审计alter system set audit_trail=db,extended scope=spfile;shutdown immediatestartup 2.对某个表进行审计connect / as sysdbaSQL> show user;USER is "SYS" SQL 阅读全文
posted @ 2019-01-04 16:56 slnngk 阅读(245) 评论(0) 推荐(0) 编辑
摘要:今天在做看OCP的时候有道题是关于应用安全角色的,不是很明白,在网上找了个例子按照步骤验证了下.QUESTION 48You want to create a role to meet these requirements:1. The role is to be protected from un 阅读全文
posted @ 2019-01-03 16:43 slnngk 阅读(364) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示