2013/10/11 WS1 memo

* shutdown (의option) - cpu resource 반환, mount 해제, 동기화후 종료, no more session

----정상종료----- consitent db , clean db -> no instance recovery

- normal 

- transactonal

: buffer cache => database(datafile)

: resource 반환

- immediate : rollback uncommited TXs 빠름

----비정상종료---  inconsistent db, dirty db, instance recovery(cache recovery) -> roll forward, rollback

- abort

:정전, system failure등으로인한.

:resouce 반환안됨

user process 가 비정상적으로 끝기면 pmon 은 server process 의 tx 를 rollback 후 종료시킨다

* open -> mount

alter database close normal

* mount -> nomount

alter database dismount

* nomount -> shutdown

shutdown

* start

startup pfile = '경로/이름'

startup restrict (mount/ nomount/ open)

 : 일반 user 의 접속을 차단(open 상태에서도)/ 원격지에서 관리자 접속 제한

* 제한모드를 푸는 방법

alter system disable restricted session