ORA-01110,ORA-01157錯誤處理

dataguard 備端由于數(shù)據(jù)文件沒分配相關(guān)權(quán)限造成的錯誤處理.
ORA-01111: name for data file 108 is unknown - rename to correct file
ORA-01110: data file 108: '/Oracle/product/9.2.0.5/dbs/UNNAMED00108'
ORA-01157: cannot identify/lock data file 108 - see DBWR trace file-
 

ORA-01111: name for data file 108 is unknown - rename to correct file
ORA-01110: data file 108: '/Oracle/product/9.2.0.5/dbs/UNNAMED00108'
-- 確認文件號與文件的關(guān)系.(核對主備系統(tǒng))
select file#,name from v$datafile;
file# name
主:
108 /dev/roradata105
備
108 /Oracle/product/9.2.0.5/dbs/UNNAMED00108

alter system set standby_file_management=manual;
alter database create datafile  '/Oracle/product/9.2.0.5/dbs/UNNAMED00108' as '/dev/roradata105';
alter system set standby_file_management=auto;
alter database recover managed standby database disconnect from session

服務(wù)器租用/服務(wù)器托管中國五強！虛擬主機域名注冊頂級提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]