数据库进行了shutdown abort操作后，重启至mount，然后进行redo scan，再然后alert日志中出现
Sat Aug 10 04:59:55 2013
Errors in file /opt/oracle/diag/rdbms/uniondb/uniondb/trace/uniondb_m000_6120.trc:
ORA-01155: 正在打开, 关闭, 装载或卸装数据库每隔大约15分钟出现一次，无论是alter database open，还是直接startup 都会出现该问题
现在十分着急，希望各位大大们能帮个忙oracle 11.2.0.1
sun 10 sparc/opt/oracle/diag/rdbms/uniondb/uniondb/trace/uniondb_m000_6120.trcTrace file /opt/oracle/diag/rdbms/uniondb/uniondb/trace/uniondb_m000_6120.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /opt/oracle/product/11.2.0/uniondb
System name: SunOS
Node name: m501
Release: 5.10
Version: Generic_144488-04
Machine: sun4u
Instance name: uniondb
Redo thread mounted by this instance: 1
Oracle process number: 98
Unix process pid: 6120, image: oracle@m501 (M000)
*** 2013-08-10 04:59:55.273
*** SESSION ID819.117) 2013-08-10 04:59:55.273
*** CLIENT ID) 2013-08-10 04:59:55.273
*** SERVICE NAME:() 2013-08-10 05:39:31.143
*** MODULE NAME:(MMON_SLAVE) 2013-08-10 05:39:31.143
*** ACTION NAME:(Monitor FRA Space) 2013-08-10 05:39:31.143 ORA-01155: 正在打开, 关闭, 装载或卸装数据库
在线等~
Sat Aug 10 04:59:55 2013
Errors in file /opt/oracle/diag/rdbms/uniondb/uniondb/trace/uniondb_m000_6120.trc:
ORA-01155: 正在打开, 关闭, 装载或卸装数据库每隔大约15分钟出现一次，无论是alter database open，还是直接startup 都会出现该问题
现在十分着急，希望各位大大们能帮个忙oracle 11.2.0.1
sun 10 sparc/opt/oracle/diag/rdbms/uniondb/uniondb/trace/uniondb_m000_6120.trcTrace file /opt/oracle/diag/rdbms/uniondb/uniondb/trace/uniondb_m000_6120.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /opt/oracle/product/11.2.0/uniondb
System name: SunOS
Node name: m501
Release: 5.10
Version: Generic_144488-04
Machine: sun4u
Instance name: uniondb
Redo thread mounted by this instance: 1
Oracle process number: 98
Unix process pid: 6120, image: oracle@m501 (M000)
*** 2013-08-10 04:59:55.273
*** SESSION ID819.117) 2013-08-10 04:59:55.273
*** CLIENT ID) 2013-08-10 04:59:55.273
*** SERVICE NAME:() 2013-08-10 05:39:31.143
*** MODULE NAME:(MMON_SLAVE) 2013-08-10 05:39:31.143
*** ACTION NAME:(Monitor FRA Space) 2013-08-10 05:39:31.143 ORA-01155: 正在打开, 关闭, 装载或卸装数据库
在线等~
刚刚做了一个oradebug，发现被所有的进程都被该进程阻塞
oracle 3085 1 0 04:29:50 ? 0:01 ora_ckpt_uniondboradebug报告
[241]/1/242/3/20f10b9af0/3760/NLEAF/[456]
[265]/1/266/3/20c109d1b0/3762/NLEAF/[456]
[289]/1/290/3/21710c0420/3764/NLEAF/[456]
[313]/1/314/3/20d10bc760/3766/NLEAF/[456]
[337]/1/338/3/20a10d9300/3770/NLEAF/[456]
[361]/1/362/5/20e10c41a0/3772/NLEAF/[456]
[385]/1/386/3/20b114f348/3774/NLEAF/[456]
[409]/1/410/3/20f10ffab0/3776/NLEAF/[456]
[433]/1/434/3/20c10e3170/3778/NLEAF/[456]
[456]/1/457/1/20f1114148/3085/LEAF/
为什么ckpt会导致数据库hang住呢？