aix下cpu丢失2个时Oracle 数据库实例的alert报错

来源:互联网 发布:vmware12安装linux 编辑:程序博客网 时间:2024/05/22 15:07
Mon May 12 23:06:00 BEIST 2014Thread 1 advanced to log sequence 1034 (LGWR switch)  Current log# 2 seq# 1034 mem# 0: /oradata/orcl/redo02.logMon May 12 23:06:48 BEIST 2014Starting control autobackupControl autobackup written to DISK device handle '/oradata/rmanbak/ctl_c-1320042450-20140512-00'Tue May 13 11:21:44 BEIST 2014Thread 1 advanced to log sequence 1035 (LGWR switch)  Current log# 3 seq# 1035 mem# 0: /oradata/orcl/redo03.log ----->注意此处,没有关库的痕迹。Tue May 13 18:26:42 BEIST 2014Detected change in CPU count to 6 ----->注意此处cpu_count变成6个Tue May 13 18:26:42 BEIST 2014RM cpu_count => Low Server Threshold (6) : High Server Threshold (8)----->注意此处:原本的cpu是8个Tue May 13 19:53:06 BEIST 2014Starting ORACLE instance (normal)sskgpgetexecname failed to get nameLICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0Picked latch-free SCN scheme 3IMODE=BRILAT =121LICENSE_MAX_USERS = 0SYS auditing is disabledksdpec: called for event 13740 prior to event group initializationStarting up ORACLE RDBMS Version: 10.2.0.5.0.System parameters with non-default values:  processes                = 1000  sessions                 = 1105  sga_max_size             = 6442450944  __shared_pool_size       = 1140850688  __large_pool_size        = 16777216  __java_pool_size         = 33554432  __streams_pool_size      = 0  sga_target               = 6442450944  control_files            = /oradata/orcl/control01.ctl, /oradata/orcl/control02.ctl, /oradata/orcl/control03.ctl  db_block_size            = 8192  __db_cache_size          = 5234491392  compatible               = 10.2.0.5.0  log_archive_dest_1       = LOCATION=/oradata/arch  log_archive_format       = %t_%s_%r.dbf  db_file_multiblock_read_count= 16  db_recovery_file_dest    = /u01/app/oracle/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=orclXDB)  job_queue_processes      = 10  background_dump_dest     = /u01/app/oracle/admin/orcl/bdump  user_dump_dest           = /u01/app/oracle/admin/orcl/udump  core_dump_dest           = /u01/app/oracle/admin/orcl/cdump  audit_file_dest          = /u01/app/oracle/admin/orcl/adump  db_name                  = orcl  open_cursors             = 300  pga_aggregate_target     = 2147483648MMAN started with pid=4, OS id=282922PMON started with pid=2, OS id=159760PSP0 started with pid=3, OS id=139482DBW0 started with pid=5, OS id=233512LGWR started with pid=6, OS id=131248CKPT started with pid=7, OS id=233790SMON started with pid=8, OS id=332064RECO started with pid=9, OS id=204856CJQ0 started with pid=10, OS id=340258MMON started with pid=11, OS id=237598Tue May 13 19:53:09 BEIST 2014starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...MMNL started with pid=12, OS id=258322Tue May 13 19:53:09 BEIST 2014starting up 1 shared server(s) ...Tue May 13 19:53:11 BEIST 2014ALTER DATABASE   MOUNTTue May 13 19:53:16 BEIST 2014Setting recovery target incarnation to 1Tue May 13 19:53:16 BEIST 2014Successful mount of redo thread 1, with mount id 1375240744Tue May 13 19:53:16 BEIST 2014Database mounted in Exclusive ModeCompleted: ALTER DATABASE   MOUNTTue May 13 19:53:16 BEIST 2014ALTER DATABASE OPENTue May 13 19:53:16 BEIST 2014Beginning crash recovery of 1 threads parallel recovery started with 5 processesTue May 13 19:53:17 BEIST 2014Started redo scanTue May 13 19:53:17 BEIST 2014Completed redo scan 1290 redo blocks read, 345 data blocks need recoveryTue May 13 19:53:17 BEIST 2014Started redo application at Thread 1: logseq 1035, block 450056Tue May 13 19:53:17 BEIST 2014Recovery of Online Redo Log: Thread 1 Group 3 Seq 1035 Reading mem 0  Mem# 0: /oradata/orcl/redo03.logTue May 13 19:53:17 BEIST 2014Completed redo applicationTue May 13 19:53:18 BEIST 2014Completed crash recovery at Thread 1: logseq 1035, block 451346, scn 133235449 345 data blocks read, 345 data blocks written, 1290 redo blocks readTue May 13 19:53:19 BEIST 2014LGWR: STARTING ARCH PROCESSESARC0 started with pid=21, OS id=311420Tue May 13 19:53:19 BEIST 2014ARC0: Archival startedARC1 started with pid=22, OS id=467326Tue May 13 19:53:19 BEIST 2014ARC1: Archival startedLGWR: STARTING ARCH PROCESSES COMPLETETue May 13 19:53:19 BEIST 2014Thread 1 advanced to log sequence 1036 (thread open)Thread 1 opened at log sequence 1036  Current log# 1 seq# 1036 mem# 0: /oradata/orcl/redo01.logSuccessful open of redo thread 1Tue May 13 19:53:19 BEIST 2014MTTR advisory is disabled because FAST_START_MTTR_TARGET is not setTue May 13 19:53:19 BEIST 2014ARC1: Becoming the 'no FAL' ARCHARC1: Becoming the 'no SRL' ARCHTue May 13 19:53:19 BEIST 2014ARC0: Becoming the heartbeat ARCHTue May 13 19:53:19 BEIST 2014SMON: enabling cache recoveryTue May 13 19:53:23 BEIST 2014Successfully onlined Undo Tablespace 1.Tue May 13 19:53:23 BEIST 2014SMON: enabling tx recoveryTue May 13 19:53:23 BEIST 2014Database Characterset is ZHS16GBKOpening with internal Resource Manager plan replication_dependency_tracking turned off (no async multimaster replication found)Starting background process QMNCQMNC started with pid=24, OS id=319618Tue May 13 19:53:28 BEIST 2014Completed: ALTER DATABASE OPEN


 

0 0
原创粉丝点击