2020

2020 - 09

• 2020年快结束了(0)

2019

2019 - 08

• MHA v0.58搭建说明(0)
• pt-osc 3.0.13 mysql5.7.24(0)

2019 - 07

• mysql5.7 1032 1062自动化修复(0)

2019 - 06

• mysql5.7下mysqldump原理解析(0)
• MYSQL5.7.24UAT或仿真环境搭建(0)
• mysql多线程逻辑备份工具mydumper(0)
• zabbix 4.0 LTS agent部署及percona mysql plugin安装(0)
• zabbix 4.0.7 LTS安装(0)

2019 - 05

• MYSQL5.7 MGR搭建及利用mysqldump方式加节点(0)
• java代码内存消耗过高排查思路(0)

2019 - 03

• 15分钟核心业务切换(switchover)演练(0)

2019 - 02

• mysql事务隔离级别(0)
• start_udev至RAC网络服务不可用(0)
• 11.2.0.4 RAC OCR disk异常被dismount原因分析(1)
• MYSQL服务器的I/O调度器的选择设置(0)
• MYSQL5.7.24 query cache测试(0)
• sysbench简单使用说明(0)
• mysql5.7.24下索引、提交频率对InnoDB表写入速度的影响(0)
• mysql5.7.24下sql优化之分页(0)
• linux5.6 resize2fs: Permission denied to resize filesystem(0)

2018

2018 - 12

• mysql5.7伪双主快速搭建(0)
• MySQLSyntaxErrorException: Table ‘assetsdb.ASSETS_HARD’ doesn’t exist(0)
• MYSQL5.7.24error:The server quit without updating PID file(0)
• mysql5.7.24二进制快速安装(0)
• python快速交换两个变量数据(0)

2018 - 11

• mysql5.6 1595 Relay log write failure: could not queue event from master(0)

2018 - 08

• 监控某linux进程信息(0)

2018 - 07

• MYSQL5.7 INNODB引擎参数解析(三)(0)
• MYSQL5.7 INNODB引擎参数解析(二)(0)
• MYSQL5.7 INNODB引擎参数解析(一)(0)
• MYSQL5.7 buffer pool启动时加载(0)
• MYSQL5.7 ONLINE DDL(0)

2018 - 06

• python-django预定义字段说明(0)
• python-django(0)
• python开发网络知识01(0)

2018 - 04

• mysql5.6.39编译安装(0)
• mysql 5.6.39源码层面看参数(一)(0)
• mysql_config_editor面socket指定登录(0)
• 局域网yum源配置(0)
• MYSQL5.7 show slave status参数简介(0)
• MYSQL5.7Last_Errno: 1594因主机异常关闭至主备断开无法同步(0)

2018 - 03

• 11G single primary switchover RAC standby(0)

2018 - 02

• 11gR2下DATAGUARD备库增量恢复(0)

2017

2017 - 09

• mysql里ip地址存放(0)

2017 - 06

• JBOSS 5.1 相关文件介绍说明(0)
• How to Change the DBID and the DBNAME by using NID(0)
• How use the backupset of RMAN  to restore and recover on a new machine.(0)

2017 - 05

• 11gR2 buffer busy waits(0)
• Oracle enqueue informations(0)

2017 - 04

• LINUX下ADG+LVM+DOCKER(0)
• CentOS 6.5 install docker准备工作(0)
• DOCKER里实现oracle库容器化一(0)
• ORA-04030: out of process memory when trying to allocate 16328 bytes (PLSQL Opt Pool,pdziM01_Create: New Set)(0)
• The “java.lang.OutOfMemoryError: Java heap space” error in kettle(0)

2017 - 02

• ORA-07445 [opiaba()+639]  ORA-00600 [17147] instance crash.(0)
• 13c agent oracle.sysman.gcagent.task.TaskFutureImpl$WrappedTask:621(0)

2017 - 01

