rac.txt

linux oracle10g cluster

+MESDBDATA/mesdb/datafile/


关机和开机步骤
一.关机
1.先关数据库
-bash-3.00$ srvctl stop database -d pcsrv03
2.关闭节点2 :pcba-mes-2
#shutdown -h now
3.关闭节点1:pcba-mes-1
#shutdown -h now
4.关闭存储器DS4500,在DS4500后面有两个电源开关.
5.关闭磁盘扩展柜EXP710,在EXP710后面有两个电源开关.
6.关闭光纤交换机.

二.开机
1.开光纤交换机.
2.开磁盘扩展柜EXP710,在EXP710后面有两个电源开关.
3.开存储器DS4500,在DS4500后面有两个电源开关.
4.开节点1:pcba-mes-1,在启动完成之后(5-8分钟).
5.开节点2:pcba-mes-2,启动要5-8分钟.

2个节点启动完之后查看RAC 的CRS 资源状态(root用户)
[root@pcba-mes-1 ~]# cd /u01/app/oracle/product/10.2.0.1/crs/bin/
[root@pcba-mes-1 bin]# ./crs_stat -t
[root@pcba-mes-1 bin]# ./crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    pcba-mes-1  
ora....-1.lsnr application    ONLINE    ONLINE    pcba-mes-1  
ora....s-1.gsd application    ONLINE    ONLINE    pcba-mes-1  
ora....s-1.ons application    ONLINE    ONLINE    pcba-mes-1  
ora....s-1.vip application    ONLINE    ONLINE    pcba-mes-1  
ora....SM2.asm application    ONLINE    ONLINE    pcba-mes-2  
ora....-2.lsnr application    ONLINE    ONLINE    pcba-mes-2  
ora....s-2.gsd application    ONLINE    ONLINE    pcba-mes-2  
ora....s-2.ons application    ONLINE    ONLINE    pcba-mes-2  
ora....s-2.vip application    ONLINE    ONLINE    pcba-mes-2  
ora.pcsrv03.db application    ONLINE    ONLINE    pcba-mes-1  
ora....31.inst application    ONLINE    ONLINE    pcba-mes-1  
ora....32.inst application    ONLINE    ONLINE    pcba-mes-2  
ora.....taf.cs application    ONLINE    ONLINE    pcba-mes-2  
ora....031.srv application    ONLINE    ONLINE    pcba-mes-1  
ora....032.srv application    ONLINE    ONLINE    pcba-mes-2  
如像上面的显示结果则表示数据库 启动完成.


oracle 10G RAC 一般操作命令:

1.关闭ORACLE 10G RAC数据库:

-bash-3.00$ su - oracle
Password: 
-bash-3.00$ srvctl stop database -d pcsrv03

2.启动ORACLE 10G RAC数据库
--bash-3.00$ srvctl start database -d pcsrv03

3.启动客户端FAILOVER TAF服务. 
-bash-3.00$ srvctl start service -d pcsrv03 -s taf

