-
编辑 删除
dataguard ORA-17628 处理
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...
-
编辑 删除
ORA-10873 故障解决
打开库的时候报如下错误点击(此处)折叠或打开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归档模式/非归档模式下文件建至本地存储修复方法-ORA-01157
rac归档模式下文件建至本地存储修复方法（以下为测试，生产环境慎重操作）模拟误操作节点1添加数据文件点击(此处)折叠或打开SQL> alter tablespace netdata add datafile 'netdata03.dbf' size 20M;节点2查询点击(此处)折叠或打开SQL> select fi...
-
编辑 删除
rac中文名文件名添加到本地路径解决办法(ORA-01157)-非归档
oracle rac中文名添加到本地路径解决办法(ORA-01157)故障模拟(生产环境勿测试)点击(此处)折叠或打开[grid@rac1-213-11 ~]# su - oracle[grid@rac1-213-11 ~]$ sqlplus / as sysdbaSQL>alter table netdata add datafile '测试DATA'在第二个节点...
-
编辑 删除
ORA-00130 引发的故障
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出现PLS-00201错误解决
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...
