Errors in file /u01/app/oracle/diag/rdbms/orcl151/orcl151/trace/orcl151_ora_3931.trc: ORA-10458: standby database requires recovery ORA-01157: cannot identify/lock data file 6 - see DBWR trace file ORA-01111: name for data file 6 is unknown - rename to correct file ORA-01110: data ...
ERROR at line 1: ORA-10458: standby database requires recovery ORA-01157: cannot identify/lock data file 7 - see DBWR trace file ORA-01111: name for data file 7 is unknown - rename to correct file ORA-01110: data file 7: '/oracle/app/oracle/product/12.2/db_1/dbs/UNNAMED00007' data...
STANDBY_FILE_MANAGEMENT 在启用自动备用文件管理后,将在备用数据库上复制主数据库上的操作系统文件添加和删除。此时,我们在主服务器上添加数据文件,而恢复过程(MRP)正在尝试应用存档,由于该参数设置,它将在$ ORACLE_HOME / dbs中创建一个未命名的文件将导致杀死MRP进程,错误如下所示。 当数据库由OMF管理时,修改路...
ORA-10458: standby database requires recovery ORA-01157: cannot identify/lock data file 1088 - see DBWR trace file ORA-01111: name for data file 1088 is unknown - rename to correct file ORA-01110: data file 1088: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED01088' ORA-10458 signall...
ORA-10458: standby database requires recovery ORA-01157: cannot identify/lock data file 24 - see DBWR trace file ORA-01111: name for data file 24 is unknown - rename to correct file ORA-01110: data file 24: '/data/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00024' ...
针对ORA-01111, ORA-01110, ORA-01157的处理 异常 在从库发现DG同步有延迟时执行recover失败,后台日志会报如下异常: 解决 根据源端地址和本地数据文件存放路径,整理语句如下: `alter system set STANDBY_FILE_MANAGEMENT='MANUAL' scope=both;` `alter database rename file '/data/app/oracle/product/11.2.0/...
How to resolve ORA-01111 ORA-01110 ORA-01157 in a physical standby database (文档 ID 1416554.1) 这里应该就可以猜测出原因基本就是由于主库建立一个文件,备库同步日志,没有创建正确。 MOS 解决方案核心内容: 代码语言:javascript 复制 SQL>ALTERDATABASERECOVERMANAGEDSTANDBYDATABASECANCEL;SQL>ALTERSYSTEMSETST...
cannot identify/lock data file 7 - see DBWR trace fileORA-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-10458 signalled during: ALTER DATABASE OPEN READ ONLY /* db agent *//* ...
ORA-10458: standby database requires recovery ORA-01157: cannot identify/lock data file7-see DBWR trace file ORA-01111: namefordata file7isunknown-renametocorrect file ORA-01110: data file7:'/u01/app/oracle/product/12.1.0/dbhome_1/dbs/UNNAMED00007'ORA-10458signalled during:ALTERDATABASEOPEN...
用rman恢复备库;遇到备库起不来一个案例 ORA-01152:ORA-01110 2015-10-22 18:52 −数据从主库恢复到备库;打开备库发现出现异常 SQL> alter database open; alter database open * ERROR at line 1: ORA-10458: standby database requires recovery ORA-01152... ...