ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-29701 :unable to connect to Cluster Manager(ORA-16038日志未归档)

ORA-29701 :unable to connect to Cluster Manager(ORA-16038日志未归档)

原创 Linux操作系统 作者:279531451 时间:2009-09-05 11:23:34 0 删除 编辑
因为机器不正常关机,在启动完机器,要重启数据库的ASM实例的时候,提示:
[oracle@redhat5 ~]$ export ORACLE_SID=+ASM
[oracle@redhat5 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on

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

SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORA-29701: unable to connect to Cluster Manager

解决的办法是,以root用户到目录$ORACLE_HOME/bin下,执行:
[root@redhat5 ~]# cd /u01/app/oracle/product/10.2.0/db_1/bin
[root@redhat5 bin]# ls local*
localconfig
[root@redhat5 bin]# ./localconfig delete
Stopping CSSD.
Unable to communicate with the CSS daemon.
Shutdown has begun. The daemons should exit soon.
[root@redhat5 bin]# ./localconfig
Usage:./localconfig [add] [delete] [ reset ]   [-silent]   [-paramfile ][root@redhat5 bin]# ./localconfig add
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configuration for local CSS has been initialized

Adding to inittab
Startup will be queued to init within 90 seconds.
Checking the status of new Oracle init process...
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
        redhat5
CSS is active on all nodes.
Oracle CSS service is installed and running under init(1M)
[root@redhat5 bin]#
--注:上面这步操作过程比较久...

然后,就可以继续正常的启动和操作了.

[root@redhat5 ~]# su - oracle
[oracle@redhat5 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on 鏄熸湡鍏?5鏈?9 19:20:35 2009

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

SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 188743680 bytes
Fixed Size                  1218412 bytes
Variable Size              79693972 bytes
Database Buffers          100663296 bytes
Redo Buffers                7168000 bytes
Database mounted.
ORA-16038: log 2 sequence# 45 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 2 thread 1:
'+DATA1/redhat/onlinelog/group_2.264.683310283'
ORA-00312: online log 2 thread 1:
'+DATA1/redhat/onlinelog/group_2.265.683310289'


SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;                      
ORACLE instance started.

Total System Global Area 188743680 bytes
Fixed Size                  1218412 bytes
Variable Size              79693972 bytes
Database Buffers          100663296 bytes
Redo Buffers                7168000 bytes
SQL> alter database mount;

Database altered.

SQL> select group#,sequence#,archived,members from v$log;

    GROUP# SEQUENCE# ARC    MEMBERS
---------- ---------- --- ----------
         1         47 NO           2
         3         46 NO           2
         2         45 NO           2
--是日志组一的一个日志不能归档。因为是测试机玩的系统,所以没有业务在跑,先想办法把数据库打开再说:
SQL> alter database clear unarchived logfile group 2;

Database altered.

SQL> alter database open;

Database altered.

至此,数据库已经不完全恢复打开.(丢失未归档在线日志的部分内容)

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

请登录后发表评论 登录
全部评论

注册时间:2009-09-01

  • 博文量
    100
  • 访问量
    153855