上周五去客户处巡检时,发现原来配置的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 ----