Oracle DataGuard:ORA-01111: name for data file xxx is unknown – rename to correct file
在DG的使用过程中,可能会因为备库的空间不够的问题导致备库日志应用(MRP)失败。
这种情况下,备库的Alert日志可能会呈现如下的报错:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
Thu Jun 23 11:15:35 2016 Errors in file /oracle/ORCL/saptrace/diag/rdbms/standby1/ORCL/trace/ORCL_pr00_6684884.trc: ORA-19502: write error on file "/oracle/ORCL/mydata23/xer_288/xer.data288", block number 1476480 (block size=8192) ORA-27063: number of bytes read/written is incorrect IBM AIX RISC System/6000 Error: 28: No space left on device Additional information: -1 Additional information: 1048576 File #317 added to control file as 'UNNAMED00317'. Originally created as: '/oracle/ORCL/mydata23/xer_288/xer.data288' Recovery was unable to create the file as: '/oracle/ORCL/mydata23/xer_288/xer.data288' Errors with log /oracle/ORCL/oraarch/ORCLarch/standby1_1_801776_705619077.arch MRP0: Background Media Recovery terminated with error 1274 Errors in file /oracle/ORCL/saptrace/diag/rdbms/standby1/ORCL/trace/ORCL_pr00_6684884.trc: ORA-01274: cannot add datafile '/oracle/ORCL/mydata23/xer_288/xer.data288' - file could not be created Recovery interrupted! Recovery stopped due to failure in applying recovery marker (opcode 17.30). Datafiles are recovered to a consistent state at change 4564125927924 but controlfile could be ahead of datafiles. Thu Jun 23 11:15:38 2016 MRP0: Background Media Recovery process shutdown (ORCL) |
通过报错,你可以看到:
因为空间不足,DG备库跟着主库创建文件“/oracle/[……]