摘要: 前几天一个朋友问了我一个问题。 说她在alert log里面看到了如下信息: Thread 1 cannot allocate new log, sequence 415 Private strand flush not complete Current log# 4 seq# 414 mem# 0: /dev/rora_redotb04 Thread 1 advanced to log sequence 415 Current log# 5 seq# 415 mem# 0: /dev/rora_redotb05 Thu Nov 11 16:01:51 2010我遇到的是:Checkpoi.. 阅读全文
posted @ 2010-11-17 17:39 davedba 阅读(176) 评论(0) 推荐(0)
摘要: 前几天一个朋友问了我一个问题。 说她在alert log里面看到了如下信息: Thread 1 cannot allocate new log, sequence 415 Private strand flush not complete Current log# 4 seq# 414 mem# 0: /dev/rora_redotb04 Thread 1 advanced to log sequence 415 Current log# 5 seq# 415 mem# 0: /dev/rora_redotb05 Thu Nov 11 16:01:51 2010我遇到的是:Checkpoi.. 阅读全文
posted @ 2010-11-17 17:39 davedba 阅读(196) 评论(0) 推荐(0)
摘要: Redo log 是用于恢复和一个高级特性的重要数据,一个redo条目包含了相应操作导致的数据库变化的所有信息,所有redo条目最终都要被写入redo文件中去。Redo log buffer是为了避免Redo文件IO导致性能瓶颈而在sga中分配出的一块内存。一个redo条目首先在用户内存(PGA)中产生,然后由oracle服务进程拷贝到log buffer中,当满足一定条件时,再由LGWR进程写入redo文件。 由于log buffer是一块“共享”内存,为了避免冲突,它是受到redo allocation latch保护的,每个服务进程需要先获取到该latch才能分配redo buffe.. 阅读全文
posted @ 2010-11-17 15:05 davedba 阅读(170) 评论(0) 推荐(0)
摘要: Redo log 是用于恢复和一个高级特性的重要数据,一个redo条目包含了相应操作导致的数据库变化的所有信息,所有redo条目最终都要被写入redo文件中去。Redo log buffer是为了避免Redo文件IO导致性能瓶颈而在sga中分配出的一块内存。一个redo条目首先在用户内存(PGA)中产生,然后由oracle服务进程拷贝到log buffer中,当满足一定条件时,再由LGWR进程写入redo文件。 由于log buffer是一块“共享”内存,为了避免冲突,它是受到redo allocation latch保护的,每个服务进程需要先获取到该latch才能分配redo buffe.. 阅读全文
posted @ 2010-11-17 15:05 davedba 阅读(195) 评论(0) 推荐(0)
摘要: 公司刚上线一套Oracle 11gR2 的RAC。 将MEMORY_TARGET内存设置为12G后,启动的时候报了错误: ORA-00845: MEMORY_TARGET not supported on this system00845, 00000, "MEMORY_TARGET not supported on this system"// *Cause: The MEMORY_TARGET parameter was not supported on this operating system or /dev/shm was not sized correctly 阅读全文
posted @ 2010-11-17 01:23 davedba 阅读(370) 评论(0) 推荐(0)
摘要: 公司刚上线一套Oracle 11gR2 的RAC。 将MEMORY_TARGET内存设置为12G后,启动的时候报了错误: ORA-00845: MEMORY_TARGET not supported on this system00845, 00000, "MEMORY_TARGET not supported on this system"// *Cause: The MEMORY_TARGET parameter was not supported on this operating system or /dev/shm was not sized correctly 阅读全文
posted @ 2010-11-17 01:23 davedba 阅读(221) 评论(0) 推荐(0)
摘要: How to Troubleshoot Grid Infrastructure Startup Issues [ID 1050908.1]Modified 11-OCT-2010Type HOWTOStatus PUBLISHEDIn this DocumentGoalSolutionStart up sequence:Cluster statusCase 1: OHASD.BIN does not startCase 2: OHASD Agents does not startCase 3: CSSD.BIN does not startCase 4: CRSD.BIN does not s 阅读全文
posted @ 2010-11-17 00:59 davedba 阅读(4459) 评论(0) 推荐(0)
摘要: How to Troubleshoot Grid Infrastructure Startup Issues [ID 1050908.1]Modified 11-OCT-2010Type HOWTOStatus PUBLISHEDIn this DocumentGoalSolutionStart up sequence:Cluster statusCase 1: OHASD.BIN does not startCase 2: OHASD Agents does not startCase 3: CSSD.BIN does not startCase 4: CRSD.BIN does not s 阅读全文
posted @ 2010-11-17 00:59 davedba 阅读(547) 评论(0) 推荐(0)
摘要: How to Proceed from Failed 11gR2 Grid Infrastructure (CRS) Installation [ID 942166.1]Modified 10-OCT-2010Type HOWTOStatus MODERATEDIn this DocumentGoalSolutionDeconfigure and Reconfigure of Standalone Server (Oracle Restart):Deinstall of Grid Infrastructure Standalone Server:Deconfigure and Reconfig 阅读全文
posted @ 2010-11-17 00:56 davedba 阅读(210) 评论(0) 推荐(0)
摘要: How to Proceed from Failed 11gR2 Grid Infrastructure (CRS) Installation [ID 942166.1]Modified 10-OCT-2010Type HOWTOStatus MODERATEDIn this DocumentGoalSolutionDeconfigure and Reconfigure of Standalone Server (Oracle Restart):Deinstall of Grid Infrastructure Standalone Server:Deconfigure and Reconfig 阅读全文
posted @ 2010-11-17 00:56 davedba 阅读(148) 评论(0) 推荐(0)