ORA-01111: name for data file 81 is unknown - rename to correct file ORA-01110: ORA-01157:

一.问题简述

Oracle Dataguard 备库日志不应用

SQL>  select PROCESS,PID, STATUS ,CLIENT_PROCESS  from v$managed_standby;
PROCESS          PID STATUS       CLIENT_P
--------- ---------- ------------ --------
ARCH           14981 CONNECTED    ARCH
ARCH           14983 CONNECTED    ARCH
ARCH           14985 CONNECTED    ARCH
ARCH           14987 CONNECTED    ARCH
SQL> 

重启应用进程无作用，查看alert日志发现如下报错：

Mon Jul 04 16:39:40 2016
Managed Standby Recovery not using Real Time Apply
MRP0: Background Media Recovery terminated with error 1111
Errors in file /u01/CCBPROD/oracle/diag/rdbms/prods/PROD/trace/PROD_pr00_15008.trc:
ORA-01111: name for data file 81 is unknown - rename to correct file
ORA-01110: data file 81: '/u01/CCBPROD/oracle/product/11.2.0.4/dbs/UNNAMED00081'
ORA-01157: cannot identify/lock data file 81 - see DBWR trace file
ORA-01111: name for data file 81 is unknown - rename to correct file
ORA-01110: data file 81: '/u01/CCBPROD/oracle/product/11.2.0.4/dbs/UNNAMED00081'
Completed: alter database recover managed standby database disconnect from session
Recovery Slave PR00 previously exited with exception 1111
MRP0: Background Media Recovery process shutdown (PROD)
Mon Jul 04 16:39:55 2016

二.问题分析：

参考MOS:

Background Media Recovery terminated with ORA-1274 after adding a Datafile (文档 ID 739618.1)

三.问题解决：

SQL> alter system set standby_file_management=manual;

System altered.

SQL>

SQL>  alter database create datafile '/u01/CCBPROD/oracle/product/11.2.0.4/dbs/UNNAMED00081' as  '/u01/CCBPROD/oracle/product/11.2.0.4/dbs/system.361.915378213';
 alter database create datafile '/u01/CCBPROD/oracle/product/11.2.0.4/dbs/UNNAMED00081' as  '/u01/CCBPROD/oracle/product/11.2.0.4/dbs/system.361.915378213'
*
ERROR at line 1:
ORA-19502: write error on file
"/u01/CCBPROD/oracle/product/11.2.0.4/dbs/system.361.915378213", block number
51456 (block size=8192)
ORA-27072: File I/O error
Additional information: 4
Additional information: 51456
Additional information: 602112
SQL>

（这个问题其实很二，开始时主库dest_2状态为error，可能是因为备库重启了，导致归档大量传到备库，空间满了，悲剧！）

.......折腾空间......

SQL>  alter database create datafile '/u01/CCBPROD/oracle/product/11.2.0.4/dbs/UNNAMED00081' as  '/u01/CCBPROD/oracle/product/11.2.0.4/dbs/system.361.915378213';

Database altered.

SQL> 

SQL>  alter system set standby_file_management=auto;  

alterdatabaserecover managed standby databasedisconnectfromsession using currentlogfile; 

没起来.....

alter database recover managed standby database disconnect from session;


又没起来....

shutdown immediate




SQL> startup nomount;
SQL> alter database mount  standby database;
alter database recover managed standby database disconnect from session;

在检查进程：

SQL>  select PROCESS,STATUS, THREAD#,SEQUENCE# from v$managed_standby;

PROCESS   STATUS          THREAD#  SEQUENCE#
--------- ------------ ---------- ----------
ARCH      CONNECTED             0          0
ARCH      CONNECTED             0          0
ARCH      CONNECTED             0          0
ARCH      CONNECTED             0          0
MRP0      APPLYING_LOG          2      15870


治好了...........