This forum is currently locked. You can't register or post questions at this time. (read more)

Thread/block error when opening Oracle 9i database

All posts relating to Oracle database administration.

Moderator: Tim...

Guest

Thread/block error when opening Oracle 9i database

Postby Guest » Mon Nov 01, 2004 6:09 pm

Hi,

When I try to open the Oracle 9.2.0.1.0 database, I get the following error:

ORA-01172: recovery of Thread 1 stuck at block 105 of file 2
ORA-01151: use media recovery to recover block, restore backup if needed.

I am able to mount the database but not open it.

Any help would be appreciated.

Thanks,

Jignesh.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

RE:Thread/block error when opening Oracle 9i database

Postby Tim... » Mon Nov 01, 2004 6:09 pm

Hi.

Do what the message says! Either restore the whole file from a backup ans recover it or do a block media recovery. The database will not open until this is done.

Alternatively, if file 2 is a non-system datafile you may be able to offline it and start the database, but the recovery will have to happen before the datafile can be onlined.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 10 guests

cron