Home » RDBMS Server » Backup & Recovery » ORA-01033: Recovering database (Windows-XP, Oracle 10g)
ORA-01033: Recovering database [message #471065] Thu, 12 August 2010 02:23 Go to next message
lokimisc
Messages: 72
Registered: February 2008
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 Go to previous message
LKBrwn_DBA
Messages: 427
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

Previous Topic: open resetlog
Next Topic: Flashback Database
Goto Forum:
  


Current Time: Tue Jul 29 02:09:44 CDT 2014

Total time taken to generate the page: 0.08741 seconds