檔案-ALERT檔案

oracle_db發表於2012-05-16
警告檔案作用--資料日記本
ALERT檔案長什麼樣，都記錄了什麼？
Wed May 16 19:33:55 2012
MMNL absent for 24030 secs; Foregrounds taking over
Wed May 16 19:34:39 2012
Starting background process EMN0
Wed May 16 19:34:40 2012
Shutting down instance: further logons disabled
EMN0 started with pid=19, OS id=25485
Wed May 16 19:34:40 2012
Stopping background process MMNL
Wed May 16 19:34:40 2012
Stopping background process CJQ0
Wed May 16 19:34:41 2012
Stopping background process MMON
Wed May 16 19:34:42 2012
Shutting down instance (immediate)
License high water mark = 2
All dispatchers and shared servers shutdown
Wed May 16 19:34:53 2012
ALTER DATABASE CLOSE NORMAL
Wed May 16 19:34:53 2012
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed May 16 19:34:53 2012
PMON failed to acquire latch, see PMON dump
Wed May 16 19:34:53 2012
Shutting down archive processes
Archiving is disabled
Wed May 16 19:35:03 2012
ARCH shutting down
ARC0: Archival stopped
Wed May 16 19:35:03 2012
ARC1: Becoming the heartbeat ARCH
ARC1: Archiving disabled
ARCH shutting down
ARC1: Archival stopped
Wed May 16 19:35:04 2012
Thread 1 closed at log sequence 12
Successful close of redo thread 1
Wed May 16 19:35:04 2012
Completed: ALTER DATABASE CLOSE NORMAL
Wed May 16 19:35:04 2012
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
Wed May 16 19:35:54 2012
Starting ORACLE instance (normal)
Cannot determine all dependent dynamic libraries for /proc/self/exe
Unable to find dynamic library libocr10.so in search paths
RPATH = /ade/aime1_build2101/oracle/has/lib/:/ade/aime1_build2101/oracle/lib/:/ade/aime1_build2101/oracle/has/lib/:
LD_LIBRARY_PATH is not set!
The default library directories are /lib and /usr/lib
Unable to find dynamic library libocrb10.so in search paths
Unable to find dynamic library libocrutl10.so in search paths
Unable to find dynamic library libocrutl10.so in search paths
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 155189248
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  sga_target               = 444596224
  control_files            = /u01/oradata/dbtest/control01.ctl, /u01/oradata/dbtest/control02.ctl, /u01/oradata/dbtest/control03.ctl
  db_block_size            = 8192
  __db_cache_size          = 276824064
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = /u01/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=dbtestXDB)
  job_queue_processes      = 0
  background_dump_dest     = /u01/admin/dbtest/bdump
  user_dump_dest           = /u01/admin/dbtest/udump
  core_dump_dest           = /u01/admin/dbtest/cdump
  audit_file_dest          = /u01/admin/dbtest/adump
  sort_area_size           = 65536
  db_name                  = dbtest
  open_cursors             = 300
  pga_aggregate_target     = 147849216
  aq_tm_processes          = 0
PMON started with pid=2, OS id=25521
MMAN started with pid=4, OS id=25525
PSP0 started with pid=3, OS id=25523
DBW0 started with pid=5, OS id=25527
LGWR started with pid=6, OS id=25529
CKPT started with pid=7, OS id=25531
SMON started with pid=8, OS id=25533
RECO started with pid=9, OS id=25535
MMON started with pid=10, OS id=25537
Wed May 16 19:35:56 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
MMNL started with pid=11, OS id=25539
Wed May 16 19:35:57 2012
ALTER DATABASE   MOUNT
Wed May 16 19:36:01 2012
Setting recovery target incarnation to 4
Wed May 16 19:36:01 2012
Successful mount of redo thread 1, with mount id 1176343197
Wed May 16 19:36:01 2012
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Wed May 16 19:36:01 2012
ALTER DATABASE OPEN
Wed May 16 19:36:02 2012
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=15, OS id=25548
Wed May 16 19:36:02 2012
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=16, OS id=25550
Wed May 16 19:36:02 2012
ARC0: STARTING ARCH PROCESSES
Wed May 16 19:36:02 2012
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Wed May 16 19:36:02 2012
Thread 1 opened at log sequence 12
  Current log# 3 seq# 12 mem# 0: /u01/oradata/dbtest/redo03.log
Successful open of redo thread 1
Wed May 16 19:36:02 2012
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed May 16 19:36:02 2012
SMON: enabling cache recovery
Wed May 16 19:36:03 2012
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=17, OS id=25552
Wed May 16 19:36:03 2012
Successfully onlined Undo Tablespace 1.
Wed May 16 19:36:03 2012
SMON: enabling tx recovery
Wed May 16 19:36:03 2012
Database Characterset is AL32UTF8
replication_dependency_tracking turned off (no async multimaster replication found)
WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.
Wed May 16 19:36:05 2012
db_recovery_file_dest_size of 2048 MB is 40.33% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed May 16 19:36:06 2012
Completed: ALTER DATABASE OPEN
Wed May 16 19:36:06 2012
Starting background process CJQ0
CJQ0 started with pid=20, OS id=25559

前半部分是關閉時的日誌，後半部分是啟動資料庫時候產生的日誌

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/15720542/viewspace-729955/，如需轉載，請註明出處，否則將追究法律責任。

相關文章