oracle-rac实例不能启动 报ORA-03113

---

记一下控制集群的命令（关闭和打开）：
./crsctl stop crs -f
./crsctl start crs

解决过程：
SQL> startup

ORACLE instance started.

Total System Global Area 1252663296 bytes
Fixed Size 2227944 bytes
Variable Size 704643352 bytes
Database Buffers 536870912 bytes
Redo Buffers 8921088 bytes
Database mounted.
ORA-03113: end - of -file on communication channel
Process ID: 8117
Session ID: 191 Serial number: 3

可能由于断电数据库被强制异常关闭，导致文件状态可能不一致，因为正常关闭数据库会同步校验各文件，使得重新启动的时候文件时间点一致。

解决方案如下：

1. 启动数据库(mount方式)

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

2. 查看v$log

直接reset不成功
SQL> select * from v$log;
GROUP # THREAD# SEQUENCE # BYTES BLOCKSIZE MEMBERS ARC
/---------- ---------- ---------- ---------- ---------- ---------- —
STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
/---------------- ------------- --------- ------------ ---------
1 1 112 52428800 512 1 NO
INACTIVE 3826382 16-JUL-13 3857158 17-JUL-13
3 1 114 52428800 512 1 NO
CURRENT 3886899 17-JUL-13 2.8147E+14
2 1 113 52428800 512 1 NO
INACTIVE 3857158 17-JUL-13 3886899 17-JUL-13

3. reset log

SQL> alter database open resetlogs 2;
alter database open resetlogs 2
*
ERROR at line 1:
ORA-02288: invalid OPEN mode

4. 恢复数据库日志

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:ORA-01139: RESETLOGS option only valid after an incomplete database recovery
SQL> recover database until time ‘2013-07-05’
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.

---

按照上面的操作后，发现rac1正常，rac2还是同样的问题，于是在rac2上重启了集群，rac2上终于4个实例都起来了
Service “+ASM” has 1 instance(s).
Instance “+ASM2”, status READY, has 1 handler(s) for this service…
Service “+ASM_DATA” has 1 instance(s).f
Instance “+ASM2”, status READY, has 1 handler(s) for this service…
Service “orcl” has 1 instance(s).
Instance “orcl2”, status READY, has 1 handler(s) for this service…
Service “orclXDB” has 1 instance(s).
Instance “orcl2”, status READY, has 1 handler(s) for this service…
The command completed successfully
正常，处理完毕！

查阅资源：
https://blog.csdn.net/jingleli21/article/details/45888295
https://blog.csdn.net/der322/article/details/80522854
https://blog.csdn.net/jisen_huang/article/details/105199424

tips:
oracle用户：dbca命令创建数据库
grid用户：asmca管理asm磁盘组

rac的异常日志路径：
cat /opt/oracle/app/grid/diag/crs/rac1/crs/alert/log.xml
cat /opt/oracle/app/grid/diag/crs/rac2/crs/alert/log.xml