• 11G DataGuard  ORA-01111，ORA-01110 – Recover standby  rename to dbs/UNNAMEDxxxxx(0)

2016

2016 - 12

• Use Shell Script Sheck logfile(0)
• 11gR2 Silent install database software(0)

2016 - 11

• Use Python script to comply sqlldr’s tool auto(2)
• How use hython’s smtplib and email module ?(0)
• 11gR2 RAC+ADG+RAC Actual Operation(0)
• ORACLE 11gR2 occur ORA-27300 ORA-00603 ORA-27300 ORA-27504(0)
• 13cR2 Modify OMS HTTPS and HTTP Console And Upload Ports After 13c Cloud Control Installation(0)
• ORACLE 12C Create PDB’s Techniques.(0)
• ORACLE 11gR2 FUNCTION index Wrong Use(0)
• ORACLE 12cR1 Common and Local users.(0)
• ORACLE 12C Release 1 Install Informations(0)

2016 - 10

• ORACLE 11Gr2 Interval Partitioning(0)
• ORACLE 11gR2 DBMS_ADVISOR.TUNE_MVIEW(0)
• Python Achieve Encryption and Decryption(0)
• Python Data Structures’s LIST(0)

2016 - 09

• Study python of day2(0)
• Study python of day1(0)

2016 - 08

• Use LOGMINER tool Explain the Fact for 11gR2(0)
• The detail of linux iostat command(0)
• ORA-38884: Cannot shrink data file xxx on standby database due to guaranteed restore points(0)

2016 - 07

• ORACLE 12C new critical background process is LREG(2)(0)
• ORACLE 12C new critical background process is LREG(0)
• 13C em Internal error detected: java.lang.Throwable:oracle.sysman.gcagent.task.scheduler.DispatchingTaskScheduler:1071(0)
• ORACLE EM 13cR1 deinstalling Standalone management agents(0)
• ORACLE 11gR2 DATAGURAD MRP0: Background Media Recovery terminated with error 1274(0)
• EM 13c: Enterprise Manager 13c Cloud Control Metric Collection Error – No valid queryDescriptor or executionDescriptor found for target(0)
• EM 13cR1: Database Target Status Shows “Dynamic Category property error” In 13c Cloud Control(0)
• EM 13cR1 oms and agent patch方式(0)
• ORA-700 [kskvmstatact: excessive swapping observed](0)

2016 - 06

• IMPDP ORA-4063 Package Body XDB.DBMS_XMLPARSER ORA-600(0)
• 11gR2上利用备份做DG(1)
• mysql指标统计脚本1(0)
• mysql 5.6 replication 2003 error(0)

2016 - 05

• 基于mongoimport自动化导入(0)
• mysql 5.6之innodb buffer pool命中率(0)
• 利用expect功能实现sftp自动连接下载(0)
• 2016年随笔(0)
• oracle数据库表操作异常监控半自动化(0)
• shell之半自动化归档历史数据(0)
• mysql 5.6下因操作两次drop table导致主从断开 1051 error(0)
• 利用shell,awk,实现对表里操作时间进行监控(1)
• ORA-20005: object statistics are locked (stattype = ALL)(0)
• MYSQL 5.6实际生产中参数调整参考(0)
• mysql 5.6 InnoDB: Error: table `mysql`.`innodb_table_stats` does not exist in the InnoDB internal(0)
• MONGO 日常操作(二)(0)
• ORACLE 11g DBMS_DATAPUMP使用(0)
• MYSQL 理论基础之常用日志参数说明(七)(0)
• MYSQL 理论基础之innodb逻辑部分(六)(0)
• MONGODB日常操作(一)(0)
• SHAREDPLEX 8.6 out of sync for queue xxx(0)

2016 - 04

