ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-01110,ORA-01157错误处理

ORA-01110,ORA-01157错误处理

原创 Linux操作系统 作者:hb0860 时间:2011-04-25 18:06:29 0 删除 编辑
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/38006/viewspace-693693/,如需转载,请注明出处,否则将追究法律责任。

上一篇: MOVE LOB COLUMN
下一篇: rman过期日志清理
请登录后发表评论 登录
全部评论

注册时间:2009-11-20

  • 博文量
    31
  • 访问量
    58239