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;

 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/15187685/viewspace-756610/，如需轉載，請註明出處，否則將追究法律責任。