RAC 实例不能启动 ORA-1589 signalled during ALTER DATABASE OPEN

最新推荐文章于 2021-08-18 07:38:59 发布
最新推荐文章于 2021-08-18 07:38:59 发布
阅读量69 收藏
点赞数

今天启动RAC 做实验，发现RAC 实例怎么启动不了。

[@more@]

[oracle@rac2 bin]$ crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.orcl.db application ONLINE OFFLINE

ora....oltp.cs application ONLINE OFFLINE

ora....cl1.srv application ONLINE OFFLINE

ora....cl2.srv application ONLINE OFFLINE

ora....l1.inst application ONLINE OFFLINE

ora....l2.inst application ONLINE OFFLINE

ora....SM1.asm application ONLINE ONLINE rac1

ora....C1.lsnr application ONLINE ONLINE rac1

ora.rac1.gsd application ONLINE ONLINE rac1

ora.rac1.ons application ONLINE ONLINE rac1

ora.rac1.vip application ONLINE ONLINE rac1

ora....SM2.asm application ONLINE ONLINE rac2

ora....C2.lsnr application ONLINE ONLINE rac2

ora.rac2.gsd application ONLINE ONLINE rac2

ora.rac2.ons application ONLINE ONLINE rac2

ora.rac2.vip application ONLINE ONLINE rac2

看了一下ASM 的磁盘组，都挂载成功。

[oracle@rac2 bin]$ export ORACLE_SID=+ASM2

[oracle@rac2 bin]$ sqlplus / as sysdba;

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 28 04:33:24 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> select name,state from v$asm_diskgroup;

NAME STATE

------------------------------ -----------

DATA MOUNTED

FLASH_RECOVERY_AREA MOUNTED

SQL>

之前遇到过这种情况情况，所以第一时间就查看了这个ASM 磁盘组的信息。

ASM 没有问题，只能查看数据库的alert log了。

[oracle@rac1 bdump]$ pwd

/u01/app/oracle/admin/orcl/bdump

[oracle@rac1 bdump]$ ls

alert_orcl1.log orcl1_diag_22153.trc orcl1_lms0_22169.trc

cdmp_20100917173112 orcl1_lgwr_22186.trc orcl1_smon_22190.trc

orcl1_arc0_24180.trc orcl1_lmd0_22167.trc

orcl1_arc1_24182.trc orcl1_lmon_22165.trc

[oracle@rac1 bdump]$ tail -100 alert_orcl1.log

Tue Sep 28 04:05:20 2010

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

MMON started with pid=15, OS id=5650

Tue Sep 28 04:05:20 2010

starting up 1 shared server(s) ...

Tue Sep 28 04:05:20 2010

lmon registered with NM - instance id 1 (internal mem no 0)

Tue Sep 28 04:05:21 2010

Reconfiguration started (old inc 0, new inc 2)

List of nodes:

0

Global Resource Directory frozen

* allocate domain 0, invalid = TRUE

Communication channels reestablished

Master broadcasted resource hash value bitmaps

Non-local Process blocks cleaned out

Tue Sep 28 04:05:21 2010

LMS 0: 0 GCS shadows cancelled, 0 closed

Set master node info

Submitted all remote-enqueue requests

Dwn-cvts replayed, VALBLKs dubious

All grantable enqueues granted

Post SMON to start 1st pass IR

Tue Sep 28 04:05:21 2010

LMS 0: 0 GCS shadows traversed, 0 replayed

Tue Sep 28 04:05:21 2010

Submitted all GCS remote-cache requests

Post SMON to start 1st pass IR

Fix write in gcs resources

Reconfiguration complete

LCK0 started with pid=19, OS id=5683

Tue Sep 28 04:05:22 2010

ALTER DATABASE MOUNT

Tue Sep 28 04:05:22 2010

This instance was first to mount

Tue Sep 28 04:05:22 2010

Starting background process ASMB

ASMB started with pid=21, OS id=5706

Starting background process RBAL

RBAL started with pid=22, OS id=5710

Loaded ASM Library - Generic Linux, version 2.0.4 (KABI_V2) library for asmlib interface

Tue Sep 28 04:05:26 2010

SUCCESS: diskgroup DATA was mounted

SUCCESS: diskgroup FLASH_RECOVERY_AREA was mounted

Tue Sep 28 04:05:34 2010

Setting recovery target incarnation to 3

Tue Sep 28 04:05:35 2010

Successful mount of redo thread 1, with mount id 1258660482

Tue Sep 28 04:05:35 2010

Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)

Completed: ALTER DATABASE MOUNT

Tue Sep 28 04:05:35 2010

ALTER DATABASE OPEN

This instance was first to open

ORA-1589 signalled during: ALTER DATABASE OPEN...

Tue Sep 28 04:05:39 2010

Shutting down instance (abort)

License high water mark = 1

Instance terminated by USER, pid = 6080

