standby_file_management為manual造成dataguard延遲

水逸冰發表於2019-06-05

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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章