ORA-1547一例处理
来源:互联网 发布:数据库数据一致性问题 编辑:程序博客网 时间:2024/05/14 10:47
转自 http://blog.itpub.net/16983605/viewspace-1145149/
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u01/uat5/db/apps_st/data/system01.dbf'
released channel: c1
released channel: c2
released channel: c3
RMAN-00571: ==============================================
RMAN-00569: ========= ERROR MESSAGE STACK FOLLOWS ==========
RMAN-00571: =================================================
RMAN-03002: failure of Duplicate Db command at 04/19/2014 09:44:51
RMAN-03015: error occurred in stored script Memory Script
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 1 with sequence 1047 and starting SCN of 612091514 found to restore
2014/04/19
从PROD克隆到UAT5
在PROD上做了全备份(script full_bak)
将FRA拷贝至UAT5后做恢复DB
数据文件还原后出现上述错误
第一次未使用 until scn子句
第二次采用 until scn 612213707+1,错误也一样
参考别人的意见,ORA-1547需要做不完全恢复
而此例稍有不同,
从提示信息来看,应该是少了归档文档,因为提示信息很清楚
从备份顺序来看,先备份的数据文件,接着备份归档文件,再执行的
控制文件备份,
这样当最后备份控制文件时,数据文文件很可能已经更新了,并生成了新的日志
在RMA中使用list backup;可以看到归档文件只备份到了1046
所在在将1047拷贝到UAT5相同路径下,再次执行备份时即成功。
- ORA-1547一例处理
- ORA-01578: 处理一例。
- ora-00201,ora-00202错误处理一例
- ORA-00054 故障处理一例
- ORA-30009 故障处理一例
- ora.LISTENER.lsnr INTERMEDIATE 处理一例
- ORA-28547 故障处理一例
- ORA-12537错误处理一例
- ORA-27102:out of memeory 故障处理一例
- Drop user cascade failed ORA-00604 ORA-02429 处理一例
- ORA-15041,ORA-01274 故障一例
- 远程通过监听连接报ORA-01034故障处理一例
- create temp table as from occur ora-600 处理一例
- Poster: ORA-01458: invalid length inside variable character string. 处理一例
- 处理因sqlnet.ora引起的ASM资源为UNKNOWN一例
- ORA-01994 故障一例
- ORA-12571 错误一例.
- ORA-00600错误一例
- 定时调度Quartz框架学习小demo
- effective c++要点
- google搜索不稳定
- sgu 103(poj 1158) 最短路(含蓝紫灯的最短路)
- 自己总结的排序算法未完成
- ORA-1547一例处理
- 各种图像处理类库的比较及选择(The Comparison of Image Processing Libraries)
- Ubuntu建立PHP服务器(apache+php+mysql)
- [leetcode] Evaluate Reverse Polish Notation
- org.apache.shiro.web.servlet.ShiroHttpServletRequest cannot be cast to org.springframwork.web.mult..
- uva 11774 - Doom's Day(规律)
- configure: error: Cannot find ijs-config; please ensure Ghostscript 6.53 or above is installed
- 批处理-输入输出
- 拦截QT关闭窗口的CloseEvent