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

Mon May 12 23:06:00 BEIST 2014
Thread 1 advanced to log sequence 1034 (LGWR switch)
  Current log# 2 seq# 1034 mem# 0: /oradata/orcl/redo02.log
Mon May 12 23:06:48 BEIST 2014
Starting control autobackup
Control autobackup written to DISK device
 handle '/oradata/rmanbak/ctl_c-1320042450-20140512-00'
Tue May 13 11:21:44 BEIST 2014
Thread 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 2014
Detected change in CPU count to 6 ----->注意此处cpu_count变成6个
Tue May 13 18:26:42 BEIST 2014
RM cpu_count => Low Server Threshold (6) : High Server Threshold (8)----->注意此处:原本的cpu是8个
Tue May 13 19:53:06 BEIST 2014
Starting ORACLE instance (normal)
sskgpgetexecname failed to get name
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
IMODE=BR
ILAT =121
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.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     = 2147483648
MMAN started with pid=4, OS id=282922
PMON started with pid=2, OS id=159760
PSP0 started with pid=3, OS id=139482
DBW0 started with pid=5, OS id=233512
LGWR started with pid=6, OS id=131248
CKPT started with pid=7, OS id=233790
SMON started with pid=8, OS id=332064
RECO started with pid=9, OS id=204856
CJQ0 started with pid=10, OS id=340258
MMON started with pid=11, OS id=237598
Tue May 13 19:53:09 BEIST 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=258322
Tue May 13 19:53:09 BEIST 2014
starting up 1 shared server(s) ...
Tue May 13 19:53:11 BEIST 2014
ALTER DATABASE   MOUNT
Tue May 13 19:53:16 BEIST 2014
Setting recovery target incarnation to 1
Tue May 13 19:53:16 BEIST 2014
Successful mount of redo thread 1, with mount id 1375240744
Tue May 13 19:53:16 BEIST 2014
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Tue May 13 19:53:16 BEIST 2014
ALTER DATABASE OPEN
Tue May 13 19:53:16 BEIST 2014
Beginning crash recovery of 1 threads
 parallel recovery started with 5 processes
Tue May 13 19:53:17 BEIST 2014
Started redo scan
Tue May 13 19:53:17 BEIST 2014
Completed redo scan
 1290 redo blocks read, 345 data blocks need recovery
Tue May 13 19:53:17 BEIST 2014
Started redo application at
 Thread 1: logseq 1035, block 450056
Tue May 13 19:53:17 BEIST 2014
Recovery of Online Redo Log: Thread 1 Group 3 Seq 1035 Reading mem 0
  Mem# 0: /oradata/orcl/redo03.log
Tue May 13 19:53:17 BEIST 2014
Completed redo application
Tue May 13 19:53:18 BEIST 2014
Completed crash recovery at
 Thread 1: logseq 1035, block 451346, scn 133235449
 345 data blocks read, 345 data blocks written, 1290 redo blocks read
Tue May 13 19:53:19 BEIST 2014
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=21, OS id=311420
Tue May 13 19:53:19 BEIST 2014
ARC0: Archival started
ARC1 started with pid=22, OS id=467326
Tue May 13 19:53:19 BEIST 2014
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Tue May 13 19:53:19 BEIST 2014
Thread 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.log
Successful open of redo thread 1
Tue May 13 19:53:19 BEIST 2014
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue May 13 19:53:19 BEIST 2014
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Tue May 13 19:53:19 BEIST 2014
ARC0: Becoming the heartbeat ARCH
Tue May 13 19:53:19 BEIST 2014
SMON: enabling cache recovery
Tue May 13 19:53:23 BEIST 2014
Successfully onlined Undo Tablespace 1.
Tue May 13 19:53:23 BEIST 2014
SMON: enabling tx recovery
Tue May 13 19:53:23 BEIST 2014
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan 
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=24, OS id=319618
Tue May 13 19:53:28 BEIST 2014
Completed: ALTER DATABASE OPEN


 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值