關於Oracle RAC的維護

來源:互聯網
上載者:User

◆Oracle使用者的環境設定:

$ 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;

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.