案例:数据库open时报错ORA-1172,ORA-1151 处理
来源:互联网 发布:用工作站玩游戏知乎 编辑:程序博客网 时间:2024/05/24 06:53
环境:OEL 5.7 + Oracle 10.2.0.5 Clusterware + Oracle 10.2.0.5 RAC
故障:数据库open时报错ORA-1172,ORA-1151
- 1.故障详细
- 2.原因定位
- 3.尝试修复
1.故障详细
几年前的10gRAC实验环境,整体冷备迁移到新环境时,无法正常启动数据库,手工尝试也无法正常启动,报错如下:
Mon Aug 14 10:04:13 EDT 2017ALTER DATABASE OPENThis instance was first to openBlock change tracking file is current.Mon Aug 14 10:04:14 EDT 2017Beginning crash recovery of 2 threadsMon Aug 14 10:04:14 EDT 2017Started redo scanMon Aug 14 10:04:14 EDT 2017Completed redo scan 337 redo blocks read, 85 data blocks need recoveryMon Aug 14 10:04:14 EDT 2017Started redo application at Thread 1: logseq 21, block 71672 Thread 2: logseq 17, block 33379Mon Aug 14 10:04:14 EDT 2017Recovery of Online Redo Log: Thread 1 Group 1 Seq 21 Reading mem 0 Mem# 0: +ZHAOJINGYU/jy/onlinelog/group_1.262.839673937 Mem# 1: +ZHAOJINGYU/jy/onlinelog/group_1.263.839673939Mon Aug 14 10:04:14 EDT 2017Recovery of Online Redo Log: Thread 2 Group 3 Seq 17 Reading mem 0 Mem# 0: +ZHAOJINGYU/jy/onlinelog/group_3.269.839674171 Mem# 1: +ZHAOJINGYU/jy/onlinelog/group_3.270.839674173RECOVERY OF THREAD 1 STUCK AT BLOCK 41 OF FILE 2Mon Aug 14 10:04:27 EDT 2017Abort recovery for domain 0Mon Aug 14 10:04:27 EDT 2017Aborting crash recovery due to error 1172Mon Aug 14 10:04:27 EDT 2017Errors in file /s01/oracle/admin/jy/udump/jy1_ora_18982.trc:ORA-01172: recovery of thread 1 stuck at block 41 of file 2ORA-01151: use media recovery to recover block, restore backup if neededORA-1172 signalled during: ALTER DATABASE OPEN...Mon Aug 14 10:04:30 EDT 2017Shutting down instance (abort)License high water mark = 1Instance terminated by USER, pid = 19144
2.原因定位
根据MOS文档 Error ORA-01219 , ORA-01172, ORA-01151, ORA-01033 (文档 ID 1605148.1)
结合自己这里的实际情况,怀疑是之前数据库没有正常关闭导致。
试图在mount下进行recover database操作。
startup mount recover database;ALTER DATABASE OPEN;
3.尝试修复
我这里实际解决过程如下:
3.1 查看状态发现数据库实例资源始终没有启动:
[oracle@rac1-server crsd]$ crs_stat -tName Type Target State Host ------------------------------------------------------------ora.jy.db application ONLINE OFFLINE ora....y1.inst application ONLINE OFFLINE ora....y2.inst application ONLINE OFFLINE ora....SM1.asm application ONLINE ONLINE rac1-server ora....ER.lsnr application ONLINE ONLINE rac1-server ora....ver.gsd application ONLINE ONLINE rac1-server ora....ver.ons application ONLINE ONLINE rac1-server ora....ver.vip application ONLINE ONLINE rac1-server ora....SM2.asm application ONLINE ONLINE rac2-server ora....ER.lsnr application ONLINE ONLINE rac2-server ora....ver.gsd application ONLINE ONLINE rac2-server ora....ver.ons application ONLINE ONLINE rac2-server ora....ver.vip application ONLINE ONLINE rac2-server
3.2 尝试手工启动数据库
[oracle@rac1-server crsd]$ srvctl start database -d jyPRKP-1001 : Error starting instance jy1 on node rac1-serverCRS-0215: Could not start resource 'ora.jy.jy1.inst'.PRKP-1001 : Error starting instance jy2 on node rac2-serverCRS-0215: Could not start resource 'ora.jy.jy2.inst'.
尝试手工启动数据库失败,再次查询状态:
[oracle@rac1-server crsd]$ crs_stat -tName Type Target State Host ------------------------------------------------------------ora.jy.db application ONLINE OFFLINE ora....y1.inst application ONLINE OFFLINE ora....y2.inst application ONLINE OFFLINE ora....SM1.asm application ONLINE ONLINE rac1-server ora....ER.lsnr application ONLINE ONLINE rac1-server ora....ver.gsd application ONLINE ONLINE rac1-server ora....ver.ons application ONLINE ONLINE rac1-server ora....ver.vip application ONLINE ONLINE rac1-server ora....SM2.asm application ONLINE ONLINE rac2-server ora....ER.lsnr application ONLINE ONLINE rac2-server ora....ver.gsd application ONLINE ONLINE rac2-server ora....ver.ons application ONLINE ONLINE rac2-server ora....ver.vip application ONLINE ONLINE rac2-server
3.3 根据MOS文档思路,将数据库启动到mount
[oracle@rac1-server crsd]$ srvctl start database -d jy -o mount;[oracle@rac1-server crsd]$ crs_stat -tName Type Target State Host ------------------------------------------------------------ora.jy.db application ONLINE ONLINE rac1-server ora....y1.inst application ONLINE ONLINE rac1-server ora....y2.inst application ONLINE ONLINE rac2-server ora....SM1.asm application ONLINE ONLINE rac1-server ora....ER.lsnr application ONLINE ONLINE rac1-server ora....ver.gsd application ONLINE ONLINE rac1-server ora....ver.ons application ONLINE ONLINE rac1-server ora....ver.vip application ONLINE ONLINE rac1-server ora....SM2.asm application ONLINE ONLINE rac2-server ora....ER.lsnr application ONLINE ONLINE rac2-server ora....ver.gsd application ONLINE ONLINE rac2-server ora....ver.ons application ONLINE ONLINE rac2-server ora....ver.vip application ONLINE ONLINE rac2-server
3.4 尝试在mount下recover database
[oracle@rac1-server crsd]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on Mon Aug 14 22:43:03 2017Copyright (c) 1982, 2010, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> recover database;Media recovery complete.SQL> alter database open;Database altered.SQL>
最终成功recover并打开数据库。
3.5 节点2也将数据库open
节点2也将数据库open:
[oracle@rac2-server ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on Mon Aug 14 22:45:17 2017Copyright (c) 1982, 2010, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> select open_mode from v$database;OPEN_MODE----------MOUNTEDSQL> alter database open;Database altered.SQL>
至此,这套10g RAC的数据库实验环境恢复正常。
阅读全文
0 0
- 案例:数据库open时报错ORA-1172,ORA-1151 处理
- oracle数据库启动时报ORA-03113的处理
- expdp数据库时报ora-39002错误问题的处理01
- ORACLE10g建立数据库时报错 ORA-24324 ORA-24323 ORA-28547
- impdp时报错ORA-39083&ORA-01917
- rename datafile时报错ORA-01511,ORA-01121,ORA-01110
- 手动创建oracle数据库时报错:ORA-02778
- 手动创建oracle数据库时报错:ORA-02778 .
- ORA-17629:rman创建 standby数据库时报错
- 运行数据库实例,startup时报错“ORA-01031: insufficient privileges”
- 向ORACLE数据库表中插入时报错ORA-01722
- truncate时报错ORA-02266
- 数据库open报错ORA-01555: snapshot too old
- 在启动DB时报错ORA-27154 ORA-27300 ORA-27301 ORA-27302
- dbca 建库时报错:ORA-19504 ORA-12547 ORA-15001 ORA-15055
- ora-0110,01157数据库open不了
- ORACLE IMP ORA-00910 出错处理案例
- drop表时报 ORA-00604 ORA-01422 错
- new一个对象的时候JVM都做了那些事情
- telnet 命令发送HTTP请求报文
- Html Css 未掌握的地方回顾复习
- 漂亮回答面试官struts2的原理
- 简单选择排序、直接插入排序、归并排序
- 案例:数据库open时报错ORA-1172,ORA-1151 处理
- 斯坦福《编程方法学》Karel环境搭建问题一:运行时出现jpanel面板只有file选项 没有karel机器人的现象
- 使用mybatis-generator自动生成dao、model和mapper
- Springmvc controller 层 @Transactional 不起作用
- why group leader cannnot able create the session in Linux
- Volley NetworkImageView setImageResource 不起作用 原因
- 背包问题 初始化
- vue开发公共模块封装(http)
- Java学习笔记—注解(Annotation)的用法