故障现象：
物理DG因为主库新建数据文件同步到从库后从库磁盘空间不足，报如下错误
Mon Feb 4 08:56:48 2013
Errors in file /u01/app/oracle/admin/port/bdump/port_mrp0_12243.trc:
ORA-01111: name for data file 28 is unknown - rename to correct file
ORA-01110: data file 28: '/u01/app/oracle/db/dbs/UNNAMED00028'
ORA-01157: cannot identify/lock data file 28 - see DBWR trace file
ORA-01111: name for data file 28 is unknown - rename to correct file
ORA-01110: data file 28: '/u01/app/oracle/db/dbs/UNNAMED00028'
扩充磁盘空间后
执行alter database recover managed standby database disconnect from session;
再次报如上错误
处理：
alter database create datafile '/u01/app/oracle/db/dbs/UNNAMED00028' as '/oradata/datafile/in_adcphc_data.871.806486893';
执行alter database recover managed standby database disconnect from session;
回复正常的日志应用
Tue Feb 5 14:32:23 2013
alter database create datafile '/u01/app/oracle/db/dbs/UNNAMED00028' as '/oradata/datafile/in_adcphc_data.871.806486893'
Tue Feb 5 14:37:09 2013
Completed: alter database create datafile '/u01/app/oracle/db/dbs/UNNAMED00028' as '/oradata/datafile/in_adcphc_data.871.806486893'
Tue Feb 5 14:38:00 2013
Primary database is in MAXIMUM PERFORMANCE mode
RFS[3]: Successfully opened standby log 5: '/u01/datafile/standbyredo1_1.LOG'
Tue Feb 5 14:38:03 2013
Primary database is in MAXIMUM PERFORMANCE mode
RFS[5]: Successfully opened standby log 6: '/u01/datafile/standbyredo1_2.LOG'
Tue Feb 5 14:39:22 2013
alter database recover managed standby database disconnect from session
Tue Feb 5 14:39:22 2013
Attempt to start background Managed Standby Recovery process (port)
MRP0 started with pid=24, OS id=18443
Tue Feb 5 14:39:22 2013
MRP0: Background Managed Standby Recovery process started (port)
Managed Standby Recovery not using Real Time Apply
parallel recovery started with 15 processes
Tue Feb 5 14:39:28 2013
Waiting for all non-current ORLs to be archived...
Media Recovery Log /u01/archive/1_24184_697238176.dbf
Media Recovery Log /u01/archive/2_22949_697238176.dbf
本文转自zylhsy 51CTO博客，原文链接：http://blog.51cto.com/yunlongzheng/1132155，如需转载请自行联系原作者
