사용자 도구

사이트 도구


dbms:oracle:admin:oracleracmanage

문서의 이전 판입니다!


Oracle RAC Management

srvctl

srvctl

  • Syntax : srvctl command object [options]
  • commands summary(10g manual Server Control Utility Reference 참고)
command Description
srvctl addnode applications, database, database instance, ASM instance, or service 추가
srvctl removenode applications, database, database instance, ASM instance, or service 삭제
srvctl confignode applications, database, ASM instance, or service에 대한 구성 목록
srvctl enableEnables the database, database instance, ASM instance, or service
srvctl disableDisables the database, database instance, ASM instance, or service.
srvctl startnode applications, database, database instance, ASM instance, or service 시작
srvctl stopnode applications, database, database instance, ASM instance, or service 중단
srvctl modifynode applications, database, database instance, or service configuration 변경
srvctl relocate하나의 instance에서 다른 하나의 instance로 서비스 재배치
srvctl statusnode applications, database, database instance, ASM instance, or service 상태 확인
srvctl getenvnode applications, database, database instance, or service 구성에서 환경변수 보여줌
srvctl setenv and unsetenvnode applications, database, database instance, or service 구성에서 환경변수 설정ᆞ해제
  • SRVCTL Objects Summary
Object Noun NameAbbreviationPurpose
asmasmASM instances에서 add, configure, enable, start, obtain the status of, stop, disable, and remove명령어 사용
databasedbdatabases에서 add, configure, modify, manage environment variables for, enable, start, obtain the status of, stop, disable, and remove 명령어 사용
instanceinstdatabase instances에서 add, configure, modify, manage environment variables for, enable, start, obtain the status of, stop, and remove 명령어 사용
nodeappsno abbreviationnode applications에서 add, configure, modify, manage environment variables for, start, obtain the status of, stop, and remove 명령어 사용
serviceservcluster database에서 서비스를 add, configure, modify, manage environment variables for, enable, start, obtain the status of, relocate, disable, stop, and remove 할 수 있는 명령어 사용

srvctl 예제(시작·종료)

  1. RAC 전체를 기동한다.
    # srvctl start database -d SOAF
  2. 클러스터 종료(ASM사용 시)
    # export ORACLE_SID=soaf1
    # emctl stop dbconsole
    # srvctl stop instance -d soaf -i soaf1
    # srvctl stop asm -n rac1
    # srvctl stop nodeapps -n rac1
  3. 클러스터 시작(ASM사용 시)
    # export ORACLE_SID=soaf1
    # srvctl start instance -d soaf -i soaf1
    # srvctl start asm -n rac1
    # srvctl start nodeapps -n rac1
  4. 클러스터 및 ASM,DB 상태확인(ASM사용 시)
    # export ORACLE_SID=soaf1
    # crs_stat -t
       혹은 
    # crs_stat
    # srvctl status instance -d soaf -i soaf1
    # srvctl status asm -n rac1
    # srvctl status nodeapps -n rac1
  5. 클러스터 및 ASM,DB 설정확인(ASM사용 시)
    # export ORACLE_SID=soaf1
    # srvctl config instance -d soaf -i soaf1
        혹은 
    # srvctl config database -d soaf
    # srvctl config asm -n rac1
    # srvctl config nodeapps -n rac1 -a -g -s -l
    # srvctl config nodeapps -n rac1

crsctl

ASM

  1. ASM디스크 확인
    SQL> select d.name, a.path, a.state from v$asm_disk a, v$asm_diskgroup d where a.group_number=d.group_number;
dbms/oracle/admin/oracleracmanage.1208146094.txt.gz · 마지막으로 수정됨: 2008/04/14 13:08 저자 joang77