朋友遇到物理备库出现了ALTER DATABASE OPEN
Thu Nov 10 10:38:12 2011
SMON: enabling cache recovery
Thu Nov 10 10:38:12 2011
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 32
Physical standby database opened for read only access.
Completed: ALTER DATABASE OPEN
Thu Nov 10 10:38:13 2011
ksvcreate: Process(m000) creation failed
Thu Nov 10 10:38:45 2011
ksvcreate: Process(m000) creation failed
Thu Nov 10 10:39:48 2011
ksvcreate: Process(m000) creation failed
Thu Nov 10 10:40:30 2011
Primary database is in MAXIMUM PERFORMANCE mode
RFS[31]: Successfully opened standby log 7: '/dev/rlvbuslog141'
Thu Nov 10 10:40:51 2011
ksvcreate: Process(m000) creation failed
Thu Nov 10 10:41:51 2011
ksvcreate: Process(m000) creation failed
Thu Nov 10 10:42:51 2011
ksvcreate: Process(m000) creation failed
Thu Nov 10 10:43:54 2011
ksvcreate: Process(m000) creation failed
Thu Nov 10 10:44:54 2011
ksvcreate: Process(m000) creation failed
Thu Nov 10 10:45:57 2011
ksvcreate: Process(m000) creation failed
Thu Nov 10 10:46:57 2011
ksvcreate: Process(m000) creation failed
Thu Nov 10 10:47:35 2011
Primary database is in MAXIMUM PERFORMANCE mode
RFS[61]: Successfully opened standby log 11: '/dev/rlvbuslog241'
Thu Nov 10 10:48:00 2011
ksvcreate: Process(m000) creation failed
Thu Nov 10 10:49:03 2011
ksvcreate: Process(m000) creation failed
Thu Nov 10 10:50:06 2011
ksvcreate: Process(m000) creation failed
Thu Nov 10 10:50:36 2011
在网上找到这个，还蛮一致，留下参考：

ksvcreate: Process(m000) creation failed，

网上各位大侠分析的原因可能有：

1、因为归档日志把磁盘写满导致MMON进程挂掉，然后awr报表不能自动收集的情况：http://zhang41082.itpub.net/post/7167/369161，这次看来还是这个awr的问题了。
 2、因为process参数设置太小导致不能创建新的进程，此数据库是一个dataguard，没有人会连上来的，而且process设置为600，ps -ef|wc -l返回的结果也只有不到160，看来不是这个问题了。

3、关键在这里：在metalink中，终于看到这又是一个bug，就是说如果物理的DATAGUARD经过多次OPEN READONLY之后，就会产生这个问题，晕，而且描述的版本正好是我的版本：10.2.0.2，这个bug要到11G才能修复。

此bug描述如下： 

Applies to:
Oracle Server - Enterprise Edition - Version: 10.2 to 10.2
This problem can occur on any platform.

Symptoms
Switching a Physical Standby Database multiple to READ ONLY Mode will report the following Errors in the ALERT.LOG:

ksvcreate: Process(m000) creation failed

Changes
Switch Physical Standby from READ ONLY to apply and back to READ ONLY.

Cause
The Cause of this Problem has been identified in Bug 5583049.

Solution
There are two Workarounds available:

Restart the Instance..
or
Disable ADDM - Should be re-enabled if Standby takes up the Primary Role
* Set SGA_TARGET=0 and set shared_pool_size, db_cache_size, etc if using
Automatic SGA Memory Management (ASMM)

* Set STATISTICS_LEVEL=BASIC to disable statistics gathering

最后重启实例后，问题解决。