ORACLE Database / WAS (iAS) / SQL 자료실 - 포기하지 않으면 실패하지 않는다!
Vote Reply Modify Delete Forward Prev Next List

  Author   : 조성환 [ ladmin ] Vote: 2153, Modifies: 2, Hit: 7321, Lines: 85, Category: Etc.
Oracle database shutdown 시 alert log (내려가는 순서 확인)

/oracle/app/oracle/admin/CHUN/bdump/alert_CHUN.log 파일에 다음과 같이 로그가 떨어집니다.


참고로 내려가는 순서를 보시면 어떻게 DB shutdown 을 하는지 확인하실수 있습니다.



Shutting down archive processes

Fri Jan 26 19:06:49 2007
ARCH shutting down
ARC2: Archival stopped

Fri Jan 26 19:40:18 2007
Starting background process EMN0
EMN0 started with pid=58, OS id=1512

Fri Jan 26 19:40:18 2007
Shutting down instance: further logons disabled

Fri Jan 26 19:40:18 2007
Stopping background process CJQ0

Fri Jan 26 19:40:18 2007
Stopping background process QMNC

Fri Jan 26 19:40:20 2007
Stopping background process MMNL

Fri Jan 26 19:40:21 2007
Stopping background process MMON



Fri Jan 26 19:40:22 2007
Shutting down instance (immediate)
License high water mark = 77

Fri Jan 26 19:40:22 2007
Stopping Job queue slave processes

Fri Jan 26 19:40:22 2007
Job queue slave processes stopped

Fri Jan 26 19:40:32 2007
ALTER DATABASE CLOSE NORMAL

Fri Jan 26 19:40:32 2007
SMON: disabling tx recovery
SMON: disabling cache recovery

Fri Jan 26 19:40:32 2007
Shutting down archive processes
Archiving is disabled

Fri Jan 26 19:40:37 2007
ARCH shutting down
ARC1: Archival stopped

Fri Jan 26 19:40:42 2007
ARCH shutting down
ARC0: Archival stopped

Fri Jan 26 19:40:43 2007
Thread 1 closed at log sequence 121
Successful close of redo thread 1

Fri Jan 26 19:40:43 2007
Completed: ALTER DATABASE CLOSE NORMAL

Fri Jan 26 19:40:43 2007
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active


Prev: Oracle iAS Default Tunning (강추)
Next: 영문 증명서에 월 (Month) 이 한글로 나올때 (NLS_DATE_LANGUAGE)
2007/01/29(17:23) from 203.234.120.41
CrazyWWWBoard 2000

Vote Reply Modify Delete Forward Prev Next List
(c) Nobreak Technologies, Inc.