备库 空间或权限问题 导致新建数据文件失败

场景一、主库新加数据文件路径并新增数据文件，未修改db_file_name_conver参数，导致备库新建数据文件失败

场景二、因监控不到位，备库空间不足导致新建数据文件失败

后台报错：

WARNING: File being created with same name as in Primary
Existing file may be overwritten
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_mrp0_3449.trc:
ORA-01119: error in creating database file '/oradata/test05.dbf'
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Linux-x86_64 Error: 13: Permission denied
File #11 added to control file as 'UNNAMED00011'.
Originally created as:
'/oradata/test05.dbf'
Recovery was unable to create the file as:
'/oradata/test05.dbf'
MRP0: Background Media Recovery terminated with error 1274
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_mrp0_3449.trc:
ORA-01274: cannot add datafile '/oradata/test05.dbf' - file could not be created
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Recovered data files to a consistent state at change 1265632
MRP0: Background Media Recovery process shutdown (orcl)

MRP进程自动关闭

修改db_file_name_conver参数及目录权限后，重启备库并尝试开启MRP进程，报错如下

alter database recover managed standby database using current logfile disconnect from session
Attempt to start background Managed Standby Recovery process (orcl)
Sat Jan 05 04:58:34 2019
MRP0 started with pid=26, OS id=3529
MRP0: Background Managed Standby Recovery process started (orcl)
Sat Jan 05 04:58:39 2019
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_dbw0_3392.trc:
ORA-01186: file 11 failed verification tests
ORA-01157: cannot identify/lock data file 11 - see DBWR trace file
ORA-01111: name for data file 11 is unknown - rename to correct file
ORA-01110: data file 11: '/u01/app/oracle/product/11.2.0.4/db_1/dbs/UNNAMED00011'
File 11 not verified due to error ORA-01157
MRP0: Background Media Recovery terminated with error 1111
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_mrp0_3529.trc:
ORA-01111: name for data file 11 is unknown - rename to correct file
ORA-01110: data file 11: '/u01/app/oracle/product/11.2.0.4/db_1/dbs/UNNAMED00011'
ORA-01157: cannot identify/lock data file 11 - see DBWR trace file
ORA-01111: name for data file 11 is unknown - rename to correct file
ORA-01110: data file 11: '/u01/app/oracle/product/11.2.0.4/db_1/dbs/UNNAMED00011'
Managed Standby Recovery not using Real Time Apply
MRP0: Background Media Recovery process shutdown (orcl)
Completed: alter database recover managed standby database using current logfile disconnect from session

此处的/u01/app/oracle/product/11.2.0.4/db_1/dbs/UNNAMED00011在操作系统中并不存在，关于此数据文件的信息只是记录在控制文件中

处理过程：

修改standby_file_management为manual

alter system set standby_file_management = manual;

在备库重建数据文件

alter database create datafile '/u01/app/oracle/product/11.2.0.4/db_1/dbs/UNNAMED00011' as '/oradata/test05.dbf';

将standby_file_management改回auto

alter system set standby_file_management = auto;

启动MRP进程并验证实时同步