행위

"CRSCTL 명령어"의 두 판 사이의 차이

DB CAFE

(→‎ocr /list 수동 백업)
(→‎crsctl 명령어)
 
(같은 사용자의 중간 판 4개는 보이지 않습니다)
1번째 줄: 1번째 줄:
 
== crsctl 명령어 ==
 
== crsctl 명령어 ==
 +
* oracle docs
 +
*:https://docs.oracle.com/database/121/CWADD/GUID-6A4E73C4-E1A0-4D90-B69A-7B2B4DAB66BA.htm#CWADD91595
 +
 
=== crs autorestart  Enable/Disable ===
 
=== crs autorestart  Enable/Disable ===
 
* Run as root user
 
* Run as root user
90번째 줄: 93번째 줄:
 
$GRID_HOME/bin/crsctl query css votedisk
 
$GRID_HOME/bin/crsctl query css votedisk
 
</source>
 
</source>
 +
 +
=== 디스크 타임아웃 조회 ===
 +
* Disk timeout from node to voting disk(disktimeout)
 +
<source lang=sql>
 +
crsctl get css disktimeout
 +
 +
CRS-4678: Successful get disktimeout 200 for Cluster Synchronization Services.
 +
</source>
 +
 +
* Network latency in the node interconnect (Misscount)
 +
<source lang=sql>
 +
crsctl get css misscount
 +
 +
CRS-4678: Successful get misscount 30 for Cluster Synchronization Services.
 +
</source>
 +
 +
=== olsnode를 이용한  node 정보 조회 ===
 +
<source lang=sql>
 +
-- List of nodes in the cluster
 +
olsnodes
 +
 +
-- Nodes with node number
 +
olsnodes -n
 +
 +
-- Node with vip
 +
olsnodes -i
 +
olsnodes -s -t
 +
 +
-- Leaf or Hub
 +
olsnodes -a
 +
 +
-- Getting private ip details of the local node
 +
olsnodes -l -p
 +
 +
-- Get cluster name
 +
olsnodes -c
 +
</source>
 +
 +
=== 클러스터 환경설정 정보 조회 ===
 +
<source lang=sql>
 +
$ crsctl get cluster configuration
 +
 +
Name          : dbaclass-cluster
 +
Configuration : Cluster
 +
Class        : Standalone Cluster
 +
Type          : flex
 +
The cluster is not extended.
 +
--------------------------------------------------------------------------------
 +
MEMBER CLUSTER INFORMATION
 +
 +
Name            Version            GUID            Deployed          Deconfigured
 +
================================================================================
 +
================================================================================
 +
</source>
 +
 +
<source lang=sql>
 +
$ crsctl get node role status -all
 +
 +
Node 'hostnode1' active role is 'hub'
 +
Node 'hostnode2' active role is 'hub'
 +
</source>
 +
 +
=== RAC 인터페이스 정보조회 ===
 +
<source lang=sql>
 +
oifcfg iflist -p -n
 +
 +
backup0 172.21.56.0 PRIVATE 255.255.254.0
 +
cdnet0 162.168.1.0 PRIVATE 255.255.255.0
 +
cdnet0 169.254.0.0 PUBLIC 255.255.128.0
 +
cdnet1 162.168.2.0 PRIVATE 255.255.255.0
 +
cdnet1 169.254.128.0 PUBLIC 255.255.128.0
 +
pap-ipmp0 172.20.179.128 PUBLIC 255.255.255.128
 +
tan-ipmp0 172.20.128.0 PRIVATE 255.255.252.0
 +
dppp0 162.168.224.0 PRIVATE 255.255.255.0
 +
</source>
 +
 +
=== RAC - OLR(Oracle Local Registry) ===
 +
* OLR(ORACLE LOCAL REGISTRY)
 +
<source lang=sql>
 +
-- Get current OLR location:(run from root only)
 +
$GRID_HOME/bin/ocrcheck -local
 +
 +
-- List the OLR backups:
 +
$GRID_HOME/bin/ocrconfig -local -showbackup
 +
 +
-- Take manual OLR backup:
 +
$GRID_HOME/bin/ocrconfig -local -manualbackup
 +
</source>
 +
 +
[[category:oracle]]

2024년 8월 20일 (화) 18:47 기준 최신판

thumb_up 추천메뉴 바로가기

1 crsctl 명령어[편집]

1.1 crs autorestart Enable/Disable[편집]

  • Run as root user
$GRID_HOME/bin/crsctl enable crs
CRS-4622: Oracle High Availability Services autostart is enabled.

