| ORA-01033: Recovering database [message #471065] |
Thu, 12 August 2010 02:23  |
lokimisc
Messages: 101
Registered: February 2008
|
Senior Member |
|
|
Hi,
I have 2 database running on my local DB ( Windows-XP, Oracle 10g ).
After abrupt shutdown of the system, one of my DB is throwing an error
ORA-01033 ORACLE initialization or shutdown in progress.
So I tried with below given things to recover DB
c:\sqlplus /nolog
SQL> connect sys as sysdba
SQL> shutdown
SQL> startup
It gave an error..
ORA-12528:TNS:Listener:All Appropriate instances are blocking new connections
SQL> select status from v$instance;
ORA-03114: not connected to ORACLE
So I tried stopping and restarting the Listener.
LSNRCTL> stop
LSNRCTL> start
Then again tried to startup the database
SQL> startup
ORA-01041: internal error. hostdef extension doesn't exist
/*
SQL> alter database mount;
SQL> alter database open;
*/
Alertlog file shows....
Recovery of Online Redo Log: Thread 1 Group 3 Seq 373 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\GALAXY\REDO03.LOG
Mon Aug 09 17:17:40 2010
Aborting crash recovery due to error 1115
Mon Aug 09 17:17:41 2010
Errors in file e:\oracle\product\10.2.0\admin\galaxy\udump\galaxy_ora_3152.trc:
ORA-01115: IO error reading block from file 3 (block # 51483)
ORA-01110: data file 3: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\GALAXY\SYSAUX01.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).
Can anyone please help me, in recovering the database.
Regards,
Lokesh
|
|
|
|
| Re: ORA-01033: Recovering database [message #471147 is a reply to message #471065] |
Thu, 12 August 2010 08:55  |
 |
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
|
Senior Member |
|
|
lokimisc wrote on Thu, 12 August 2010 03:23
Blah, blah, blah...
Mon Aug 09 17:17:40 2010
Aborting crash recovery due to error 1115
Mon Aug 09 17:17:41 2010
Errors in file e:\oracle\product\10.2.0\admin\galaxy\udump\galaxy_ora_3152.trc:
ORA-01115: IO error reading block from file 3 (block # 51483)
ORA-01110: data file 3: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\GALAXY\SYSAUX01.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).
Can anyone please help me, in recovering the database.
Seems to point to block corruption in the sysaux tablespace file.
Depending on the contents you had there, recovery could be as easy as drop/re-create the sysaux tablespace -- or -- Try repairing the block in error.
[Updated on: Thu, 12 August 2010 09:03] by Moderator Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
