oracle数据库ORA-01152-01110错误的解决办法
更新时间:2024-01-29 06:04:01 阅读量: 教育文库 文档下载
ORA-01152错误解决方法 用老的备份controlfile 2010-01-26 14:10 SQL> startup;
ORA-32004: obsolete and/or deprecated parameter(s) specified ORACLE instance started.
Total System Global Area 293601280 bytes Fixed Size 1248600 bytes Variable Size 96469672 bytes
Database Buffers 188743680 bytes Redo Buffers 7139328 bytes Database mounted.
ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1:
'L:\\ORACLE\\PRODUCT\\10.2.0\\ORADATA\\ORC2\\SYSTEM01.DBF'
SQL> select checkpoint_change# from v$database; CHECKPOINT_CHANGE# ------------------ 4532411
SQL> select checkpoint_change# from v$datafile; CHECKPOINT_CHANGE# ------------------ 4532411 4532411 4532411 4532411 4532411 4532411 4532411 4532411 4664735
9 rows selected.
SQL> select checkpoint_change# from v$datafile_header; CHECKPOINT_CHANGE# ------------------ 4711164 4711164 4711164 4711164 4711164 4711164 4711164 4711164 4664735
9 rows selected.
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 4697108 generated at 12/24/2007 11:48:57 needed for thread 1
ORA-00289: suggestion :
L:\\ORACLE\\PRODUCT\\10.2.0\\ORADATA\\ORC2\\ARCHIVEARC00007_0641832494.001 ORA-00280: change 4697108 for thread 1 is in sequence #7
Specify log: {
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:
'L:\\ORACLE\\PRODUCT\\10.2.0\\ORADATA\\ORC2\\SYSTEM01.DBF'
ORA-01112: media recovery not started
SQL> alter database open resetlogs; alter database open resetlogs *
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1:
'L:\\ORACLE\\PRODUCT\\10.2.0\\ORADATA\\ORC2\\SYSTEM01.DBF'
SQL> alter system set \System altered.
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 4697108 generated at 12/24/2007 11:48:57 needed for thread 1
ORA-00289: suggestion :
L:\\ORACLE\\PRODUCT\\10.2.0\\ORADATA\\ORC2\\ARCHIVEARC00007_0641832494.001 ORA-00280: change 4697108 for thread 1 is in sequence #7
Specify log: {
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:
'L:\\ORACLE\\PRODUCT\\10.2.0\\ORADATA\\ORC2\\SYSTEM01.DBF'
ORA-01112: media recovery not started
SQL> alter database open resetlogs; alter database open resetlogs *
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> startup force;
ORA-32004: obsolete and/or deprecated parameter(s) specified ORACLE instance started.
Total System Global Area 293601280 bytes Fixed Size 1248600 bytes Variable Size 96469672 bytes
Database Buffers 188743680 bytes Redo Buffers 7139328 bytes Database mounted. Database opened.
SQL> select checkpoint_change# from v$database; CHECKPOINT_CHANGE# ------------------ 4717118
SQL> select checkpoint_change# from v$datafile; CHECKPOINT_CHANGE# ------------------ 4717118 4717118 4717118 4717118 4717118 4717118 4717118 4717118 4664735
9 rows selected.
SQL> select checkpoint_change# from v$datafile_header; CHECKPOINT_CHANGE# ------------------ 4717118 4717118 4717118 4717118 4717118 4717118 4717118 4717118 0
9 rows selected.
SQL> select last_change# from v$datafile; LAST_CHANGE#
------------ 4664735
9 rows selected.
具体步骤如下: startup force;
alter system set \recover database using backup controlfile until cancel; alter databse open resetlogs;
正在阅读:
oracle数据库ORA-01152-01110错误的解决办法01-29
文献检索报告 田森 0812401605-21
2012年全国各地中考数学解析汇编第二十六章二次函数的应用01-29
应用统计学实习报告 - 图文11-18
郑州壹捷路畅科技路畅畅新RAV4特导航特点、技术参数及安装后效果欣赏 - 图文12-26
会 议 纪 要(技术交底)06-08
城市化进程中小城镇建设发展探讨05-12
会计实操经验SPAC方式上市成功案例03-17
- exercise2
- 铅锌矿详查地质设计 - 图文
- 厨余垃圾、餐厨垃圾堆肥系统设计方案
- 陈明珠开题报告
- 化工原理精选例题
- 政府形象宣传册营销案例
- 小学一至三年级语文阅读专项练习题
- 2014.民诉 期末考试 复习题
- 巅峰智业 - 做好顶层设计对建设城市的重要意义
- (三起)冀教版三年级英语上册Unit4 Lesson24练习题及答案
- 2017年实心轮胎现状及发展趋势分析(目录)
- 基于GIS的农用地定级技术研究定稿
- 2017-2022年中国医疗保健市场调查与市场前景预测报告(目录) - 图文
- 作业
- OFDM技术仿真(MATLAB代码) - 图文
- Android工程师笔试题及答案
- 生命密码联合密码
- 空间地上权若干法律问题探究
- 江苏学业水平测试《机械基础》模拟试题
- 选课走班实施方案
- 错误
- 办法
- 数据库
- 解决
- oracle
- 01152
- 01110
- ORA
- 2013年山东省公务员考试《行测》模拟试卷二
- 首届“魅力社工”情景剧大赛策划书 - 图文
- 川农17春秋《市场营销学(本科)》17年3月作业考核
- 人物访谈
- 广州市番禺区英东体育馆赛后运营管理分析 - 图文
- 基于人工神经网络的预测研究
- 微生物学考研复习资料
- 简历模板20个(学生版)
- 地理信息系统原理与方法结课论文
- 《平行与垂直》专题练习(含答案)
- 瓦屋面工程检验批质量验收记录表
- 房地产销售人员培训资料
- triz初级班试卷答案
- 色谱思考练习
- 浙江省导游基础第一章至第四章练习题
- 教师职业道德案例分析题及答案
- 销售本月工作总结及下月工作计划
- 2014北京高考物理真题word版
- 江苏省2018届高考语文专项复习古代诗歌鉴赏(课外)练习(11)
- 毕业设计 - 图文