$GRID_HOME/bin/crsctl disable crs
CRS-4621: Oracle High Availability Services autostart is disabled.

1.2 crs Stop/Start[편집]

-- stop crs ( run from root)
$GRID_HOME/bin/crsctl stop crs

-- start crs( run from root)
$GRID_HOME/bin/crsctl start crs

1.3 RAC에서 클러스터 명 찾기[편집]

$GRID_HOME/bin/cemutlo -n
-- or
$GRID_HOME/bin/olsnodes -c

1.4 voting disk 위치 조회[편집]

$GRID_HOME/bin/crsctl query css votedisk

1.5 OCR 위치 조회[편집]

$GRID_HOME/bin/ocrcheck

1.6 그리드 버전 조회[편집]

$GRID_HOME/bin/crsctl query crs softwareversion

1.7 클러스터 컴포넌트 상태 체크[편집]

$GRID_HOME/bin/crsctl stat res -t

$GRID_HOME/bin/crsctl check crs

$GRID_HOME/bin/crsctl check cssd

$GRID_HOME/bin/crsctl check crsd

$GRID_HOME/bin/crsctl check evmd

1.8 cluster_interconnect 상세조회[편집]

$GRID_HOME/bin/oifcfg getif

app-ipmp0 172.21.39.128 global public
loypredbib0 172.16.3.192 global cluster_interconnect
loypredbib1 172.16.4.0 global cluster_interconnect

select NAME,IP_ADDRESS from v$cluster_interconnects;

NAME IP_ADDRESS
--------------- ----------------
loypredbib0 172.16.3.193
loypredbib1 172.16.4.1

1.9 ocr /list 수동 백업[편집]

List down the backups of OCR

$GRID_HOME/bin/ocrconfig -showbackup

 

Take manual OCR backup

$GRID_HOME/bin/ocrconfig -manualbackup

1.10 Voting Disk를 새로운 DistGroup으로 이동하기[편집]

$GRID_HOME/bin/crsctl replace votedisk +NEW_DG

-- Check the status using below command
$GRID_HOME/bin/crsctl query css votedisk

1.11 디스크 타임아웃 조회[편집]

  • Disk timeout from node to voting disk(disktimeout)
crsctl get css disktimeout

CRS-4678: Successful get disktimeout 200 for Cluster Synchronization Services.
  • Network latency in the node interconnect (Misscount)
crsctl get css misscount

CRS-4678: Successful get misscount 30 for Cluster Synchronization Services.

1.12 olsnode를 이용한 node 정보 조회[편집]

-- List of nodes in the cluster
olsnodes

-- Nodes with node number
olsnodes -n

-- Node with vip
olsnodes -i
olsnodes -s -t

-- Leaf or Hub
olsnodes -a

-- Getting private ip details of the local node
olsnodes -l -p

-- Get cluster name
olsnodes -c

1.13 클러스터 환경설정 정보 조회[편집]

$ crsctl get cluster configuration

Name          : dbaclass-cluster
Configuration : Cluster
Class         : Standalone Cluster
Type          : flex
The cluster is not extended.
--------------------------------------------------------------------------------
MEMBER CLUSTER INFORMATION

Name             Version             GUID            Deployed           Deconfigured
================================================================================
================================================================================
$ crsctl get node role status -all

Node 'hostnode1' active role is 'hub'
Node 'hostnode2' active role is 'hub'

1.14 RAC 인터페이스 정보조회[편집]

oifcfg iflist -p -n

backup0 172.21.56.0 PRIVATE 255.255.254.0
cdnet0 162.168.1.0 PRIVATE 255.255.255.0
cdnet0 169.254.0.0 PUBLIC 255.255.128.0
cdnet1 162.168.2.0 PRIVATE 255.255.255.0
cdnet1 169.254.128.0 PUBLIC 255.255.128.0
pap-ipmp0 172.20.179.128 PUBLIC 255.255.255.128
tan-ipmp0 172.20.128.0 PRIVATE 255.255.252.0
dppp0 162.168.224.0 PRIVATE 255.255.255.0

1.15 RAC - OLR(Oracle Local Registry)[편집]

  • OLR(ORACLE LOCAL REGISTRY)
-- Get current OLR location:(run from root only)
$GRID_HOME/bin/ocrcheck -local

-- List the OLR backups:
$GRID_HOME/bin/ocrconfig -local -showbackup

-- Take manual OLR backup:
$GRID_HOME/bin/ocrconfig -local -manualbackup
원본 주소 "http://dbcafe.co.kr/wiki/index.php?title=CRSCTL_명령어&oldid=12509"