Database Backup and Recovery (MOSC)

MOSC Banner

corrupt datafile

edited May 24, 2012 3:15AM in Database Backup and Recovery (MOSC) 9 commentsAnswered
 Hello,

I have a corrupt datablock on the system tablespace.  I'm getting these errors:

ORA-05178: Oracle data block corrupted (file #1, block # 1391581)

  ORA-01110: data file1: '/ora1/oradata/xxxxx/system01.dbf

I've tried different things  in RMANsuch as

sql 'alter database datafile 1 offline'

restore datafile 1;

recvover datafile 1;

sql 'alter database datafile 1online;

 However, I think this method is assuming that the datafile in the RMAN backup is not corrupted.  This file/block has been corrupted for some time.  Do we need to find the backup without the corrupted file?  Or can this file be recreated?

thanks in advance.

Rae

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center