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
- aix下cpu丢失2个时Oracle 数据库实例的alert报错
- Aix下启动/停止Oracle数据库实例
- Oracle同一个用户下启动多个数据库实例报错记录
- Aix 5.3下自动备份Oracle多个实例
- AIX下Oracle数据库的自动备份
- AIX启动oracle多个实例的方法
- AIX启动oracle多个实例的方法
- AIX下自动启动Oracle数据库与监听器的方法
- 运行ORACLE数据库的AIX Kernel CPU使用率高达40%的排查
- Oracle数据库实例在AIX 平台下使用大页内存(Large Page Memory)
- AIX下oracle的重新启动
- AIX下oracle数据库归档模式设置
- Aix下为Oracle数据库拓容
- 当有超过64个逻辑cpu时,Windows 下Oracle db 实例启动(startup)时会hang(挂起)
- AIX 5.3/6.1环境下安装Oracle 10gR2 RAC常见报错
- AIX 启动 ORACLE实例
- aix 10G RAC alert日志报错LMS 0: 8069 GCS shadows traversed, 4001 replayed
- AIX上ORACLE数据库的恢复
- 从零开始自学Swift(五)
- hdu 1113 Word Amalgamation
- 机器学习
- 经典的MapReduce单词技术程序
- MYSQL 命令
- aix下cpu丢失2个时Oracle 数据库实例的alert报错
- Skew Binary 1565 (简单数学)
- 【HDU4292】【1的限制建图】
- JNI(三)、java代码传递int、String、int[] 并 调用C 代码
- Android百度地图自定义覆盖物的灵活实现(有源码,调试成功)
- 处理样本分布不平衡,偏斜比较厉害的方法总结
- 多校联合第八场hdu5387Clock 最大公约数
- A. Vasya and Petya's Game(cf第一题)
- 黑马程序员——java基础知识篇——>异常总结