| Oracle Startup/Shutdown in progress Error [message #124769] |
Tue, 21 June 2005 06:44  |
HABIB MEMON
Messages: 5
Registered: September 2004
|
Junior Member |
|
|
Hi
im using Oracle 9i Ver: 9.0.1.0.1 on win2k pro platform.
Last day i run SQL Loader for loading data of apporx 1.93 GB into various tables and suddenly power failure occurs and at next startup i met following error:
Ora-01033: Oracle initialization or shutdown in progress..
for its solution i checked user dump files n found that due to following errors the above error is coming:
ORA-00396: error 397 required fallback to single-pass recovery
ORA-00397: lost write detected for file 2, block 214364
please help me out for rectification of all this
Thanx
Habib
Note: Trace File is attached for diagnosis.
-
Attachment: ORA01044.TRC
(Size: 1.26KB, Downloaded 1090 times)
|
|
|
|
| Re: Oracle Startup/Shutdown in progress Error [message #124829 is a reply to message #124769] |
Tue, 21 June 2005 13:56  |
vadlamani
Messages: 39
Registered: November 2003
|
Member |
|
|
After the system is turned on, the oracle need instance recovery & it is done automatically by oracle and the DB is opened anly after performing instance recovery. I think it is taking time to do the instance recovery and your are trying to connect before the database is opened.
Wait for some time & try connecting again......
Thanks
Satish
|
|
|
|
| Re: Oracle Startup/Shutdown in progress Error [message #124881 is a reply to message #124829] |
Wed, 22 June 2005 00:55 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Hi
Description for Error ORA-00397 :
ORA-00397: lost write detected for file string, block string
Cause: The specified block is missing changes that should have been written to disk, indicating a lost write by the file I/O subsystem or volume manager.
Action: Run diagnostic checks on the I/O subsystem and resolve any errors
This is eveident from the trace file as well. The file indicates:
*** SESSION ID:(7.1) 2005-06-18 08:40:55.000
Evaluating checkpoint for thread 1 sequence 204 block 43297
Last entry: afn = 2, blk = 214364, ver = 0x0000.0029cd45.02
Disk version = 0x0000.00000000.01
ORA-00396: error 397 required fallback to single-pass recovery
ORA-00397: lost write detected for file 2, block 214364
*** 2005-06-18 08:41:02.000
RECOVERY OF THREAD 1 STUCK AT BLOCK 214364 OF FILE 2
The reason for this might be block corruption on your hdd. Now, as advised in Actions, pls do run diagnostic check on I/O system before continuing.
Regds
Girish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
