OraFAQ Forum: Server Administration » ORA-1172 signalled during: alter database open

Home » RDBMS Server » Server Administration » ORA-1172 signalled during: alter database open

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-1172 signalled during: alter database open [message #174664]

Tue, 30 May 2006 04:18

habuhilal@hotmail.com
Messages: 2
Registered: May 2006

Junior Member

Dear All,
The foillowing error appears when I am trying to run my DB. ITs 8i db on windows 2000

This is the error appears in alert file:
--------------------------------------------
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 3 Seq 444 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
ORA-1172 signalled during: alter database open...

Attachment: orclALRT.LOG
(Size: 285.11KB, Downloaded 1155 times)

Report message to a moderator

Re: ORA-1172 signalled during: alter database open [message #174677 is a reply to message #174664]

Tue, 30 May 2006 05:00

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

01172, 00000, "recovery of thread %s stuck at block %s of file %s"
// *Cause: Crash recovery or instance recovery could not apply a change to a
//         block because it was not the next change. This can happen if the
//         block was corrupted and then repaired during recovery.
// *Action: Do a RECOVER DATAFILE for the file containing the block. If this
//         does not resolve the problem then restore the file from a backup
//         and  recover it.

Report message to a moderator

Re: ORA-1172 signalled during: alter database open [message #174993 is a reply to message #174677]

Wed, 31 May 2006 06:20

habuhilal@hotmail.com
Messages: 2
Registered: May 2006

Junior Member

This is not fixing the problem and I can't connect to the DB as internal

Report message to a moderator

Previous Topic:	installing oracle 9i r2 on fedora core 5
Next Topic:	internal error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:37:53 CDT 2024