[DB] oracle 경고 로그 파일 (alert_$SID.log)

오라클의 alert (경고 로그) 로그 파일
SQL> show parameter background_dump_dest                       

NAME                              TYPE      VALUE
------------------------- -------- --------------------------------------------
background_dump_dest      string      /oracle/ora9i/app/oracle/admin/DB09/bdump

보통 기본 설정시 $ORACLE_BASE/admin/$SID/bdump 디렉토리에 alert_$SID.log 형태로 저장된다.

sqlplus 접속시에는 로그가 남지 않는거 같다. start / shutdown / error 나 warring 발생시에 나오는듯 하다.

startup 시 alert 로그 내용이다

Tue May 25 19:52:09 2010 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 SCN scheme 2 Using log_archive_dest parameter default value LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 9.2.0.4.0. System parameters with non-default values:   processes                = 150   timed_statistics         = TRUE   shared_pool_size         = 83886080   large_pool_size          = 16777216   java_pool_size           = 83886080   control_files         = /oracle/ora9i/app/oracle/oradata/DB09/control01.ctl,                                /oracle/ora9i/app/oracle/oradata/DB09/control02.ctl,                               /oracle/ora9i/app/oracle/oradata/DB09/control03.ctl   db_block_size            = 8192   db_cache_size            = 33554432   compatible               = 9.2.0.0.0   db_file_multiblock_read_count= 16   fast_start_mttr_target   = 300   undo_management          = AUTO   undo_tablespace          = UNDOTBS1   undo_retention           = 10800   remote_login_passwordfile= EXCLUSIVE   db_domain                =   instance_name            = DB09   dispatchers              = (PROTOCOL=TCP) (SERVICE=DB09XDB)   job_queue_processes      = 10   hash_join_enabled        = TRUE   background_dump_dest     = /oracle/ora9i/app/oracle/admin/DB09/bdump   user_dump_dest           = /oracle/ora9i/app/oracle/admin/DB09/udump   core_dump_dest           = /oracle/ora9i/app/oracle/admin/DB09/cdump   sort_area_size           = 524288   db_name                  = DB09   open_cursors             = 300   star_transformation_enabled= FALSE   query_rewrite_enabled    = FALSE   pga_aggregate_target     = 25165824   aq_tm_processes          = 1 PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 CJQ0 started with pid=8 QMN0 started with pid=9 Tue May 25 19:52:10 2010 starting up 1 shared server(s) ... starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Tue May 25 19:52:10 2010 ALTER DATABASE   MOUNT Tue May 25 19:52:14 2010 Successful mount of redo thread 1, with mount id 373679402. Tue May 25 19:52:14 2010 Database mounted in Exclusive Mode. Completed: ALTER DATABASE   MOUNT Tue May 25 19:52:14 2010 ALTER DATABASE OPEN Tue May 25 19:52:14 2010 Thread 1 opened at log sequence 2   Current log# 1 seq# 2 mem# 0: /oracle/ora9i/app/oracle/oradata/DB09/redo01.log Successful open of redo thread 1. Tue May 25 19:52:14 2010 SMON: enabling cache recovery Tue May 25 19:52:15 2010 Undo Segment 1 Onlined Undo Segment 2 Onlined Undo Segment 3 Onlined Undo Segment 4 Onlined Undo Segment 5 Onlined Undo Segment 6 Onlined Undo Segment 7 Onlined Undo Segment 8 Onlined Undo Segment 9 Onlined Undo Segment 10 Onlined Successfully onlined Undo Tablespace 1. Tue May 25 19:52:15 2010 SMON: enabling tx recovery Tue May 25 19:52:15 2010 Database Characterset is KO16KSC5601 replication_dependency_tracking turned off (no async multimaster replication found) Completed: ALTER DATABASE OPEN

shutdown immediate 시의 alert 로그 이다.

Tue May 25 19:52:56 2010 Shutting down instance: further logons disabled Shutting down instance (immediate) License high water mark = 3 All dispatchers and shared servers shutdown Tue May 25 19:53:00 2010 ALTER DATABASE CLOSE NORMAL Tue May 25 19:53:00 2010 SMON: disabling tx recovery SMON: disabling cache recovery Tue May 25 19:53:00 2010 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Thread 1 closed at log sequence 2 Successful close of redo thread 1. Tue May 25 19:53:00 2010 Completed: ALTER DATABASE CLOSE NORMAL Tue May 25 19:53:00 2010 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active

위 내용은 내가 vmware 에서 오라클을 설치후 테스트를 하던 중에 생각나서 확인해본 내용이다. 먼가 설정값이 변경 됬을수도 있지만 기본적인것으로 대충 이해하자.