oracle数据库的open,数据库无法open - Oracle数据库管理 - ITPUB论坛-中国专业的IT技术社区...

情景描述:

1、首先执行shutdown immediate ,无法关闭

2、执行了shutdown abort 正常关闭

3、执行startup ,数据库一直处于mount状态,如下:

SQL> startup

ORACLE instance started.

Total System Global Area 5368709120 bytes

Fixed Size                  2028456 bytes

Variable Size            3338669144 bytes

Database Buffers         2013265920 bytes

Redo Buffers               14745600 bytes

Database mounted.

4、查看alert日志,发现数据库在做恢复,详细信息如下:

........

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

MMNL started with pid=12, OS id=192976

Tue Aug 18 11:05:25 2009

starting up 1 shared server(s) ...

Tue Aug 18 11:05:28 2009

ALTER DATABASE   MOUNT

Tue Aug 18 11:05:33 2009

Setting recovery target incarnation to 2

Tue Aug 18 11:05:33 2009

Successful mount of redo thread 1, with mount id 3804362616

Tue Aug 18 11:05:33 2009

Database mounted in Exclusive Mode

Completed: ALTER DATABASE   MOUNT

Tue Aug 18 11:05:33 2009

ALTER DATABASE OPEN

Tue Aug 18 11:05:33 2009

Beginning crash recovery of 1 threads

parallel recovery started with 7 processes

Tue Aug 18 11:05:35 2009

Started redo scan

Tue Aug 18 11:05:43 2009

Completed redo scan

184664 redo blocks read, 109154 data blocks need recovery

Tue Aug 18 11:07:04 2009

Started redo application at

Thread 1: logseq 3935, block 60011

Tue Aug 18 11:07:08 2009

Recovery of Online Redo Log: Thread 1 Group 1 Seq 3935 Reading mem 0

..........

请大伙帮我看看是什么问题,数据库是否正在恢复,怎样查看还得多久才能恢复完成?谢谢了