情景描述:
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
..........
请大伙帮我看看是什么问题,数据库是否正在恢复,怎样查看还得多久才能恢复完成?谢谢了