๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

Oracle Process2

[Oracle] Rollfoward & Rollback ์„œ๋ฒ„๊ฐ€ ๋น„์ •์ƒ์ ์œผ๋กœ ์ฃฝ์—ˆ์„ ๋•Œ, Checkpoint ํšŒ๋ณต Oracle startup Oracle ์„œ๋ฒ„๋ฅผ ๊ธฐ๋™ํ–ˆ์Šต๋‹ˆ๋‹ค. ์ด๋•Œ ์ˆœ์„œ๋Œ€๋กœ instance started - database mounted - database opened ์ˆœ์„œ๋กœ ์‹คํ–‰๋ฉ๋‹ˆ๋‹ค. instance started Oracle Instance์ธ SGA ๊ณต์œ  ๋ฉ”๋ชจ๋ฆฌ์™€ Background Process๋“ค์„ ๊ธฐ๋™ํ•ฉ๋‹ˆ๋‹ค. database mounted Control File์„ ์ฝ์„ ์ˆ˜ ์žˆ๋Š” ์ƒํƒœ๊ฐ€ mounted ์ž…๋‹ˆ๋‹ค. ์ด ๋‹จ๊ณ„์—์„œ ๋งŒ์•ฝ ์ „์— ์ •์ƒ์ ์œผ๋กœ ๋‚ด๋ ค๊ฐ€์ง€ ์•Š์•˜๋‹ค๋ฉด SMON Background Process๊ฐ€ Instance Recovery ์ž‘์—…์„ ํ•ฉ๋‹ˆ๋‹ค. Instance Recovery ์ž‘์—…์œผ๋กœ Rollfoward์™€ Rollback ์ž‘์—…์„ ํ•ฉ๋‹ˆ๋‹ค. database opened ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋ฅผ ์‚ฌ์šฉํ• .. 2020. 4. 4.
[Oracle] redo.log ์„œ๋ฒ„ ๋‚ด๋ถ€์  Log Switch ์ž‘๋™ ์›๋ฆฌ :: ๋งˆ์ด์ž๋ชฝ Redo Log Buffer Update ์ฐธ์กฐ๊ธ€ [Oracle] SGA Redo Log Buffer ๋ฆฌ๋‘ ๋ฒ„ํผ ์‚ฌ์šฉ์›๋ฆฌ :: ๋งˆ์ด์ž๋ชฝ Redo Log Buffer ์ด์ „ ๊ธ€๋“ค์—์„œ๋Š” Shared Pool๊ณผ Database Buffer Cache์— ๋Œ€ํ•ด์„œ ํ•˜๋‚˜์˜ SELECT๋ฌธ์„ ํ†ตํ•ด ์–ด๋–ค ์›๋ฆฌ๋กœ ์‚ฌ์šฉ๋˜๋Š”์ง€ ์•Œ์•„๋ดค์Šต๋‹ˆ๋‹ค. ์ด๋ฒˆ ๊ธ€์—์„œ๋Š” UPDATE๋ฌธ์„ ๊ฐ–๊ณ  ๋ณ€๊ฒฝ์‚ฌํ•ญ์ด ์žˆ์„ ๋•Œ Redo Log Bu.. myjamong.tistory.com redo.log ORACLE_BASE ์•„๋ž˜ oradata ๋””๋ ‰ํ† ๋ฆฌ๋ฅผ ๋ณด๋ฉด redo.log ํŒŒ์ผ๋“ค์ด ์žˆ์Šต๋‹ˆ๋‹ค. ์ด ํŒŒ์ผ๋“ค์€ Recovery ์ž‘์—…์„ ํ•˜๊ธฐ ์œ„ํ•ด Oracle์˜ Background Process์ธ LGWR(Log Writer)๊ฐ€ ์ˆ˜์‹œ๋กœ ์ž…๋ ฅํ•ด์ฃผ๊ณ  ์žˆ๋Š” ํŒŒ์ผ์ž…๋‹ˆ๋‹ค. Or.. 2020. 4. 2.