ORA-01111: name for data file 6 is unknown - rename to correct file ORA-01110: data file 6: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00006' ORA-01157: cannot identify/lock data file 6 - see DBWR trace file ORA-01111: name for data file 6 is unknown - rename to correct ...
参考: How to resolve ORA-01111 ORA-01110 ORA-01157 in a physical standby database (文档 ID 1416554.1) http://yunlongzheng.blog.51cto.com/blog/788996/1091944
STANDBY_FILE_MANAGEMENT 在启用自动备用文件管理后,将在备用数据库上复制主数据库上的操作系统文件添加和删除。此时,我们在主服务器上添加数据文件,而恢复过程(MRP)正在尝试应用存档,由于该参数设置,它将在$ ORACLE_HOME / dbs中创建一个未命名的文件将导致杀死MRP进程,错误如下所示。 当数据库由OMF管理时,修改路...
此时需要注意,o1_mf_gpapp_h4dnw6m6_.dbf,这种命名数据文件的方式很奇怪,一般这种方式多出现在ASM磁盘中,由数据库定义名称,此时我就想到了OMF,查看相关参数,确认此库为OMF管理方式管理数据文件。 此处验证证明了我的猜想,所以修改语句重新执行,修复了此问题。 `alter database create datafile '/data/app/oracle/...
ORA-01110: data file 19: '/home/oracle/product/10.2.0/db_1/dbs/UNNAMED00019' Wed Sep 5 11:10:08 2012 MRP0: Background Media Recovery process shutdown (zjport) 故障处理: ALTER SYSTEM SET standby_file_management='MANUAL' SCOPE=BOTH; ...
此时再观察standby,会发现刚才显示的错误一直在刷,并且standby的日志实时应用是无法打开的(抛出错误码:ORA-01186;ORA-01157;ORA-01111;ORA-01110) 修复过程: 1.先查看从库的控制文件位置,然后关闭从库并启动到mount状态 standby>show parameter control;
Oracle Database - Enterprise Edition - Version 7.3.2.2 to 11.2.0.3 [Release 7.3.2 to 11.2]: How to resolve ORA-01111 ORA-01110 ORA-01157 in a physical standby databa
1> 检查dataguard,sid已经正常启动,尝试启动MRP进程起不来,查看alert日志 (10g) 1 Errors in file /home/oracle/admin/oradb/bdump/zjport_mrp0_17798.trc: 2 ORA-01111: name for data file 19 is unknown - rename to correct file 3 ORA-01110: data file 19: '/home/oracle/product/10.2.0/db_1...
Errors in file /u01/app/oracle/diag/rdbms/orcldg/orcldg/trace/orcldg_ora_2067.trc:ORA-01111: name for data file 7 is unknown - rename to correct fileORA-01110: data file 7: '/u01/app/oracle/product/12.1.0/dbhome_1/dbs/UNNAMED00007'ORA-01157: cannot identify/lock data file 7 - ...
ORA-01110: data file 5: '/opt/oracle/product/10.2.0/dbs/UNNAMED00005' 出现这些错误时MRP进程会停止工作,恢复中断: Mon Jul 6 01:36:30 2009 MRP0: Background Media Recovery process shutdown (mmstest) 在修正相关的问题之后,我们可以进行如下一系列的操作来恢复这些错误: ...