关于Oracle RAC的维护

2014-11-24 17:52:30 · 作者: · 浏览: 0

$ cat .profile


# Created for oracle RAC by ljg, 20091230 --- begin


#


umask 022


ORACLE_BASE=/u01/app/oracle;export ORACLE_BASE


CRS_HOME=/u01/crs/oracle/product/10/app;export CRS_HOME


ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1;export ORACLE_HOME


ORACLE_SID=eoms1;export ORACLE_SID


AIXTHREAD_SCOPE=S;export AIXTHREAD_SCOPE


PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:$ORACLE_HOME/bin:$CRS_HOME/bin:.;export PATH


#


# Created for oracle RAC by ljg, 20091230 --- end


if [ -s "$MAIL" ] # This is at Shell startup. In normal


then echo "$MAILMSG" # operation, the Shell checks


fi # periodically.


◆oracleRAC操作语法(4个层次):


1、服务、实例、数据库


srvctl status|start|stop service -d eoms -s TAF_EOMS_SERVER


srvctl status|start|stop instance -d eoms -i eoms1


srvctl status|start|stop database -d eoms


2、ASM实例:


srvctl status|start|stop asm -n sdwgrac1


3、nodeapps资源:


srvctl status|start|stop nodeapps -n sdwgrac1


4、crs:


crs_stat -t


crs_start res|-all


crs_stop res|-all


crsctl check|stop|start crs


/etc/init.crs start|stop


◆为ASM增加磁盘的操作步骤:


在盘阵侧为ASM新添加vdisk后,在两个节点执行以下步骤


cfgmgr:扫描硬件改动


lspv:检查是否有新盘


lsattr -El hdiskn:查看新加盘的属性


chdev -l hdiskn -a reserve_policy=no_reserve:把新加的盘设为共享


(如果有pvid,需要如下方式取消:chdev -l hdiskn -a pv=clear)


修改pv的属性为oracle用户使用:


chown oracle:dba /dev/rhdiskn


chmod 660 /dev/rhdiskn


最后在+ASM1实例添加磁盘:


$ export ORACLE_SID=+ASM1


$ sqlplus "/ as sysdba"


alter diskgroup DATA add disk '/dev/rhdiskn';


select group_number, name, TOTAL_MB, FREE_MB from V$asm_disk_stat;


alter diskgroup DATA drop disk DATA_0001;


◆创建表空间的步骤:


create (bigfile) tablespace test_ljg datafile '+DATA0/pm/datafile/test_ljg' size 200m;


alter database datafile '+DATA0/pm/datafile/test_ljg' resize 300m;


drop tablespace test_ljg including contents and datafiles;