오라클 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를 생성 시 같이 생성하였다.
수동으로 생성 시 아래와 같이한다.

$ srvctl add service -d RAC -s oltp_service -r RAC1 -a RAC2 $ srvctl start service -d RAC -s oltp_service
나. CTF 작동여부 확인 < 노드 1에서 확인 >
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

You may also like...

답글 남기기

이메일 주소는 공개되지 않습니다. 필수 항목은 *(으)로 표시합니다