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';

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31480688/viewspace-2646828/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31480688/viewspace-2646828/