linux oracle 01157,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;