文件-ALERT文件

警告文件作用--数据日记本

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15720542/viewspace-729955/