ORA-01110,ORA-01157錯誤處理

dataguard 備端由于數據文件沒分配相關權限造成的錯誤處理.
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'
-- 確認文件號與文件的關系.(核對主備系統)
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

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