摘要:
下载安装包 wget https://www.openssl.org/source/openssl-1.1.1k.tar.gzwget http://www.zlib.net/zlib-1.2.11.tar.gzwget ftp://ftp.pcre.org/pub/pcre/pcre-8.45.t 阅读全文
摘要:
查看归档警告 select * from V$RMAN_OUTPUT where lower(output) like '%warning%'; 有双节点集群同步到单机DG,看到rac备份上有警告 RMAN-08120: WARNING: archived log not deleted, not 阅读全文
摘要:
[grid@rac01 ~]$ crsctl check crsCRS-4638: Oracle High Availability Services is onlineCRS-4535: Cannot communicate with Cluster Ready ServicesCRS-4530: 阅读全文
摘要:
ASMCMD> commands: md_backup, md_restore lsattr, setattr cd, cp, du, find, help, ls, lsct, lsdg, lsof, mkalias mkdir, pwd, rm, rmalias chdg, chkdg, dro 阅读全文
摘要:
expdp时出现如下 报错, Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_BODYORA-39127: unexpected error from call to BEGIN :1 := SYS.DBMS_JAVA.START_EX 阅读全文
摘要:
SQL> startupORACLE instance started. Total System Global Area 6263357440 bytesFixed Size 2264856 bytesVariable Size 1241514216 bytesDatabase Buffers 4 阅读全文
摘要:
一个1T的RAC数据库恢复到单机上,在恢复数据时出现如下报错: RMAN> recover database; Starting recover at 2021-01-21 05:18:12using channel ORA_DISK_1using channel ORA_DISK_2 starti 阅读全文
摘要:
#!/bin/bash #######expr 方法是错误的,在比较相同位数时可以,当位数不同就会出错,如100.00>70.00就会得出错误的结果 a=123b=123c=99.99rat=`awk 'BEGIN{printf "%.2f\n",('${a}'/'${b}')*100}'`echo 阅读全文
摘要:
增加栏位: pt-online-schema-change --user=root --password=a099e0 --alter "ADD COLUMN IS_MOBILE INT(1)" --socket=/data/db/mysql3398/mysql3398.sock D='fay',t 阅读全文
摘要:
今天新安装一台CentOS,进行yum安装时出现以下问题提示 perl-5.16.3-294.el7_6.x86_64.r FAILED http://mirror.vodien.com/centos/7.6.1810/updates/x86_64/Packages/perl-5.16.3-294. 阅读全文