从日志里我们发现了一个很重要的信息：

ALTER DATABASE OPEN

This instance was first to open

ORA-1589 signalled during: ALTER DATABASE OPEN...

Tue Sep 28 04:05:39 2010

Shutting down instance (abort)

查看了一下错误代码：

ORA-01589:
must use RESETLOGS or NORESETLOGS option for database open

Cause:
Either incomplete or backup control file recovery has been performed. After these types of recovery you must specify either the RESETLOGS option or the NORESETLOGS option to open your database.

Action:
Specify the appropriate option.

提示我们必须使用resetlogs 模式打开数据。 开到这才明白，昨天做RMAN 恢复后直接把数据库关了，没有用resetlogs打开。 杯具中..

手工启动数据库至mount 状态，在用resetlogs 打开：

[oracle@rac1 bdump]$ export ORACLE_SID=orcl1

[oracle@rac1 bdump]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 28 04:17:47 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn / as sysdba;

Connected to an idle instance.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 180355072 bytes

Fixed Size 1218388 bytes

Variable Size 109054124 bytes

Database Buffers 67108864 bytes

Redo Buffers 2973696 bytes

Database mounted.

SQL> alter database open resetlogs;

Database altered.

SQL>

在另一个节点，直接正常启动就可以了。

[oracle@rac2 bin]$ export ORACLE_SID=orcl2

[oracle@rac2 bin]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 28 04:22:50 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn / as sysdba

Connected to an idle instance.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 180355072 bytes

Fixed Size 1218388 bytes

Variable Size 88082604 bytes

Database Buffers 88080384 bytes

Redo Buffers 2973696 bytes

Database mounted.

SQL> alter database open;

Database altered.

SQL>

查看一下RAC 进程的状态：

[oracle@rac2 bin]$ crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.orcl.db application ONLINE ONLINE rac2

ora....oltp.cs application ONLINE ONLINE rac2

ora....cl1.srv application ONLINE ONLINE rac1

ora....cl2.srv application ONLINE ONLINE rac2

ora....l1.inst application ONLINE ONLINE rac1

ora....l2.inst application ONLINE ONLINE rac2

ora....SM1.asm application ONLINE ONLINE rac1

ora....C1.lsnr application ONLINE ONLINE rac1

ora.rac1.gsd application ONLINE ONLINE rac1

ora.rac1.ons application ONLINE ONLINE rac1

ora.rac1.vip application ONLINE ONLINE rac1

ora....SM2.asm application ONLINE ONLINE rac2

ora....C2.lsnr application ONLINE ONLINE rac2

ora.rac2.gsd application ONLINE ONLINE rac2

ora.rac2.ons application ONLINE ONLINE rac2

ora.rac2.vip application ONLINE ONLINE rac2

一切正常，从这个小错误中明白，遇到错误，要养成看alert log 的习惯。 不管是单实例还是RAC 实例，看log 永远是第一条。 还有就是要心细，昨天偷了懒，为了补这个懒，花的时间就比昨天多了很多。 杯具啊.


本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/tianlesoftware/archive/2010/09/28/5912227.aspx

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8109090/viewspace-1044510/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8109090/viewspace-1044510/

