探索RAC

1.检查应用程序资源的状态

  crs_stat -t

 

  srvctl status nodeapps -n rac1

 

  srvctl status nodeapps -n rac2

 

  srvctl status asm -n rac1

 

  srvctl status nodeapps -n rac2

 

 srvctl status database -d devdb

 

 srvctl status service -d devdb

 

2.检查Oracle集群件的状态

  rac1-> crsctl check crs

 

  rac2-> crsctl check crs

 

  set wrap off

  set linesize 132

  select instance_name,host_name,archiver,thread#,status from gv$instance;

  sqlplus /nolog

  conn system/oracle@devdb1

  conn system/oracle@devdb2

  conn system/oracle@devdb

 

  SQL> show sga

  SQL> select file_name,bytes/1024/1024 from dba_data_files;

 

3.启动和停止RAC

  停止：

   srvctl stop service -d devdb

   srvctl stop database -d devdb

   srvctl stop asm -n rac2

   srvctl stop asm -n rac1

   srvctl stop nodeapps -n rac2

   srvctl stop nodeapps -n rac1

   crs_stat -t

 

开启：

   srvctl start nodeapps -n rac1

   srvctl start nodeapps -n rac2

   srvctl start asm -n rac1

   srvctl start asm -n rac2

   srvctl start database -d devdb

   srvctl start service -d devdb

   crs_stat -t