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/