[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
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.
至此,数据库已经不完全恢复打开.(丢失未归档在线日志的部分内容)