standby_file_management为manual造成dataguard延迟

dataguard的standby_file_management参数设置为manual，主库加表空间数据文件导致dg端出现延迟。 alert日志中报错如下： 2019-06-05T09:10:26.028762+08:00 Errors in file /u01/app/oracle/diag/rdbms/ssdapdg01/ssda/trace/ssda_pr00_5363.trc: ORA-01111: name for data file 22 is unknown - rename to correct file ORA-01110: data file 22: '/u01/app/oracle/products/12.2.0.1/db_1/dbs/UNNAMED00022' ORA-01157: cannot identify/lock data file 22 - see DBWR trace file ORA-01111: name for data file 22 is unknown - rename to correct file ORA-01110: data file 22: '/u01/app/oracle/products/12.2.0.1/db_1/dbs/UNNAMED00022' 恢复方法： 路径是备库路径，数据文件名称是主库添加的文件名称。 SQL> alter database create datafile 22 as '/san/data/oradata/ssda/868ea14fe681de67e053b12c11ac5721/datafile/vdata.289.1010128115' size 1G; Database altered. 然后将standby_file_management更改为auto SQL> alter system set standby_file_management='auto' scope=both; System altered. 开启应用即可。 SQL> alter database recover managed standby database using current logfile disconnect from session; Database altered. 还可以尝试的命令： alter database create datafile '/u01/app/oracle/products/12.2.0.1/db_1/dbs/UNNAMED00022' as '/san/data/oradata/ssda/868ea14fe681de67e053b12c11ac5721/datafile/vdata.289.1010128115';