Recently my machine got shut down because of some UPS failure, when I was in the middle of a transaction with Oracle 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