• MYSQL导入数据之win中回车换行(0)
• Ora-39127: Unexpected Error from Call to Export_string :=Sys.Dbms_cube_exp(0)
• ORACLE 11gR2下ADG redo&standby log维护(0)
• 11gR2 DataGuard Standby backup archive ORA-17629 RMAN-06820(0)
• MYSQL 理论基础(五)(0)
• MYSQL 理论基础(四)(0)
• MYSQL 基础理论(三)(0)
• MYSQL 基础理论(二)(0)
• MYSQL 基础理论(一)(1)

2016 - 02

• 11gR2利用nosegment index影响执行计划(0)

2016 - 01

• ORACLE不完全恢复之current或active状态redo损坏(二)(0)
• ORACLE不完全恢复之数据文件及归档部分丢失(一)(0)
• ORACLE 11G常规恢复之数据文件头信息损坏(0)
• ORACLE 11g Incremental checkpoint(0)
• ORACLE常规恢复之应用数据文件丢失(0)
• ORACLE system文件损坏报错场景(0)
• ORACLE 11Gr2 control file还原恢复之redo完整但归档部分丢失(0)
• ORACLE 11Gr2 V$ARCHIVED_LOG视图过期信息(0)
• ORACLE 11gR2备库异常crash导致无法open(0)

2015

2015 - 12

• ORACLE 11Gr2 control file还原恢复之redo及其归档完整(0)
• ORACLE 11Gr2下redo里的轨迹之UPDATE(二)(0)
• Redo Dump ‘s OPCODE Reference(0)
• ORACLE 11Gr2下redo里的轨迹之UPDATE(一)(0)
• Oracle控制文件损坏报错场景(1)
• Oracle参数文件(spfile)恢复(0)
• ORACLE11Gr2 spfile及contorl文件备份(0)
• ORACLE获取dbid几种方式(0)
• ORACLE 11gr2利用nid修改DBID,DBNAME(0)
• MYSQL repliacation简介(0)

2015 - 11

• aix下topas说明(0)
• ORA-08103: object no longer exists(0)
• linux下vmstat命令(0)
• linux下针对cpu的名词概念(0)
• linux下/proc/cpuinfo说明(0)
• ORACLE 11G UTL_FILE_DIR简单测试(0)

2015 - 10

• Oracle truncate/delete比较(0)
• IO Wait Event Response Time(0)
• Database Link创建、删除(0)
• ORACLE 11Gr2 Transparent Data Encryption新功能(0)
• ORACLE 11g分区表创建unique index测试(0)
• oracle数据库服务器自启动（db\nmon\oswbb)(1)
• ORACLE 11G Process Architecture(一)(0)
• ORACLE 获取ddl(0)
• ORACLE redo block size及 avg write size计算方式(0)

2015 - 09

• SQL*Net message from client(0)
• ORACLE 11G shared server and dedicated server(1)
• ORACLE 11G flashback archive(0)
• ORACLE 11G flashback database操作(1)
• ORACLE 11G flashback table删除功能开关(1)
• ORA-12988: cannot drop column from table owned by SYS(0)
• ORACLE 11G online redefine to partition table(1)
• ORACLE 11g asmca创建卷组后无法自动mount(0)
• ORACLE 11G Flush Shared Pool’s Special Object(0)
• ORACLE 11G 利用copy做datafile恢复(0)
• ORACLE 11g EM 创建(0)
• 2015年秋随想(0)
• ORACLE 11G ORA-904 while running select query(BUG)(0)

2015 - 08

• Orace 11g startup and shutdown(0)

2015 - 07

• ORA-31655: no data or metadata objects selected for job(0)
• ORA-002998″cannot validate (%s.%s) – parent keys not found”(0)
• Oracle 11gR2 rman retention of REDUNDANCY or RECOVERY WINDOW(0)
• Oracle 11gR2 alter system几个常用操作(0)
• tnsnames.ora配置注意事项(1)
• Oracle Database interacting(0)
• ORACLE11gR2 DG备库增量恢复(0)
• ORA-00265: instance recovery required, cannot set ARCHIVELOG mode(0)
• latch:row cache objects(0)

