Oracle RAC 实例不能启动解决方案

时间:2022-08-29 14:15:26

[oracle@rac1 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....SM2.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....SM1.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

 

 

二. 定位问题

 tail -f /rac/app/oracle/admin/+ASM/bdump/alert_+ASM1.log

连上ASM实例后,查看磁盘组状态,为DISMOUNTED,  应该就是这个原因导致实例无法启动了。 手动启动磁盘组后,在用crs_start 命令启动相关进程(记住 不能用crs_stop -all  或者 crs_start -all)

 export ORACLE_SID=+ASM2

[oracle@rac2 racg]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 15 03:53:18 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                           DISMOUNTED

FLASH_RECOVERY_AREA            DISMOUNTED

 

SQL> alter diskgroup DATA mount;

Diskgroup altered.

 

SQL> alter diskgroup FLASH_RECOVERY_AREA mount;

Diskgroup altered.

 

SQL> select name,state from v$asm_diskgroup;

 

NAME                           STATE

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

DATA                           MOUNTED

FLASH_RECOVERY_AREA            MOUNTED

 

SQL>

 

开机自动挂载

 

困扰我一周的问题了,

oracle RAC 每次启动后  库实例启动不了,搜了很多文章终于解决了

/rac/app/oracle/product/10.2.0/db_1/dbs/ init+ASM1.ora

增加asm_diskgroups='×××' ×××名字为select name,state from v$asm_diskgroup的名字;

asm_diskgroups=‘ORCL:VOL*’ 或者asm_diskgroups=‘ORCL:VOL1’