文件-ALERT文件

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

ALERT文件长什么样，都记录了什么？

Wed May 16 19:33:55 2012MMNL absent for 24030 secs; Foregrounds taking overWed May 16 19:34:39 2012Starting background process EMN0Wed May 16 19:34:40 2012Shutting down instance: further logons disabledEMN0 started with pid=19, OS id=25485Wed May 16 19:34:40 2012Stopping background process MMNLWed May 16 19:34:40 2012Stopping background process CJQ0Wed May 16 19:34:41 2012Stopping background process MMONWed May 16 19:34:42 2012Shutting down instance (immediate)License high water mark = 2All dispatchers and shared servers shutdownWed May 16 19:34:53 2012ALTER DATABASE CLOSE NORMALWed May 16 19:34:53 2012SMON: disabling tx recoverySMON: disabling cache recoveryWed May 16 19:34:53 2012PMON failed to acquire latch, see PMON dumpWed May 16 19:34:53 2012Shutting down archive processesArchiving is disabledWed May 16 19:35:03 2012ARCH shutting downARC0: Archival stoppedWed May 16 19:35:03 2012ARC1: Becoming the heartbeat ARCHARC1: Archiving disabledARCH shutting downARC1: Archival stoppedWed May 16 19:35:04 2012Thread 1 closed at log sequence 12Successful close of redo thread 1Wed May 16 19:35:04 2012Completed: ALTER DATABASE CLOSE NORMALWed May 16 19:35:04 2012ALTER DATABASE DISMOUNTCompleted: ALTER DATABASE DISMOUNTARCH: Archival disabled due to shutdown: 1089Shutting down archive processesArchiving is disabledArchive process shutdown avoided: 0 activeARCH: Archival disabled due to shutdown: 1089Shutting down archive processesArchiving is disabledArchive process shutdown avoided: 0 activeWed May 16 19:35:54 2012Starting ORACLE instance (normal)Cannot determine all dependent dynamic libraries for /proc/self/exeUnable to find dynamic library libocr10.so in search pathsRPATH = /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/libUnable to find dynamic library libocrb10.so in search pathsUnable to find dynamic library libocrutl10.so in search pathsUnable to find dynamic library libocrutl10.so in search pathsLICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0Picked latch-free SCN scheme 2Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DESTAutotune of undo retention is turned on. IMODE=BRILAT =18LICENSE_MAX_USERS = 0SYS auditing is disabledksdpec: called for event 13740 prior to event group initializationStarting 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          = 0PMON started with pid=2, OS id=25521MMAN started with pid=4, OS id=25525PSP0 started with pid=3, OS id=25523DBW0 started with pid=5, OS id=25527LGWR started with pid=6, OS id=25529CKPT started with pid=7, OS id=25531SMON started with pid=8, OS id=25533RECO started with pid=9, OS id=25535MMON started with pid=10, OS id=25537Wed May 16 19:35:56 2012starting 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=25539Wed May 16 19:35:57 2012ALTER DATABASE   MOUNTWed May 16 19:36:01 2012Setting recovery target incarnation to 4Wed May 16 19:36:01 2012Successful mount of redo thread 1, with mount id 1176343197Wed May 16 19:36:01 2012Database mounted in Exclusive ModeCompleted: ALTER DATABASE   MOUNTWed May 16 19:36:01 2012ALTER DATABASE OPENWed May 16 19:36:02 2012LGWR: STARTING ARCH PROCESSESARC0 started with pid=15, OS id=25548Wed May 16 19:36:02 2012ARC0: Archival startedARC1: Archival startedLGWR: STARTING ARCH PROCESSES COMPLETEARC1 started with pid=16, OS id=25550Wed May 16 19:36:02 2012ARC0: STARTING ARCH PROCESSESWed May 16 19:36:02 2012ARC1: Becoming the 'no FAL' ARCHARC1: Becoming the 'no SRL' ARCHWed May 16 19:36:02 2012Thread 1 opened at log sequence 12  Current log# 3 seq# 12 mem# 0: /u01/oradata/dbtest/redo03.logSuccessful open of redo thread 1Wed May 16 19:36:02 2012MTTR advisory is disabled because FAST_START_MTTR_TARGET is not setWed May 16 19:36:02 2012SMON: enabling cache recoveryWed May 16 19:36:03 2012ARC2: Archival startedARC0: STARTING ARCH PROCESSES COMPLETEARC0: Becoming the heartbeat ARCHARC2 started with pid=17, OS id=25552Wed May 16 19:36:03 2012Successfully onlined Undo Tablespace 1.Wed May 16 19:36:03 2012SMON: enabling tx recoveryWed May 16 19:36:03 2012Database Characterset is AL32UTF8replication_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 2012db_recovery_file_dest_size of 2048 MB is 40.33% used. This is auser-specified limit on the amount of space that will be used by thisdatabase for recovery-related files, and does not reflect the amount ofspace available in the underlying filesystem or ASM diskgroup.Wed May 16 19:36:06 2012Completed: ALTER DATABASE OPENWed May 16 19:36:06 2012Starting background process CJQ0CJQ0 started with pid=20, OS id=25559

前半部分是关闭时的日志，后半部分是启动数据库时候产生的日志

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15720542/viewspace-729955/，如需转载，请注明出处，否则将追究法律责任。

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