[MIP-107] MCCS agent ์žฌ์‹œ์ž‘ ํ›„ active์˜ ๋ฏธ๋Ÿฌ๋””์Šคํฌ๊ฐ€ target์œผ๋กœ ๋ณ€๊ฒฝ๋จ

Subject
MCCS agent ์žฌ์‹œ์ž‘ ํ›„ active์˜ ๋ฏธ๋Ÿฌ๋””์Šคํฌ๊ฐ€ target์œผ๋กœ ๋ณ€๊ฒฝ๋จ

APPLIES TO:
MCCS 3.1(2010-03-23์ผ์ž, r3229)

DK 7.0.5
DL360 G5 (CPU:2.6Ghz x 4, RAM:3.325GB), DL380 G4 (CPU:3.2Ghz x 4 , RAM:3.583GB)"



SYMPTOMS
3์ผ 09์‹œ53๋ถ„ ๊ฒฝ PKDBSVR02์„œ๋ฒ„ ๋ฆฌ๋ถ€ํŒ…์œผ๋กœ failover๋˜์—ˆ์Šต๋‹ˆ๋‹ค.
5์ผ 15์‹œ29๋ถ„ ๊ฒฝ MCCS console ์ ‘์†์ด ์•ˆ๋œ๋‹ค๊ณ  ํ•˜์—ฌ ์–‘์„œ๋ฒ„ MCCS agent ์žฌ๊ธฐ๋™์„ ํ•˜๋‹ˆ ์–‘์„œ๋ฒ„ ๋ฏธ๋Ÿฌ๋””์Šคํฌ๊ฐ€ source-source ์ƒํƒœ๋ผ๊ณ  ๋œจ๋ฉด์„œ
ํ˜„ active์„œ๋ฒ„์ธ PKDBSVR02-1์„œ๋ฒ„ ๋ฏธ๋Ÿฌ๋””์Šคํฌ๊ฐ€ target์œผ๋กœ ๋ฐ”๋€Œ๋ฉด์„œ mssql์„œ๋น„์Šค๋“ค์ด fail๋์Šต๋‹ˆ๋‹ค.
์–ด์ฉ” ์ˆ˜ ์—†์ด PKDBSVR02์„œ๋ฒ„๋กœ ๊ทธ๋ฃน ์˜จ๋ผ์ธ์„ ํ•˜์˜€๊ณ  ํ˜„์žฌ ์„œ๋น„์Šค๋Š” ์ •์ƒ์ด๋‚˜ 3์ผ 09์‹œ53๋ถ„ ๋ถ€ํ„ฐ 5์ผ 15์‹œ29๋ถ„ ๊นŒ์ง€์˜ ๋ฐ์ดํ„ฐ๊ฐ€ ๋ชจ๋‘ ๋‚ ๋ผ๊ฐ”์Šต๋‹ˆ๋‹คย 

CAUSE
1. Resource Group ์€ 11/3 09์‹œ 55๋ถ„๊ฒฝ์— PKDBSVR02 ์„œ๋ฒ„๊ฐ€ ๋ฆฌ๋ถ€ํŒ…๋˜์–ด, PKDBSVR02-1 ๋กœ failover ๋˜๊ณ , ์ •์ƒ ์šด์˜ ๋จ.
2. PKDBSVR02 ์„œ๋ฒ„๋Š” ๋ถ€ํŒ…ํ–ˆ์„ ๋‹น์‹œ, MCCS ์˜ ๋‘ ๋…ธ๋“œ๋Š” ์ •์ƒ join ์„ ํ•˜์ง€ ๋ชปํ•จ
3. PKDBSVR02 ์„œ๋ฒ„๊ฐ€ ๋ฆฌ๋ถ€ํŒ… ํ•˜๊ณ  ๋‚˜์„œ, DK์—์„œ Source ์ƒํƒœ๋กœ ์˜ฌ๋ผ์˜ด. (Event log๊ฐ€ ํ™•์ธ๋˜์ง€ ์•Š์•„, MCCS Log ์ƒ์œผ๋กœ๋งŒ ๋ถ„์„)
4. 11/5 MCCS console ์ ‘์†์ด ๋˜์ง€ ์•Š์•„, ์–‘ ์„œ๋ฒ„ MCCS agent ์žฌ์‹œ์ž‘
5. MCCS agent ์žฌ์‹œ์ž‘ ๋˜๋ฉด์„œ, Mirror ์ƒํƒœ๊ฐ€ ์–‘ ๋…ธ๋“œ์—์„œ source ๋กœ ์ธ์‹๋˜๊ณ , MCCS ๊ตฌ๋™ ๋กœ์ง(targetnodelist์˜ ์šฐ์„ ์ˆœ์œ„์— ์˜ํ•ด, source-target ๋ณ€๊ฒฝ)์— ์˜ํ•ด์„œ, PKDBSVR02-1 ๋…ธ๋“œ์˜ Mirror role ์ด target์œผ๋กœ ๋ณ€๊ฒฝ๋จ
6. PKDBSVR02-1 ๋…ธ๋“œ์—์„œ ์šด์˜ ์ค‘์ธ MSSQLSERVER ๋ฐ SQLSERVERAGENT ๋ฆฌ์†Œ์Šค๊ฐ€ volume D์— Access ํ•˜์ง€ ๋ชปํ•˜๋ฏ€๋กœ fail ๋ฐœ์ƒํ•จ.ย 



SOLUTION
MCCS 3.5.2 Fixed

ย