oracle standby 数据库应用日志报错ORA-01111 ORA-01110 ORA-01157

最新推荐文章于 2026-03-14 01:50:07 发布

原创

最新推荐文章于 2026-03-14 01:50:07 发布 · 609 阅读

收录于

当前文章被以下社区和专栏收录：

本文详细记录了一次Oracle备库因磁盘空间不足导致同步失败的问题及解决过程。通过手动管理文件、创建数据文件、调整系统参数和恢复操作，最终成功解决了同步问题。

oracle standby 数据库应用日志报错ORA-01111 ORA-01110 ORA-01157

因为备库磁盘空间不够，在主库新增了表空间，之后导致备库同步失败，之后对备库进行了扩容，扩容后启动同步报发下错误：

MRP0: Background Media Recovery terminated with error 1111
Errors in file /opt/u01/app/oracle/diag/rdbms/ydjydg/ydjydg1/trace/ydjydg1_pr00_3708.trc:
ORA-01111: name for data file 421 is unknown - rename to correct file
ORA-01110: data file 421: '/opt/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00421'
ORA-01157: cannot identify/lock data file 421 - see DBWR trace file
ORA-01111: name for data file 421 is unknown - rename to correct file
ORA-01110: data file 421: '/opt/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00421'
Managed Standby Recovery not using Real Time Apply
Recovery Slave PR00 previously exited with exception 1111
MRP0: Background Media Recovery process shutdown (ydjydg1)

根据查找mos分析，处理步骤如下：创建一个空的数据文件，其结构与数据文件421相同，并且从创建时起需要所有存档日志进行恢复。

SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=MANUAL SID='*';

System altered.

SQL>  
SQL> 
SQL> Alter database create datafile '/opt/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00421' as '+data' size 32700M;

Database altered.

SQL> ALTER SYSTEM SET STANDBY_FILE_MA