- 博客(994)
- 资源 (19)
- 收藏
- 关注
原创 rhel6-redhat6-centos6 网络yum 源地址配置
由于linux 6 的版本已经归档,原来各个平台阿里,网易的镜像地址已经无法使用,只能使用网易的归档后的yum 地址[root@host-lixora yum.repos.d]# pwd/etc/yum.repos.d[root@host-lixorayum.repos.d]# cat CentOS6-Base-163.repo[lixora]name=CentOS-$releasever - Base - 163.combaseurl=http://mirrors.163.com..
2020-11-24 19:48:04 290 1
原创 最近做了一次网闸压测的性能评估
用的工具是ab,模拟用户url 链接请求,查看每次请求响应时间,但是每次的请求时间没有太大意义,建议使用请求量百分比占用情况来反应服务请求时间;
2020-10-26 09:33:14 705
原创 从勒索软件攻击中恢复 sql server 数据库 mdf文件
最近一个朋友的sql server 数据库中了勒索加密病毒,找到我帮忙,花了点时间帮他找回了99%的数据
2020-10-21 17:30:34 476
原创 NetBackup for Oracle 的一些交互细节点
NetBackup for Oracle 操作下面列出了启动 RMAN 时发生的操作: NetBackup Oracle 策略可以包含一个或多个客户端名称和一个或多个要执行的备份脚本。 注意: Oracle 11g R2 网格基础架构 (CRS) 包括单一客户端访问名称 (SCAN) 功能。使用此功能可以将单个主机名解析为多个 IP 地址,每个 IP 地址被分配给群集中不同的物理节点。请确保出现在 NetBackup Oracle 策略中的客户端不是 SCAN。另外,请确保客户端主机在备.
2020-10-14 10:40:08 330
原创 InnoDB: Database page corruption on disk or a failed 服务器磁盘损坏,mysql ibd 数据恢复
2020-09-26T02:08:47.027083Z 0 [Note] InnoDB: Starting crash recovery.2020-09-26T02:08:47.027083Z 0 [Note] InnoDB: Reading tablespace information from the .ibd files...2020-09-26T02:08:47.068115Z 0 [Note] InnoDB: Restoring possible half-written data page.
2020-09-30 09:35:42 697
原创 How To Skip a Transaction When GTIDs Are Enabled? (Doc ID 2043205.1)
How To Skip a Transaction When GTIDs Are Enabled? (Doc ID 2043205.1) To Bottom Goal Solution References APPLIES TO: MySQL Server - Version 5.6 and later Information in this document applies ...
2020-09-03 11:49:30 169
原创 Clone a Replication Slave From a Live Master using Global Transaction IDs (GTID) and mysqldump (Doc
Clone a Replication Slave From a Live Master using Global Transaction IDs (GTID) and mysqldump (Doc ID 1589291.1) To Bottom In this Document Goal Solution References APPLIES TO: MySQL Serve...
2020-09-03 11:33:26 118
原创 mysql: Change Replication Topology A->B,C to A->B->C (Doc ID 1444892.1)
Change Replication Topology A->B,C to A->B->C (Doc ID 1444892.1) To Bottom In this Document APPLIES TO: MySQL Server - Version 5.5 and later Information in this document applies to any platform. GOAL Change from mas
2020-09-03 11:26:04 164
原创 Mysql 5.7 主从高可用容灾 最佳实践
Mysql容灾环境规划 主机名 IP/Port ROLE OS Version MySQL Version GTID Mode Binlog Format Lixora 192.168.1.99/3306 master CentOS 7.1 5.7.24
2020-09-01 15:34:48 1250
原创 find asm holder session
-- Connect ASM instance as sys-- 2013/09/08 kyle Heo Created-- NOTE: If this sql is run on < 11.2 ASM version, -- p.pname column should be replaced by p.program Session Information Section belowset linesize 200set pagesize 1000column user.
2020-08-14 15:57:53 129
原创 批量 rman 自动备份脚本
sid=`ps -ef|grep smon |egrep -v "+ASM|grep|opt"|awk '{print $8}'|awk -F "_" '{print $3}'`for id in $siddoecho $idexport ORACLE_SID=$idecho $ORACLE_SID##backup .
2020-08-05 23:29:33 245
原创 dm8 DSC 集群数据库安装
一、安装规划环境说明主机规划: IP Addr DB Version OS Version 节点1 192.168.1.38(业务网)192.168.25.11(内网) DM V8 DSC Veriosn: V2.0 节点2 192.168.1.18(业务网)192.168.25.12(内网...
2020-07-31 09:53:24 1112
原创 dm达梦数据库实现 disql 等工具命令上下翻动
1.安装 rlwrapyum install rlwrap-0.42-1.el6.x86_642.配置 shell 别名su - dmdbavi ~/.bash_profilealias disql="rlwrap disql"alias dmrman="rlwrap dmrman"
2020-07-23 16:53:02 274
原创 mysql 启动异常处理:[ERROR] InnoDB: Operating system error number 13 in a file operation.
###问题日志:2020-07-16T01:26:34.626656Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2020-07-16T01:26:34.671803Z 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.2020-07-16T01:26:34.671866Z 0 [ERROR] InnoDB: The error m
2020-07-16 10:00:41 1950
原创 dm-数据库安装
iptables -Fiptables -Xsystemctl stop firewalldsetenforce 0vim /etc/selinux/configSELINUX=disabledgroupadd dinstalluseradd -g dinstall dmdbachown dmdba.dinstall -R /dm8vim /etc/security/limits.confdmdba soft nofile 4096dmdba hard nofile 6553
2020-07-14 23:38:33 342
原创 MySQL innodb DUL 数据文件离线抽取工具 undrop-for-innodb-windows
花了一点时间做了一个window版的 undrop for innodb ,用于windows 平台误操作(delete,drop,truncate)数据恢复,同时支持window 平台文件系统损坏时,在底层文件系统上上进行mysql ibd 挖掘,尽可能的恢复mysql 数据;mysql innodb dul for windows 平台undrop-for-innodb-windowsmysql 紧急技术恢复服务热线:1565865544 7...
2020-07-14 22:55:18 740
原创 Database Startup On Solaris 10 Fails With Ora-27102 Out Of Memory Error (Doc ID 399895.1)
Database Startup On Solaris 10 Fails With Ora-27102 Out Of Memory Error (Doc ID 399895.1) To Bottom APPLIES TO: Oracle Database - Enterprise Edition - Version 9.2.0.8 to 12.1.0.2 [Release 9.2 to 12.1] Solaris Operating System - V.
2020-06-01 21:22:39 305 2
原创 python 正则函数 re.findall 将符合匹配的关键词行过滤出来
#遍历制定目录,找出所有 mysql frm 文件# !usr/bin/env python# -*- coding:utf-8 _*-"""@Author:huanglj@File:reeee.py@Time:2020/4/24 10:19"""import osimport repath = "C:\\Users\\Administrator\\Desktop"pa...
2020-04-24 14:11:12 662
原创 ORA-12152: TNS:unable To Send Break Message During Inserts (Doc ID 1942951.1)
ORA-12152: TNS:unable To Send Break Message During Inserts (Doc ID 1942951.1) To Bottom In this Document Symptoms Cause Solution Refer...
2020-04-16 09:21:24 2666
原创 mysql internal: ALTER TABLE ... IMPORT TABLESPACE 操作原理
WhenALTER TABLE ... IMPORT TABLESPACEis run on the destination instance, the import algorithm performs the following operations for the tablespace being imported: Each tablespace page is checked ...
2020-04-01 09:07:31 2641
原创 达梦数据库dmdb配置数据库归档模式
####联机归档配置1)修改数据库为 MOUNT 状态。SQL>ALTER DATABASE MOUNT;2)配置本地归档。eg : ALTER DATABASE ADD ARCHIVELOG 'DEST = /home/dmdba/dmdbms/data/lixora/DAMENG/arch, TYPE = local,FILE_SIZE = 1024, SPACE_LIM...
2020-03-04 09:48:27 648
原创 "Error: 2013, Lost connection to MySQL server at 'reading authorization packet'" in MySQL Server
"Error: 2013, Lost connection to MySQL server at 'reading authorization packet'" in MySQL Server Error Log (Doc ID 1024157.1) To Bottom APPLIES TO: MySQL Server - Version 4.0 and lat...
2020-02-17 22:23:55 814
原创 远程服务器端口是否可以连接测试
nc -vw 2 10.80.18.201 1521Connection to 10.80.18.201 1521 port [tcp/ncube-lm] succeeded!telnet10.80.18.201 1521
2020-01-09 15:11:14 388
原创 Oracle传输表空间( tts & xtts )内部操作原理
[oracle@lixora ~]$ impdp \' / as sysdba \' directory=expdp file=test.dmp log=test.log transport_datafiles='/oracle1/test11.dbf' sqlfile=imp.filImport: Release 11.2.0.4.0 - Production on Thu Jan ...
2020-01-09 09:19:55 1231
原创 达梦数据库常用命令DMDB
达梦数据库修改 sysdba 账号密码:alterusersysdbaidentitiedby"lixora";持续更新。。。。
2019-12-27 11:33:17 2552
原创 oracle 手动搭建dg --rman 备份恢复脚本
#### rman 手动备份脚本rman msglog /home/oracle/adg_setup.log << EOFconnect targetRUN {allocate channel c1 device type disk;allocate channel c2 device type disk;allocate channel c3 device type ...
2019-12-26 10:20:15 597 1
原创 防火墙或者网闸超时机制导致数据库连接数异常处理
分析问题原因: 外网据库和应用间存在防火墙,导致数据库超时连接没有及时断开,耗尽oracle 进程数处理:1.调整oracle process 参数到12002. 配置oracle DCD timeout 603. 配置linux tcp 连接参数 后续需要待观察效果: net.ipv4.tcp_keepalive_time = 1200 net.ipv4.tcp_tw_...
2019-12-23 09:44:34 949
原创 How to use the _FIX_CONTROL hidden parameter (Doc ID 827984.1)
How to use the _FIX_CONTROL hidden parameter (Doc ID 827984.1) To Bottom In this Document Goal Solution References APPLIES TO: Oracle...
2019-12-20 11:11:37 329
原创 Info About Hidden Parameter _fix_control (Doc ID 782926.1)
Info About Hidden Parameter _fix_control (Doc ID 782926.1) To Bottom In this Document Goal Solution References APPLIES TO: Oracle...
2019-12-20 11:10:51 350
原创 检查oracle 表统计信息是否过期
--刷新数据库监控信息:exec dbms_stats.flush_database_monitoring_info;--过期状态查看:stale_stats 状态是否为“YES”select owner,table_name,object_type,stale_stats,last_analyzedfrom dba_tab_statisticswhere owner=''and ...
2019-12-10 09:32:59 1963
原创 mysql top sql 查看
###语句兼容mysql 5.6,5.7,8.0###top 10 sql:SELECT SCHEMA_NAME, DIGEST_TEXT, COUNT_STAR, sys.format_time ( SUM_TIMER_WAIT ) AS sum_time, sys.format_time ( MIN_TIMER_WAIT ) AS min_t...
2019-11-19 15:07:56 1786 4
原创 oracle AFD 19c Supported Platforms
ACFS and AFD19cSupported Platforms Vendor Version Update/Kernel Architecture ACFSBug or RU/RUR AFDBug or RU/RUR Oracle Linux – RedHat Compatibl...
2019-11-08 15:34:42 630
原创 Oracle AFD 18c Supported Platforms
ACFS and AFD18cSupported Platforms Vendor Version Update/Kernel Architecture ACFSBug or RU/RUR AFDBug or RU/RUR ...
2019-11-08 15:32:24 412
原创 Oracle AFD 12.2.0.1 Supported Platforms
ACFS and AFD12.2.0.1Supported Platforms Vendor Version Update/Kernel Architecture ACFS Bug or PSU or RU/RUR AFD Bug or PSU or RU/RUR Oracle...
2019-11-08 15:31:00 373
原创 mysql 5.6 以后版本union all 操作优化
mysql 5.6 vs 5.7 vs 8.0 版本优化器参数对比:mysql 5.6.42@@optimizer_switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condit...
2019-11-08 15:11:30 856
原创 mysql 在线表迁移 :alter table “move”
1)file-per-table tablespace 、system tablespace -----》 generaltablespaceALTER TABLE tbl_name TABLESPACE [=] tablespace_name;eg:alter table t1 tablespace ts1;move 完table后表原来的ibd 文件会被删除;2)...
2019-10-16 15:12:26 624 1
oracle 11g 数据文件头block 1解析
2023-11-16
golang 版 linux windows httpstat http url api 性能分析工具
2023-03-16
msp430课件
2013-06-17
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人