Oracle RAC日常管理命令(七)
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....SM2.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
（5）再启动数据库和实例
RACDB1@rac1 /home/oracle$ srvctl start database -d racdb
RACDB1@rac1 /home/oracle$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B1.inst application ONLINE ONLINE rac1
ora....B2.inst application ONLINE ONLINE rac2
ora....DB1.srv application OFFLINE OFFLINE注意这里service没有启动
ora.....TAF.cs application OFFLINE OFFLINE
ora.RACDB.db application ONLINE ONLINE rac2
ora....SM1.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....SM2.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
（6）再启动服务service
RACDB1@rac1 /home/oracle$ srvctl start service -d racdb
RACDB1@rac1 /home/oracle$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B1.inst application ONLINE ONLINE rac1
ora....B2.inst application ONLINE ONLINE rac2
ora....DB1.srv application ONLINE ONLINE rac1
ora.....TAF.cs application ONLINE ONLINE rac1
ora.RACDB.db application ONLINE ONLINE rac2
ora....SM1.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....SM2.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
六、分别查看RAC的参数文件，REDO日志，UNDO表空间，TEMP表空间的信息，说明一下在RAC环境下每个实例是否拥有专属自己的上述对象
RAC环境下数据库参数文件的位置
（1）放在各自实例的本地
（2）放在共享存储上，建议使用这种
我们既可以让两个实例使用共享存储上的参数文件
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ---------------------------------------------
spfile string+DATA/racdb/spfileracdb.ora 共享ASM磁盘上的参数文件
也可以让两个实例使用各自本地的参数文件
[oracle@rac1 dbs]$ ll
total 52
-rw-rw---- 1 oracle oinstall 1506 Jul 8 12:37 ab_+ASM1.dat
-rw-rw---- 1 oracle oinstall 1544 Jan 1 2012 hc_+ASM1.dat
-rw-rw---- 1 oracle oinstall 1544 Jan 1 2012 hc_RACDB1.dat
lrwxrwxrwx 1 oracle oinstall 41 Jan 1 2012 init+ASM1.ora -> /u01/app/oracle/admin/+ASM/pfile/init.ora
-rw-r----- 1 oracle oinstall 12920 May 3 2001 initdw.ora
-rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora
-rw-r----- 1 oracle oinstall 37 Jan 1 2012 initRACDB1.ora各自本地的参数文件
如果想使用共享存储上的参数文件，需要在本地参数文件中指定其路径（添加一条spfile重定向），如果不想使用，则无需添加，只在本地参数文件中定义各自实例参数即可。
[oracle@rac1 dbs]$ cat initRACDB1.ora
SPFILE='+DAT