Chinaunix首页 | 论坛 | 博客
  • 博客访问: 54619
  • 博文数量: 10
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 197
  • 用 户 组: 普通用户
  • 注册时间: 2013-03-05 13:38
个人简介

事在人为

文章分类

全部博文(10)

文章存档

2014年(2)

2013年(8)

我的朋友

分类: Oracle

2014-06-05 16:31:49

错误内容:DG失效
SQL> recover managed standby database;
ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 77 is unknown - rename to correct file
ORA-01110: data file 77: '/oracle/product/9.2.0/dbs/UNNAMED00077'
ORA-01157: cannot identify/lock data file 77 - see DBWR trace file
ORA-01111: name for data file 77 is unknown - rename to correct file
ORA-01110: data file 77: '/oracle/product/9.2.0/dbs/UNNAMED00077'

解决
1)    alter system set standby_file_management=MANUAL
2)    alter database create datafile '/u01/app/oracle/product/11.2.0.3/dbhome_1/dbs/UNNAMED00006' as ' /data/testdb/datafile/ ts_pub01.dbf';
3)    alter system set standby_file_management=AUTO

recover managed standby database;
查看ALERT是否同步成功了


阅读(1547) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~