centos7 systemctl 管理MySQL
摘要:[root@ze11 ~]# ll /usr/local/mysqllrwxrwxrwx. 1 mysql mysql 35 Dec 22 21:52 /usr/local/mysql -> mysql-5.7.25-linux-glibc2.12-x86_64[root@ze11 ~]# ps -
阅读全文
posted @
2020-12-22 22:42
HelonTian
阅读(472)
推荐(0) 编辑
【PgSQL备份恢复】之pg_dump
摘要:Postgresql中schema下的表的迁移 一、pg_dump日常迁移数据 导出表pg_dump -h /gpdb/gp_base/gpbase/ -d zedb -t ods_marketingdb.marketingmap_apply >marketingmap_apply.sql只导出表结
阅读全文
posted @
2020-12-17 21:46
HelonTian
阅读(348)
推荐(0) 编辑
Oracle11.2.0.4_Linux7静默安装
摘要:db_install.rsp oracle.install.option=INSTALL_DB_SWONLY ORACLE_HOSTNAME="ze_db01" UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/u01/app/oracle/oraInvent
阅读全文
posted @
2020-12-16 22:46
HelonTian
阅读(195)
推荐(1) 编辑
问题处理 :ORA-01157 ORA-01110
摘要:Oracle DG库报错 SQL> select * from w.v_result_detail;select * from w.v_result_detail *ERROR at line 1:ORA-01157: cannot identify/lock data file 201 - see
阅读全文
posted @
2020-12-05 23:31
HelonTian
阅读(720)
推荐(0) 编辑
【PgSQL插件】性能分析pgbadger日志分析工具
摘要:针对一个pg_log的分析 pgbadger -q postgresql-2.csv -o postgresql-20201202.html -f csv 根据故障时段的分析: pgbadger -q postgresql-4.csv -b "2022-01-27 07:50:00" -e "202
阅读全文
posted @
2020-12-03 16:03
HelonTian
阅读(126)
推荐(0) 编辑