(如果TAF节点其中的一个没起来,就使用
-bash-3.00$ srvctl stop service -d pcsrv03 -s taf
再运行
-bash-3.00$ srvctl start service -d pcsrv03 -s taf


4.查看ORACLE 10G CRS 资源状态:

[root@pcba-mes-1 bin]# ./crs_stat -t

5.查看ORACLE 10G RAC 数据库状态.
-bash-3.00$ srvctl status database -d pcsrv03


倒入数据库数据

执行:
bash-3.00$ cd /u02/data/mesBackup051231/
$sh ./imp.sh 

imp.sh内容:
imp parfile=Restore1.txt

Restore1.txt内容:
userid=mes/pcbames
fromuser=mes
file=BKdata01-20051231.dmp
log=Result1x.log

1.当数据库起不来时候,用下列指令查看VOL1,VOL2,VOL3,VOL4是否都有出现
[root@pcba-mes-1 ~]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3
VOL4

2.若少掉,则用下列指令disable
[root@pcba-mes-1 ~]# /etc/init.d/oracleasm disable

3. 再用下列指令enable
[root@pcba-mes-1 ~]# /etc/init.d/oracleasm enable

4.查看ASM硬盘,如出现下面的状态,表示正常
[root@pcba-mes-1 ~]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3
VOL4

5.手动启动数据库
[root@pcba-mes-1 ~]# su - oracle
-bash-3.00$ srvctl start database -d pcsrv03

如果节点2有的应用无法正常启动.

一.查看ASM 硬盘状态:

1.用下列指令查看VOL1,VOL2,VOL3,VOL4是否都有出现
[root@pcba-mes-1 ~]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3
VOL4

2.若少掉,则用下列指令disable
[root@pcba-mes-1 ~]# /etc/init.d/oracleasm disable

3. 再用下列指令enable
[root@pcba-mes-1 ~]# /etc/init.d/oracleasm enable

4.查看ASM硬盘,如出现下面的状态,表示正常
[root@pcba-mes-1 ~]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3
VOL4


二.启动节点应用:

1.查看CRS 资源状态
[root@pcba-mes-1 ~]# cd /u01/app/oracle/product/10.2.0.1/crs/bin/
[root@pcba-mes-2 bin]# ./crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    pcba-mes-1  
ora....-1.lsnr application    ONLINE    ONLINE    pcba-mes-1  
ora....s-1.gsd application    ONLINE    ONLINE    pcba-mes-1  
ora....s-1.ons application    ONLINE    ONLINE    pcba-mes-1  
ora....s-1.vip application    ONLINE    ONLINE    pcba-mes-1  
ora....SM2.asm application    ONLINE    ONLINE    pcba-mes-2  
ora....-2.lsnr application    OFFLINE   OFFLINE               
ora....s-2.gsd application    ONLINE    ONLINE    pcba-mes-2  
ora....s-2.ons application    ONLINE    ONLINE    pcba-mes-2  
ora....s-2.vip application    ONLINE    ONLINE    pcba-mes-2  
ora.pcsrv03.db application    ONLINE    ONLINE    pcba-mes-1  
ora....31.inst application    ONLINE    ONLINE    pcba-mes-1  
ora....32.inst application    ONLINE    OFFLINE               
ora.....taf.cs application    ONLINE    ONLINE    pcba-mes-1  
ora....031.srv application    ONLINE    ONLINE    pcba-mes-1  
ora....032.srv application    OFFLINE   OFFLINE     

2.停止节点2的CRS 应用.
bash-3.00$ srvctl stop nodeapps -n pcba-mes-2

3.启动节点2的CRS 应用
-bash-3.00$ srvctl start nodeapps -n pcba-mes-2



如还不能起来,执行如下操作:

三.启动和停止CRS资源.

1.停止CRS 所有资源

[root@pcba-mes-2 bin]# ./crsctl stop crs
Stopping resources.
Successfully stopped CRS resources 
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.

2.查看CRS资源是否已停止,如出现下面状态,表示已停止,如有其他的进程,KILL掉.
[root@pcba-mes-2 bin]# ps -ef |grep crs
root     25712     1  0 10:44 ?        00:00:00 /bin/sh /etc/init.d/init.crsd run
root     25895 27133  0 10:45 pts/2    00:00:00 grep crs

3.启动CRS所有资源,需要5分钟.
[root@pcba-mes-2 bin]# ./crsctl start crs
Attempting to start CRS stack 
The CRS stack will be started shortly

4.查看CRS的进程,出现下面的状况,表示进程已启动.
[root@pcba-mes-2 bin]# ps -ef |grep crs
root     25711     1  0 10:44 ?        00:00:00 /bin/su -l oracle -c sh -c 'ulimit -c unlimited; cd /u01/app/oracle/product/10.2.0.1/crs/log/pcba-mes-2/evmd; exec /u01/app/oracle/product/10.2.0.1/crs/bin/evmd '
root     25712     1  0 10:44 ?        00:00:00 /u01/app/oracle/product/10.2.0.1/crs/bin/crsd.bin reboot
oracle   26232 25711  0 10:46 ?        00:00:00 /u01/app/oracle/product/10.2.0.1/crs/bin/evmd.bin
root     26349 26280  0 10:46 ?        00:00:00 /bin/su -l oracle -c /bin/sh -c 'ulimit -c unlimited; cd /u01/app/oracle/product/10.2.0.1/crs/log/pcba-mes-2/cssd;  /u01/app/oracle/product/10.2.0.1/crs/bin/ocssd  || exit $?'
oracle   26350 26349  0 10:46 ?        00:00:00 /bin/sh -c ulimit -c unlimited; cd /u01/app/oracle/product/10.2.0.1/crs/log/pcba-mes-2/cssd;  /u01/app/oracle/product/10.2.0.1/crs/bin/ocssd  || exit $?
oracle   26370 26350  0 10:46 ?        00:00:00 /u01/app/oracle/product/10.2.0.1/crs/bin/ocssd.bin
oracle   26634 26232  0 10:47 ?        00:00:00 /u01/app/oracle/product/10.2.0.1/crs/bin/evmlogger.bin -o /u01/app/oracle/product/10.2.0.1/crs/evm/log/evmlogger.info -l /u01/app/oracle/product/10.2.0.1/crs/evm/log/evmlogger.log
oracle   27367     1  0 10:47 ?        00:00:00 /u01/app/oracle/product/10.2.0.1/crs/opmn/bin/ons -d
oracle   27368 27367  0 10:47 ?        00:00:00 /u01/app/oracle/product/10.2.0.1/crs/opmn/bin/ons -d
root     28118 27133  0 10:47 pts/2    00:00:00 grep crs

5.查看CRS资源的状态
[root@pcba-mes-2 bin]# ./crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    pcba-mes-1  
ora....-1.lsnr application    ONLINE    ONLINE    pcba-mes-1  
ora....s-1.gsd application    ONLINE    ONLINE    pcba-mes-1  
ora....s-1.ons application    ONLINE    ONLINE    pcba-mes-1  
ora....s-1.vip application    ONLINE    ONLINE    pcba-mes-1  
ora....SM2.asm application    ONLINE    ONLINE    pcba-mes-2  
ora....-2.lsnr application    ONLINE    ONLINE    pcba-mes-2  
ora....s-2.gsd application    ONLINE    OFFLINE               
ora....s-2.ons application    ONLINE    ONLINE    pcba-mes-2  
ora....s-2.vip application    ONLINE    ONLINE    pcba-mes-2  
ora.pcsrv03.db application    ONLINE    ONLINE    pcba-mes-1  
ora....31.inst application    ONLINE    ONLINE    pcba-mes-1  
ora....32.inst application    ONLINE    OFFLINE               
ora.....taf.cs application    ONLINE    ONLINE    pcba-mes-1  
ora....031.srv application    ONLINE    ONLINE    pcba-mes-1  
ora....032.srv application    OFFLINE   OFFLINE    

6.如看到上面的状态,则手动启动节点2的应用.
[root@pcba-mes-2 bin]# su - oracle
-bash-3.00$ srvctl start nodeapps -n pcba-mes-2
-bash-3.00$ exit
logout

7.再查看CRS的资源状态
[root@pcba-mes-2 bin]# ./crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    pcba-mes-1  
ora....-1.lsnr application    ONLINE    ONLINE    pcba-mes-1  
ora....s-1.gsd application    ONLINE    ONLINE    pcba-mes-1  
ora....s-1.ons application    ONLINE    ONLINE    pcba-mes-1  
ora....s-1.vip application    ONLINE    ONLINE    pcba-mes-1  
ora....SM2.asm application    ONLINE    ONLINE    pcba-mes-2  
ora....-2.lsnr application    ONLINE    ONLINE    pcba-mes-2  
ora....s-2.gsd application    ONLINE    ONLINE    pcba-mes-2  
ora....s-2.ons application    ONLINE    ONLINE    pcba-mes-2  
ora....s-2.vip application    ONLINE    ONLINE    pcba-mes-2  
ora.pcsrv03.db application    ONLINE    ONLINE    pcba-mes-1  
ora....31.inst application    ONLINE    ONLINE    pcba-mes-1  
ora....32.inst application    ONLINE    OFFLINE               
ora.....taf.cs application    ONLINE    ONLINE    pcba-mes-1  
ora....031.srv application    ONLINE    ONLINE    pcba-mes-1  
ora....032.srv application    OFFLINE   OFFLINE      

8.如出现上面的状态,表示节点2(PCBA-MES-2)INSTANCE 还没启动,手动启动INSTANCE.
-bash-3.00$ srvctl start instance -d pcsrv03 -i pcsrv032

9.启动完之后,查看数据库状态.
-bash-3.00$ srvctl status database -d pcsrv03
Instance pcsrv031 is running on node pcba-mes-1
Instance pcsrv032 is running on node pcba-mes-2

10.查看CRS资源状态.
[root@pcba-mes-2 bin]# ./crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    pcba-mes-1  
ora....-1.lsnr application    ONLINE    ONLINE    pcba-mes-1  
ora....s-1.gsd application    ONLINE    ONLINE    pcba-mes-1  
ora....s-1.ons application    ONLINE    ONLINE    pcba-mes-1  
ora....s-1.vip application    ONLINE    ONLINE    pcba-mes-1  
ora....SM2.asm application    ONLINE    ONLINE    pcba-mes-2  
ora....-2.lsnr application    ONLINE    ONLINE    pcba-mes-2  
ora....s-2.gsd application    ONLINE    ONLINE    pcba-mes-2  
ora....s-2.ons application    ONLINE    ONLINE    pcba-mes-2  
ora....s-2.vip application    ONLINE    ONLINE    pcba-mes-2  
ora.pcsrv03.db application    ONLINE    ONLINE    pcba-mes-1  
ora....31.inst application    ONLINE    ONLINE    pcba-mes-1  
ora....32.inst application    ONLINE    ONLINE    pcba-mes-2  
ora.....taf.cs application    ONLINE    ONLINE    pcba-mes-1  
ora....031.srv application    ONLINE    ONLINE    pcba-mes-1  
ora....032.srv application    OFFLINE   OFFLINE     

11.如出现上面的状态,表示节点2的TAF服务没有起来,先停止TAF执行下面的命令.
-bash-3.00$ srvctl stop service -d pcsrv03 -s taf

12.停止TAF 服务后,再启动TAF服务,执行下面的命令.
-bash-3.00$ srvctl start service -d pcsrv03 -s taf

13.查看CRS 的资源状态.如出现下面的状态,表示RAC启动完成.
[root@pcba-mes-2 bin]# ./crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    pcba-mes-1  
ora....-1.lsnr application    ONLINE    ONLINE    pcba-mes-1  
ora....s-1.gsd application    ONLINE    ONLINE    pcba-mes-1  
ora....s-1.ons application    ONLINE    ONLINE    pcba-mes-1  
ora....s-1.vip application    ONLINE    ONLINE    pcba-mes-1  
ora....SM2.asm application    ONLINE    ONLINE    pcba-mes-2  
ora....-2.lsnr application    ONLINE    ONLINE    pcba-mes-2  
ora....s-2.gsd application    ONLINE    ONLINE    pcba-mes-2  
ora....s-2.ons application    ONLINE    ONLINE    pcba-mes-2  
ora....s-2.vip application    ONLINE    ONLINE    pcba-mes-2  
ora.pcsrv03.db application    ONLINE    ONLINE    pcba-mes-1  
ora....31.inst application    ONLINE    ONLINE    pcba-mes-1  
ora....32.inst application    ONLINE    ONLINE    pcba-mes-2  
ora.....taf.cs application    ONLINE    ONLINE    pcba-mes-2  
ora....031.srv application    ONLINE    ONLINE    pcba-mes-1  
ora....032.srv application    ONLINE    ONLINE    pcba-mes-2 


停止 Oracle RAC 10g 环境 
第一步是停止 Oracle 实例。当此实例（和相关服务）关闭后，关闭 ASM 实例。最后，关闭节点应用程序（虚拟 IP、GSD、TNS 监听器和 ONS）。 

emctl stop dbconsole
srvctl stop instance -d pcsrv03 -i pcsrv031
srvctl stop asm -n pcba-mes-1
srvctl stop nodeapps -n pcba-mes-1

启动 Oracle RAC 10g 环境 
第一步是启动节点应用程序（虚拟 IP、GSD、TNS 监听器和 ONS）。当成功启动节点应用程序后，启动 ASM 实例。最后，启动 Oracle 实例（和相关服务）以及企业管理器数据库控制台。 

srvctl start nodeapps -n pcba-mes-1
srvctl start asm -n pcba-mes-1
srvctl start instance -d pcsrv03 -i pcsrvo31
emctl start dbconsole

使用 SRVCTL 启动/停止所有实例 
启动/停止所有实例及其启用的服务。我只是觉得有意思就把此步骤作为关闭所有实例的一种方法加进来了！ 
srvctl start database -d pcsrv03

srvctl stop database -d pcsrv03


olsnodes 

Crs 错误日记
Node1: /u01/app/oracle/product/10.2.0.1/crs/log/node1
Node2: /u01/app/oracle/product/10.2.0.1/crs/log/node2


删除SGA碎片

alter system flush shared_pool