Recently my machine got shut down because of some UPS failure, when I was in the middle of a transaction with Oracle...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
10g. And when I restarted my machine and tried to log in, I got the "ORA-01033: Initialization or shut down in progress" error.
I googled regarding this and followed the steps given in the following sites ("Oracle Error and how to fix it (ORA-01033)" and "Getting ORA-01033 when logging in to 9i application") but nothing seems to be working!
This is my SQL trace when I tried to shut down and restart:
SQL> SHUTDOWN ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> STARTUP ORACLE instance started. Total System Global Area 171966464 bytes Fixed Size 787988 bytes Variable Size 145488364 bytes Database Buffers 25165824 bytes Redo Buffers 524288 bytes Database mounted. ORA-01115: IO error reading block from file 4 (block # 59449) ORA-01110: data file 4: 'D:DATABASESORACLE10GORADATAQRULESUSERS01.DBF' ORA-27070: async read/write failed OSD-04016: Error queuing an asynchronous I/O request. O/S-Error: (OS 23) Data error (cyclic redundancy check). SQL>
I absolutely have no idea what this says!
Can someone please let me know what exactly is happening here?? Thanks in advance!
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.continue reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.continue reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.