Instance startup&shutdown

▣ 현재 상태 확인

S SYS> select status from v$instance;

   

STATUS

------------------------

OPEN

   

   

▣ shutdown 명령의 종류

• Shutdown Abort : 강제 종료 => Buffer Cache가 저장되지 않고 날아감, Control File과 Datafile의 시간 정보 맞지 않을 수 있음
• Shutdown immediate : Checkpoint 만 실행 후 종료
• Shutdown transactional : 모든 commit이나 rollback 기다린 후 종료
• Shutdown : 모든 user가 종료할 때까지 기다렸다가 종료

   

▣ 상태 변경

- nomount -

S SYS> startup nomount

ORACLE instance started.

   

Total System Global Area 285212672 bytes

Fixed Size 1218992 bytes

Variable Size 100664912 bytes

Database Buffers 180355072 bytes

Redo Buffers 2973696 bytes

   

- mount -

S SYS> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

S SYS> startup mount

ORACLE instance started.

   

Total System Global Area 285212672 bytes

Fixed Size 1218992 bytes

Variable Size 100664912 bytes

Database Buffers 180355072 bytes

Redo Buffers 2973696 bytes

Database mounted.

S SYS> @status

   

STATUS

------------

MOUNTED

   

- open -

S SYS> startup

ORACLE instance started.

   

Total System Global Area 285212672 bytes

Fixed Size 1218992 bytes

Variable Size 100664912 bytes

Database Buffers 180355072 bytes

Redo Buffers 2973696 bytes

Database mounted.

Database opened.

 

※ 참고 : 만약 현재 상태가 mount 상태이면 alter database open; 명령으로 open 시킨다