这篇博客记录了一次Oracle数据库备库由于磁盘空间不足引发的ORA-15041和ORA-01274错误，导致归档日志同步中断的问题。在主库尝试添加数据文件时，备库无法创建导致MRP0进程终止，分析了备库落后归档日志的数量，并提出了恢复备库同步的解决方案。
上周五去客户处巡检时，发现原来配置的DG备库未与主库同步，特此记录一下
在5月14日13：58出现故障，3398日志无法应用，以下是alert日志
Thu May 14 13:58:01 2015
Errors in file /u01/app/oracle/diag/rdbms/tcdg/tc/trace/
tc_pr00_3473760.trc:
ORA-01119: error in creating database file '+data'
ORA-17502: ksfdcre:4 Failed to create file +data
ORA-15041: diskgroup "DATA" space exhausted
File #108 added to control file as 'UNNAMED00108'.
Originally created as:
'+DATA/tc/datafile/oa2015.387.879688649'
Recovery was unable to create the file as:
'+data'
MRP0: Background Media Recovery terminated with error 1274
Errors in file /u01/app/oracle/diag/rdbms/tcdg/tc/trace/
tc_pr00_3473760.trc:
ORA-01274: cannot add datafile '+DATA/tc/datafile/oa2015.387.879688649' - file could not be created
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Recovered data files to a consistent state at change 10293976250522
Thu May 14 13:58:06 2015
MRP0: Background Media Recovery process shutdown (tc)
由于空间不足，出现了ORA-15041错误，然后MRP0进程被终止
再来看trace文件内容：
*** 2015-05-14 13:58:01.562
----- START Event Driven Actions Dump ----
最低0.47元/天 解锁文章
扫一扫
1524
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