congqian1312
关注
Oracle数据库ORA-01589错误
qq_46850104的博客
11-11 2863
配好Oracle环境后大概过了半个月没打开SQL Developer，再次登录时报错，此时打开sql plus发现无法登录，报错ORA-01034: ORACLE not available以及ORA-27101: shared memory realm does not exist（如下）。 ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Process ID: 0 Session
【ORA-RAC】ORA-15045: ASM file name '+DATA01' is not in reference form
debimeng
03-09 2807
ORA-15045: ASM file name '+DATA01' is not in reference form报错信息：ORA-00210: cannot open the specified control fileORA-00202: control file: '+DATA01'ORA-17503: ksfdopn:2 Failed to open file +DATA01ORA-1...
RAC 实例不能启动 ORA-1589 signalled during ALTER DATABASE OPEN
David Dai -- Focus on Oracle
09-28 7062
<br /> <br />今天启动RAC 做实验，发现RAC 实例怎么启动不了。<br /> <br />[oracle@rac2 bin]$ crs_stat -t<br />Name           Type           Target    State     Host<br />------------------------------------------------------------<br />ora.orcl.db    application    ONLINE    O
ORA-01589错误 要打开数据库则必须使用 RESETLOGS 或 NORESETLOGS 选项
热门推荐
长安诗社社长@-梁瀚文- https://github.com/HevnChin https://gitee.com/HevnChin
12-29 4万+
<br />要打开数据库则必须使用 RESETLOGS 或 NORESETLOGS 选项<br /><br />SQL> startup<br />ORACLE 例程已经启动。<br />Total System Global Area 135338868 bytes<br />Fixed Size 453492 bytes<br />Variable Size 109051904 bytes<br />Database Buffers
ora12700linux,重启数据库时发生的报错ORA-32700 ORA-00221 ORA-00206 ORA-01503及其处理
weixin_31238185的博客
05-25 704
#sqlplus /nologSQL>startup nomount;ORA-32700: error occurred in DIAG Group Service重建控制文件时报出:ORA-00221: error on write to controlfileORA-00206: error in writing (block 1, # blocks 1) of controlfileO...
oracle 自动备份、重建控制文件--alter database backup controlfile to trace
LawssssCat的博客
05-12 1153
https://blog.csdn.net/xiezuoyong/article/details/82967709
oracle00205报错,案例:Oracle 12C报错ORA-00205 重建控制文件control file
weixin_42137539的博客
04-03 781
天萃荷净ORACLE 12C 控制文件异常恢复数据库在oracle 12c引进了pdb的概念,但重建控制文件的过程还是完全和no-cdb(以前版本ORACLE)相同数据库启动异常idle> startupORACLE instance started.Total System Global Area 521936896 bytesFixed Size 24...
异常掉电导致的ORA-[kfrValAcd30]故障处理
Enmotech的博客
06-29 1597
墨墨导读：本文详述硬件掉电后，Oracle集群无法启动的诡异故障处理过程。一、 问题描述现象：硬件掉电后，Oracle集群无法启动。[root@rac2 ~]# crsctl stat ...
ORACLE ORA-01950 对表空间无权限 错误问题
左直拳的马桶_日用桶
03-22 3万+
oracle中，插入记录失败，提示无权限，类似下图：我用的是A账号（默认表空间A），在表空间B中的表插入记录。结果就提示了上面的错误。查询是没问题的，插入则不行。INSERT INTO B.Real_Hyz_Oneminute_Water (FID, STATIONNO, DT, WT, SL, WL, CREATETIME, ID) VALUES (6, 'eeee', sysdate, 0.0
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
疯狂的石头
11-25 1万+
SQL> alter database open; alter database open * ERROR at line 1: ORA-01589: must use RESETLOGS or NORESETLOGS option for database open SQL> alter database open noresetlogs; alter database open
ORA-1122 signalled during: alter database open 错误解决
Zonelan
08-23 4243
帮忙解决一个数据库无法启动的问题，数据库处于非归档模式，没有物理备份和逻辑备份。由于磁盘坏块导致数据库无法正常启动。 得知这种情况，先做了最坏的打算，由于不知道磁盘的问题会影响哪些数据文件，很可能数据库根本无法启动。 登陆数据库服务器后，首先检查了一下alert文件，检查最后出现的错误信息： Fri Feb 15 15:22:40 2008 ORACLE V
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open一次恢复数据库
luopu873的博客
08-18 3772
有业务人员反馈连接数据库报错，Oracle ORA-01033: ORACLE initialization or shutdown in progress。发现数据库异常，尝试重启数据库，启动时报ORA-01113: file 1 needs media recovery，有数据文件需要恢复，然后尝试恢复数据文件。以下是此次恢复的操作记录。 #启动数据库报错，只能进入mount阶段。 SQL> startup ORACLE instance started. Total Sy.
asm磁盘加载小记
jc_benben的专栏
09-25 2012
今天在弄数据库的时候asm磁盘组没起来， 启动asm时候提示 SQL> startup ORA-00099: warning: no parameter filespecified for ASM instance ORA-01081: cannot start already-runningORACLE - shut it down first SQL> shutdown immedi
2019年计算机组装与维护实训实习报告.pdf
10-06
计算机试题试卷课件
2019年计算机维护实训总结.pdf
10-06
计算机试题试卷课件
【路径规划】基于matlab固定次序法移植路径规划（目标函数：最短距离）【含Matlab源码 8800期】.mp4
最新发布
10-06
Matlab领域上传的视频均有对应的完整代码，皆可运行，亲测可用，适合小白； 1、代码压缩包内容 主函数：main.m； 调用函数：其他m文件；无需运行 运行结果效果图； 2、代码运行版本 Matlab 2019b；若运行有误，根据提示修改；若不会，私信博主； 3、运行操作步骤 步骤一：将所有文件放到Matlab的当前文件夹中； 步骤二：双击打开main.m文件； 步骤三：点击运行，等程序运行完得到结果； 4、仿真咨询 如需其他服务，可私信博主或扫描视频QQ名片； 4.1 博客或资源的完整代码提供 4.2 期刊或参考文献复现 4.3 Matlab程序定制 4.4 科研合作
Oracle RAC 故障修复：ORA-03113 解决方案
12. **恢复RAC环境**：最后，启动所有的RAC实例，验证集群服务的完整性，确保所有实例都能正常工作，数据库完全恢复。 在处理ORA-03113错误时，重要的是保持耐心和细致，遵循正确的故障排查和恢复流程。同时，定期...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值