오라클 10g Raw Device 방식으로 RAC 설치 #8/8 (테스트)
1. Oracle Database 상태 확인
$ crs_stop -f ora.rac.db
$ crs_start -f ora.rac.db
$ crs_stat -t
Name Type Target State Host
————————————————————
ora.rac.db application ONLINE ONLINE rac1
ora….vice.cs application OFFLINE OFFLINE
ora….ac1.srv application OFFLINE OFFLINE
ora….c1.inst application ONLINE ONLINE rac1
ora….c2.inst application ONLINE ONLINE rac2
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….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
$ lsnrctl status
$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.5.0 – Production on 10-MAR-2012 19:01:59
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
————————
Alias LISTENER_RAC1
Version TNSLSNR for Linux: Version 10.2.0.5.0 – Production
Start Date 10-MAR-2012 17:38:19
Uptime 0 days 1 hr. 23 min. 40 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/product/10g/db/network/admin/listener.ora
Listener Log File /home/oracle/product/10g/db/network/log/listener_rac1.log
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.126.32)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.126.132)(PORT=1521)))
Services Summary…
Service “PLSExtProc” has 1 instance(s).
Instance “PLSExtProc”, status UNKNOWN, has 1 handler(s) for this service…
Service “rac” has 2 instance(s).
Instance “rac1”, status READY, has 2 handler(s) for this service…
Instance “rac2”, status READY, has 1 handler(s) for this service…
Service “rac_XPT” has 2 instance(s).
Instance “rac1”, status READY, has 2 handler(s) for this service…
Instance “rac2”, status READY, has 1 handler(s) for this service…
The command completed successfully
$ sqlplus / as sysdba
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> select name from v$controlfile;
NAME
--------------------------------------------
/dev/raw/raw12
/dev/raw/raw13
/dev/raw/raw14
SQL> select a.tablespace_name, b.file_id, b.file_name, b.bytes/1024/1024 mb
2 from dba_tablespaces a, dba_data_files b
3 where a.tablespace_name=b.tablespace_name;
TABLESPACE_NAME FILE_ID FILE_NAME MB
--------------- ---------- ------------------------------ ----
SYSTEM 1 /dev/raw/raw6 599
UNDOTBS1 2 /dev/raw/raw8 199
SYSAUX 3 /dev/raw/raw7 299
UNDOTBS2 4 /dev/raw/raw9 199
USERS 5 /dev/raw/raw10 99
SQL> select group#, member from v$logfile;
GROUP# MEMBER
---------- --------------------
1 /dev/raw/raw15
1 /dev/raw/raw16
2 /dev/raw/raw17
2 /dev/raw/raw18
3 /dev/raw/raw19
3 /dev/raw/raw20
4 /dev/raw/raw21
4 /dev/raw/raw22
8 rows selected.
2. RAC Fail-Over 테스트
가. OLTP 서비스 시작
$ srvctl start service -d RAC -s oltp_service
$ srvctl status service -d RAC -s oltp_service
oltp_service 서비스가 rac1 인스턴스에서 실행 중임
참고 : OLTP 서비스는 DBCA로 DB를 생성 시 같이 생성하였다.나. CTF 작동여부 확인 < 노드 1에서 확인 >
수동으로 생성 시 아래와 같이한다.
$ srvctl add service -d RAC -s oltp_service -r RAC1 -a RAC2 $ srvctl start service -d RAC -s oltp_service
SQL> show parameter service NAME TYPE VALUE ------------------------------------ ---------------------- ------------------------------ service_names string oltp_service< 노드 2에서 확인 >
SQL> show parameter service NAME TYPE VALUE ------------------------------------ ---------------------- ------------------------------ service_names string rac< 노드 1에서 작업 >
SQL> shutdown abort ORACLE instance shut down.< 노드 2에서 확인 >
SQL> show parameter service NAME TYPE VALUE ------------------------------------ ---------------------- ------------------------------ service_names string oltp_service
최신 댓글