Oracle RAC集群维护

Oracle RAC集群维护--个人经验整理

1、检查集群状态：

　　[grid@rac02 ~]$ crsctl check cluster

　　CRS-4537: Cluster Ready Services is online

　　CRS-4529: Cluster Synchronization Services is online

　　CRS-4533: Event Manager is online

　　2、所有 Oracle 实例 —（数据库状态）:

　　[grid@rac02 ~]$ srvctl status database -d racdb

　　Instance racdb1 is running on node rac01

　　Instance racdb2 is running on node rac02

　　3、检查单个实例状态：

　　[grid@rac02 ~]$ srvctl status instance -d racdb -i racdb1

　　Instance racdb1 is running on node rac01

　　4、节点应用程序状态：

　　[grid@rac02 ~]$ srvctl status nodeapps

　　VIP rac01-vip is enabled

　　VIP rac01-vip is running on node: rac01

　　VIP rac02-vip is enabled

　　VIP rac02-vip is running on node: rac02

　　Network is enabled

　　Network is running on node: rac01

　　Network is running on node: rac02

　　GSD is disabled

　　GSD is not running on node: rac01

　　GSD is not running on node: rac02

　　ONS is enabled

　　ONS daemon is running on node: rac01

　　ONS daemon is running on node: rac02

　　eONS is enabled

　　eONS daemon is running on node: rac01

　　eONS daemon is running on node: rac02

　　5、列出所有的配置数据库：

　　[grid@rac02 ~]$ srvctl config database

　　racdb

　　6、数据库配置：

　　[grid@rac02 ~]$ srvctl config database -d racdb -a

　　Database unique name: racdb

　　Database name: racdb

　　Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1

　　Oracle user: oracle

　　Spfile: +RACDB_DATA/racdb/spfileracdb.ora

　　Domain: xzxj.edu.cn

　　Start options: open

　　Stop options: immediate

　　Database role: PRIMARY

　　Management policy: AUTOMATIC

　　Server pools: racdb

　　Database instances: racdb1,racdb2

　　Disk Groups: RACDB_DATA,FRA

　　Services:

　　Database is enabled

　　Database is administrator managed

　　7、ASM状态以及ASM配置：

　　[grid@rac02 ~]$ srvctl status asm

　　ASM is running on rac01,rac02

　　[grid@rac02 ~]$ srvctl config asm -a

　　ASM home: /u01/app/11.2.0/grid