Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database Startup taking sooo long

Beauty_and_dBestNov 9 2016 — edited Nov 11 2016

Hi ALL,

11gR2,

I am starting our database at it is taking so long

What could be the problem? Do I need to shutdown abort and start? I remember aborting before and it started fast after.

Starting the database APR ...

SQL*Plus: Release 11.2.0.3.0 Production on Wed Nov 9 16:54:21 2016

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 2137886720 bytes

Fixed Size 2230072 bytes

Variable Size 570427592 bytes

Database Buffers 1543503872 bytes

Redo Buffers 21725184 bytes

Database mounted.

(hanging)

I also check the alert long and it got stuck on this part:

Completed redo scan

read 831102 KB redo, 83706 data blocks need recovery

Wed Nov 09 16:57:57 2016

Started redo application at

Thread 1: logseq 72, block 80918

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

Mem# 0: /oracle/APR/db/apps_st/data/log02a.dbf

Mem# 1: /oracle/APR/db/apps_st/data/log02b.dbf

Wed Nov 09 16:58:07 2016

Completed redo application of 476.56MB

Please helpppp....

Kind regards,

This post has been answered by Gbenga Ajakaye on Nov 9 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 7 2016

Added on Nov 9 2016

#general-database-discussions

9 comments

3,616 views