RAC 수동 구성

rac2 수동으로 DB Instance 등록
---------------------------------------------------------------
/etc/oratab 수정
----------------
+ASM2:/oracle/product/10.2.0/db_1:N
RAC:/oracle/product/10.2.0/db_1:N

Instance 추가
----------------
srvctl add instance -d RAC -i RAC2 -n rac2

init 수정
----------------
alter system set cluster_database_instances=2 scope=spfile sid='*';
alter system set cluster_database=true scope=spfile sid='*';
alter system set instance_number=1 scope=spfile sid='RAC1';
alter system set instance_number=2 scope=spfile sid='RAC2';
alter system set remote_listener='LISTENERS_RAC' scope=spfile sid='*';
alter system set thread=1 scope=spfile sid='RAC1';
alter system set thread=2 scope=spfile sid='RAC2';
alter system set undo_tablespace='UNDOTBS1' scope=spfile sid='RAC1';
alter system set undo_tablespace='UNDOTBS2' scope=spfile sid='RAC2';
RAC2.__db_cache_size=255852544
RAC2.__java_pool_size=4194304
RAC2.__large_pool_size=4194304
RAC2.__shared_pool_size=150994944
RAC2.__streams_pool_size=0

UNDOTBS2 추가
----------------
create undo tablespace UNDOTBS2 datafile size 200m;

logfile 추가
----------------
show parameter file_d
db_create_file_dest string +DG1
db_recovery_file_dest string +DG2
# Redolog 각그룹의 file은 DG1,DG2에 생성.
alter database add logfile thread 2
group 4 size 52428800,
group 5 size 52428800,
group 6 size 52428800;

alter database enable public thread 2;

cluster view 생성
------------------
connect / as sysdba
@?/rdbms/admin/catclust.sql
---------------------------------------------------------------
---------------------------------------------------------------
---------------------------------------------------------------
---------------------------------------------------------------
---------------------------------------------------------------
---------------------------------------------------------------
---------------------------------------------------------------
---------------------------------------------------------------
---------------------------------------------------------------
---------------------------------------------------------------
---------------------------------------------------------------
---------------------------------------------------------------

crs_start -p * backup OCR Information
---------------------------------------------------------------
for res in `$ORA_CRS_HOME/bin/crs_stat -p | grep "^NAME=" | cut -d = -f 2` ; do
$ORA_CRS_HOME/bin/crs_stat -p $res >./$res.cap
done

---------------------------------------------------------------
각 OS별 init.crs 위치
----------------------
/bin/uname
Run Root
Linux: /etc/init.d/init.cssd disable
HP-UX: /sbin/init.d/init.cssd disable
SunOS: /etc/init.d/init.cssd disable
AIX: /etc/init.cssd disable
OSF1: /sbin/init.d/init.cssd disable

init.cssd disable|enable 상태 확인
----------------------------------
/etc/init.d/init.cssd disable
/sbin/init.d/init.cssd disable
/etc/oracle/scls_scr/rac1/root/crsstart
disable
/etc/oracle/scls_scr/rac1/root/crsdboot
stopped

---------------------------------------------------------------

init+ASM2.ora
----------------------------
#asm_diskgroups='DG1' # select name,state from v$asm_diskgroup; # export ORACLE_SID=+ASM2
# alter diskgroup dg2 mount;
asm_diskgroups='DG1','DG2'

---------------------------------------------------------------
---------------------------------------------------------------
명령
---------------------------------------------------------------
oifcfg iflist

su
crsctl stop crs --- Shutting down instance (immediate)
-- only service down on local host
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.

srvctl stop nodeapps -n rac1
srvctl stop nodeapps -n rac2
crs_stop ora.RAC.db

srvctl stop instance -d rac -i rac2
srvctl stop instance -d rac -i 'rac1,rac2'
crs_stop ora.rac2.ASM2.asm
srvctl start nodeapps -n rac2

crs_stop ora.RAC.RAC1.inst
crs_stop ora.RAC.RAC2.inst
crs_stop ora.RAC.db
crs_stop ora.rac1.ASM1.asm
crs_stop ora.rac1.LISTENER_RAC1.lsnr
crs_stop ora.rac1.gsd
crs_stop ora.rac1.ons
crs_stop ora.rac1.vip
crs_stop ora.rac2.ASM2.asm
crs_stop ora.rac2.LISTENER_RAC2.lsnr
crs_stop ora.rac2.gsd
crs_stop ora.rac2.ons
crs_stop ora.rac2.vip

alter system register; - Instance will force service updates with the listener.

init.crs stop 실행시 db는 shutdown abort로 종료
---------------------------------------------------------------
/etc/init.d/init.crs stop
DB: Shutting down instance (abort)

crsctl stop crs 실행시 db는 shutdown immediate 로 종료
---------------------------------------------------------------
su
crsctl stop crs --- Shutting down instance (immediate)
-- only service down on local host
---------------------------------------------------------------


admin/RAC/scripts
---------------------------------------------------------------
CreateDB.sql
CreateDBFiles.sql
CreateDBCatalog.sql
rdbms/admin/catalog.sql
rdbms/admin/catblock.sql
rdbms/admin/catproc.sql
rdbms/admin/catoctk.sql
rdbms/admin/owminst.plb
system
sqlplus/admin/pupbld.sql
sqlplus/admin/help/hlpbld.sql helpus.sql
emRepository.sql
sysman/admin/emdrep/sql/emreposcre $ORACLE_HOME SYSMAN $sysman_pwd TEMP ON;
WHENEVER SQLERROR CONTINUE;
CreateClustDBViews.sql
connect "SYS"/"&&sysPassword" as SYSDBA
rdbms/admin/catclust.sql
echo "SPFILE='+DG1/RAC/spfileRAC.ora'"> ../dbs/initRAC1.ora
postDBCreation.sql

set verify off
prompt specify a password for sys as parameter 1;
DEFINE sysPassword = &1
connect "SYS"/"&&sysPassword" as SYSDBA