ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/u01/app
来源:互联网 发布:贪心算法 动态规划 编辑:程序博客网 时间:2024/06/03 07:57
在rman中执行备份恢复,我们从restore database之后一步步探索,我接着执行了如下语句:
RMAN> alter database open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 04/22/2012 20:28:21
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
当然我们会按照提示接着执行:
RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 04/22/2012 20:28:35
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl/system01.dbf'
伤心的是又会报如上的错误。解决方法:在执行完restore database之后我们要做的是:
RMAN>recover database;
RMAN> alter database open resetlogs;这样就恢复数据库完毕了,当然resetlogs后不要忘记重新做一次数据库备份。
因为restore 还原,是将文件从备份集还原到相应位置,
recover 恢复,将还原的文件同步。
所以仅仅执行restore时会报错数据文件没有完全从旧的备份中进行还原。
以上个人总结如果有误或者不足,希望大家指出
- ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/u01/app
- ORA-01152 file 1 was not restored from a sufficiently old backup解决过程
- ORA-01152 file 1 was not restored from a sufficiently old backup解决过程
- ORA-01152 file 1 was not restored from a sufficiently old backup解决过程
- linux oracle ORA-01221: data file 1 is not the same file to a background process
- could not open parameter file '/u01/app/oracle/product/11.1.0/db_1/dbs/initorc11g.ora
- ORA-01110: data file
- ORA-01187: cannot read from file because it failed verification tests ORA-01110: data file 201: '/
- LRM-00109: could not open parameter file '/u01/app/oracle/product/12.1.0/db_1/dbs/initepps.ora'
- ORA-19502 write error on file '/u01/'
- ORA-01110: data file 56
- ORA-00214: controlfile '/u01/app/oracle/oradata/[sid]/control01.ctl' version inconsistent with file
- 天灾还是人祸:ORA-01565: error in identifying file '/u01/app/oracle/oradata/eftp/testNS.dbf'
- LRM-00109: could not open parameter file '/u01/oracle/product/10.2.0/db_1/dbs/initCRM.ora'
- ORA-01207 old control file完全解决方案
- ORA-01207 old control file完全解决方案
- ORA-01207 old control file完全解决方案
- ORA-00245: control file backup operation failed
- 微博文摘——女人与ITIL
- 我的C/C++之路-005课(模拟路由表的路由选择功能)
- 辨析这几个概念:dBi,dBd,dBc,dBm,dB
- Linux内核设计与实现——7 中断与中断处理(5)——注册中断处理程序
- 高手讲解php调用url的N种方法
- ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/u01/app
- Oracle分析函数八——CUBE,ROLLUP
- springMVC web请求处理流程
- Objective-C 编程语言(6)类别与扩展----为类增加方法
- ubuntu 桌面 终端 控制台 Bash Shell 命令行编辑 快捷键
- git服务器的搭建
- 使用lucene3.6创建索引和实现简单搜索
- Flex Channel.Connect.Failed error NetConnection.Call.Failed: HTTP: Failed
- Java的序列化、反序列化