ITPub博客

title: Mysql 5.7 主从复制部署-Windowstags: Mysql 5.7 主从复制部署-Windowsgrammar_cjkRuby: truegrammar_cjkRuby: truegrammar_abbr: truegrammar_table: truegrammar_defList: truegrammar_emoji: truegrammar_footnote:

Centos 7.6 下Mysql8.0.16编译安装

dataguard ORA-17628 处理点击(此处)折叠或打开RMAN> duplicate target database for standby from active database dorecover nofilenamecheck;Starting Duplicate Db at 02-JUL-18using target database control file instead of recovery catalo...

打开库的时候报如下错误点击(此处)折叠或打开Errors in file /u01/app/oracle/diag/rdbms/mgkdb/mgkdb/trace/mgkdb_ora_3062.trc:ORA-10873: file 1 needs to be either taken out of backup mode or media recoveredORA-01110: data file 1: '/u01/app/oracle/or...

rac归档模式下文件建至本地存储修复方法（以下为测试，生产环境慎重操作）模拟误操作节点1添加数据文件点击(此处)折叠或打开SQL> alter tablespace netdata add datafile 'netdata03.dbf' size 20M;节点2查询点击(此处)折叠或打开SQL> select fi...

oracle rac中文名添加到本地路径解决办法(ORA-01157)故障模拟(生产环境勿测试)点击(此处)折叠或打开[grid@rac1-213-11 ~]# su - oracle[grid@rac1-213-11 ~]$ sqlplus / as sysdbaSQL>alter table netdata add datafile '测试DATA'在第二个节点...

2.重启库        45行SQL> startup nomount;ORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=data)(PORT=1521))'又出现此错误突然发现host里面的主机名...

rman duplicate出现以下错误点击(此处)折叠或打开RMAN> duplicate target database for standby from active database dorecover nofilenamecheck;Starting Duplicate Db at 30-JAN-18using channel ORA_AUX_DISK_1contents of Memo...

EXP-00106 导出数据提示查询发现此用户存在 dblink但是dblink无法查询由于此dblink不使用直接drop,重新导入此时可以导入了。

之前ctl文件定义点击(此处)折叠或打开LOAD DATACHARACTERSET ZHS16GBKINFILE 'wxls.csv'APPENDINTO TABLE temp_import20171201FIELDS TERMINATED BY ","TRAILING NULLCOLS(TEL,...

powershell 替换hosts文件

当我们进行手动resize的时候报如下错误点击(此处)折叠或打开SQL> alter database tempfile '/u01/app/oracle/oradata/orcl/temp01.dbf' resize 16G;alter database tempfile '/u01/app/oracle/oradata/orcl/temp01.dbf' resize 16G*ERROR at line ...

1.建议vim版本在7.3以上(py3env) [root@mysqltest-213-2 pytonstudy]# vim --versionVIM - Vi IMproved 7.4 (2013 Aug 10, compiled Dec 21 2016 17:10:41)Included patches: 1-207, 209-629Modified by Compiled by 下载https://github.com/VundleVim/Vundle.vim...

dataguard 由于主库参数未配置归档删除策略导致库归档丢失今天巡检库时候发现备库未启动，监控agent也被人关闭了，手动启动按照日志惯例打开备库(read_only)，但是在open的过程中显示以下错误Standby crash recovery failed to bring standby database to a consistentpoint because needed redo hasn't arrived yet....

mysql无备份恢复

一.安装undrop-for-innodb工具[root@mysqltest-213-2 tools]# unzip undrop-for-innodb-master.zip安装依赖包yum -y install gcc flex bisoncd undrop-for-innodb-mastermake[root@mysqltest-213-2 undrop-for-innodb-master]# makecc -D_FILE_OFFSET_BITS=64 -Wall -g -O3 -pipe  -I./include -c stream_...

plsql登录出现TNS-12541lsnrctl status一直无反映检查监听日志发现如下 TNS-12531: TNS:cannot allocate memory02-NOV-2017 14:16:46 * 12531TNS-12531: TNS:cannot allocate memory02-NOV-2017 14:16:46 * 12531TNS-12531: TNS:cannot&nb...

今天遇见客户报故障，数据库无法open,启动数据库的时候报一下错误，可以open但是过不了多久直接abortErrors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_3708.trc  (incident=54164):ORA-00600: internal error code, arguments: [4194], [55], [12], [], [], [], [], []ORA-00600: intern...

1.修改数据库服务端认证级别，修改文件oracle用户下cd $ORACLE_HOME/network/admin/sqlnet.ora添加以下内容SQLNET.ALLOWED_LOGON_VERSION=8注意rac集群环境下要修改的oracle用户下sqlnet.ora而非grid用户下2.修改用户名密码如果pdb需要切换到pdb下在服务器端操作cd cd $ORACLE_HOME/network/admin/[oracle@rac2 ...

今天打开一个win库的时候alert出现 ksuapc : ORA-1033 foreground process starts before PMON 主要 是因为数据库在打开中已经有应用连接上了User processes may get ORA-1033 errors when an application is connecting to an instance which is just coming ...