检查cluster状态

[root@rac1 bin]# ./crsctl stat res -t

CRS-4535: Cannot communicate with Cluster Ready Services

CRS-4000: Command Status failed, or completed with errors.

[root@rac1 bin]# ./crsctl check cluster -all

CRS-4639: Could not contact Oracle High Availability Services

CRS-4000: Command Check failed, or completed with errors.

启动crs服务

[root@rac1 bin]# ./crsctl start crs

CRS-4123: Oracle High Availability Services has been started.

使用crsctl查看是否所有服务已经全部开启

[root@rac1 bin]# ./crsctl check cluster -all

**************************************************************

rac1:

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

**************************************************************

[root@rac1 bin]# ./crsctl stat res -t

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

NAME           TARGET  STATE        SERVER                   STATE_DETAILS      

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

Local Resources

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

ora.DATA.dg

               OFFLINE OFFLINE      rac1                                        

ora.LISTENER.lsnr

               ONLINE  ONLINE       rac1                                        

ora.LOG.dg

               OFFLINE OFFLINE      rac1                                        

ora.OCR.dg

               ONLINE  ONLINE       rac1                                        

ora.asm

               ONLINE  ONLINE       rac1                     Started            

ora.eons

               ONLINE  ONLINE       rac1                                        

ora.gsd

               OFFLINE OFFLINE      rac1                                         

ora.net1.network

               ONLINE  ONLINE       rac1                                        

ora.ons

               ONLINE  ONLINE       rac1                                        

ora.registry.acfs

               ONLINE  ONLINE       rac1                                         

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

Cluster Resources

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

ora.LISTENER_SCAN1.lsnr

      1        ONLINE  ONLINE       rac1                                        

ora.oc4j

      1        OFFLINE OFFLINE                                                  

ora.oracle.db

      1        OFFLINE OFFLINE                                                   

      2        OFFLINE OFFLINE                                                  

ora.rac1.vip

      1        ONLINE  ONLINE       rac1                                        

ora.rac2.vip

      1        ONLINE  INTERMEDIATE rac1                     FAILED OVER         

ora.scan1.vip

      1        ONLINE  ONLINE       rac1                                  

由上可知rac2还未启动crs，然后启动rac2的crs即可。

最后用crsctl stat res –t确认集群所有的服务都已开启。

进去asm确认asm磁盘组状态

sqlplus / as sysasm

SQL> select group_number,name,state,voting_files from v$asm_diskgroup;

GROUP_NUMBER NAME                           STATE       V

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

           1 OCR                            MOUNTED     N

           0 DATA                           DISMOUNTED  N

           0 LOG                            DISMOUNTED  N

因为oracle数据库还未启动所以DATA和LOG磁盘为dismonted状态。

启动oracle数据

srvctl start instance -d oracle -n rac1

srvctl start instance -d oracle -n rac2

确认数据库状态

[oracle@rac1 ~]$ srvctl status database -d oracle

Instance oracle2 is running on node rac1

Instance oracle1 is running on node rac2

数据库启动完毕。

查看asm磁盘状态

SQL> select group_number,name,state,voting_files from v$asm_diskgroup;

GROUP_NUMBER NAME                           STATE       V

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

           1 OCR                            MOUNTED     N

           2 DATA                           MOUNTED     N

           0 LOG                            DISMOUNTED  N

数据库使用的DATA磁盘组正常mounted（注：LOG磁盘组为笔者新添加的日志磁盘组还未使用）。