Home » RDBMS Server » Backup & Recovery » system datafile corrupted (Oracle,10g,Linux)
system datafile corrupted [message #400591] Wed, 29 April 2009 00:16 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,

I got ORA-27101: shared memory realm does not exist while accessing the database. After i have checked the alert_log file.It shows the below error

ORA-01578: ORACLE data block corrupted (file # 1, block # 60877)
ORA-01110: data file 1: '/data/opt/oracle/oradata/AFLSDBA2/system01.dbf'
Error 1578 happened during db open, shutting down database

I unable to log the sysdba also.

how to recover the system tablespace?

Thanks,
Michael.
Re: system datafile corrupted [message #400594 is a reply to message #400591] Wed, 29 April 2009 00:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
how to recover the system tablespace?

From your last backup.

Regards
Michel
Re: system datafile corrupted [message #400651 is a reply to message #400591] Wed, 29 April 2009 04:00 Go to previous message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
thanks a lot
Previous Topic: recover tablespace in noarchivemode
Next Topic: Data block change
Goto Forum:
  


Current Time: Fri Nov 22 07:55:05 CST 2024