2015 - 06

• ORACLE 11GR2 RMAN Duplicate Fails With RMAN-06136 ORA-19563(0)

2015 - 05

• ORACLE队列兼容表(0)
• SHAREPLEX: ORA-01400(0)
• _kks_use_mutex_pin不同版本效果(0)
• ORA-39700(0)
• ORACLE memory’s library cache(三)(2)

2015 - 04

• Oracle Dump information detail(0)
• ORACLE 11G memory’s SGA(二)(2)
• ORACLE11GR2 IMPDP With REMAP_SCHEMA Fails With Errors ORA-39002 ORA-39166(0)
• ORACLE db_nk_cache_size使用(0)
• ORACLE10GR2’s ORA-00018(0)
• splex多链路配置(0)
• ORACLE隐参查询(0)
• ORACLE 11g memory ‘s PGA(一)(0)
• ORACLE process/session/connect(0)
• ORACLE 12c之CDB与PDB(0)
• ORACLE disable/enable table lock天坑(1)
• ORACLE session KILLED,ACTIVE,INACTIVE(0)

2015 - 03

• Granule memory manager(0)
• rman参数configure backup optimization(1)
• ORACLE RAC下修改归档模式(0)
• ORACLE动静态监听(0)
• ORACLE11gR2 DG角色切换日志说明(physical standby)(0)
• ORACLE11gR2 DG角色切换(physical standby)(0)
• ORACLE11GR2切physical至snapshot standby(1)
• ORACLE11gR2基于rman duplicate建物理备库(0)
• ORACLE11G DATAGUARD parameter说明(0)
• ORACLE11gr2 ASM启动方式(0)
• ORACLE在线重定义更改表结构(0)
• oracle index monitor(1)
• socket文件.oracle被remove导致Crsd进程异常(1)

2015 - 02

• 利用UDEV SCSI Rules配置linux下的ASM(1)
• linux下无法获取uuid(0)
• 11G ORACLE几种较为重要name(0)
• C指针1(0)

2015 - 01

• C变量(1)
• C函数(0)
• sysaux因无法purge相关T表而缓慢膨胀(0)
• 密码保护：manually delete the expired/orphaned AWR data(0)
• oracle_11g_AWR1(0)
• C数组(0)
• C语言for循环使用(2)
• MYSQL命令之 show (global) status(0)
• C循环语句(0)
• redo log维护(2)
• 选择结构和条件判断(0)
• C语言数据输入输出(1)
• ORA-00959/ORA-25153(0)
• C变量和类型(2)
• oracle user password维护(0)
• Increase ASM Diskgroup(0)
• C语言初入(0)
• ORACLE表访操作(0)
• 加复合分区小知识点(0)

2014

2014 - 12

• flashback家族简介(0)
• oracle rowid说明(1)
• 10046事件跟踪方法(0)
• mysql命令1(1)
• 11G GI后台进程(0)
• ORA-28000″the account is locked” in the standby database, even after the account was unlocked in the primary(0)
• expdp时评估值与实际值(0)
• rhel基于sudo工具普通用户无需root密码可进入(0)
• ORA-27054(0)
• 更改网卡映射名(0)
• RAC心跳小知识(0)
• 优化脚本(0)
• 无法访问存储导致down实例(0)
• ORA-00600[kghstack_underflow_internal_3](0)
• ORA-00600 [504](0)
• ORA-31626/ORA-31638/ORA-39077/ORA-6502(0)
• log file sync等待事件(0)
• ORA-4031(0)
• ORA-08104: this index object xxxxx is being online built or rebuilt(0)
• 常见的文件丢失场景及恢复(1)
• index leaf/branch block说明(0)
• enq:TX-index contention等待事件(0)
• create index有无online的区别(1)
• DML锁检查(0)
• CSSD无法启动故障解析(0)
• ORA-00600 [1880](0)
• insert into一定会比insert into好吗？(0)