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'
-- 確認(rèn)文件號與文件的關(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 本文出自:億恩科技【mszdt.com】
服務(wù)器租用/服務(wù)器托管中國五強(qiáng)!虛擬主機(jī)域名注冊頂級提供商!15年品質(zhì)保障!--億恩科技[ENKJ.COM]
|