oracle数据库ORA-01152-01110错误的解决办法
更新时间:2024-04-19 12:29: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错误的解决办法04-19
2018年四川省高等学校新入职教师返岗教研综合评价表06-25
小学生毛笔字书法教案02-26
在班主任工作中如何运用好现代教育技术02-29
各省军区独立师历史沿革04-25
学校财务工作计划2019年05-20
解除劳动合同-合同范本模板03-21
职业决策这一概念最早源自英国经济学家10-08
2010年劳动法考试题03-12
- Win7 安装MySql图示
- 计算器课程设计报告
- 部编版八年下语文第三单元第六单元古诗文理解默写练习及答案
- 13质量通病防治方案和施工措施
- 土力学试题~~~~
- 公务员打印资料
- 传热膜系数测定实验报告 - 图文
- 新时期煤矿协管安全工作的创新与实践
- 第五章 习题及参考答案
- 220kV架空线路强条执行记录表
- 音乐欣赏读后感
- 高炉
- 劳动教育需要新的时代内涵
- 10建筑地面工程施工质量验收规范GB50209-20021
- 银行会计练习题2答案
- 2013年七年级地理上册知识点复习提纲湘教版
- 人教版三年级语文上册第四单元测试题(A卷)(有答案)
- 营养师第九章练习题
- 湖北省武汉市2018届高三毕业生二月调研 理综化学
- 行业分析2018-2023年中国男性护肤品行业市场发展分析及投资前景
- 错误
- 办法
- 数据库
- 解决
- oracle
- 01152
- 01110
- ORA
- 高中历史岳麓版必修三第二单元练习题 - 图文
- 化工专业英语词汇剖析
- 江苏省2018届高考语文专项复习古代诗歌鉴赏(课外)练习(11)
- 美国雷诺兹-纳贝斯克(RJR Nabisco)公司收购案
- 大学化学热力学基础习题集答案
- 人物访谈
- 2010大红门东街“双争创”自查报告
- 乘加和乘减的教学设计MicrosoftWord文档
- 《平行与垂直》专题练习(含答案)
- 微生物学考研复习资料
- 瓦屋面工程检验批质量验收记录表
- LED芯片常用衬底材料
- 销售本月工作总结及下月工作计划
- 论安全生产管理在市政工程中的重要性(论文) - 图文
- 2009年名师精编详解中考英语综合题解(含易错题)
- 我国现行上网电价政策
- 2014北京高考物理真题word版
- ERP业务现状调研报告V2.0
- 计量经济学第七章第5,6,7题答案
- 公司股份合作协议书范本