Ganesh,

I do agree about the recover process. But I wanted him to find out what is
the object really affected.

Generally, if the system tablespace is corrupted, you should do full recover
from the last backup using roll forward.

==============


-----Original Message-----
From: Ganesh Raja [mailto:[Email Address Removed] Tuesday, April 30, 2002 5:29 PM
To: LazyDBA.com Discussion
Subject: RE: ORA-01578


Pramod,

I Feel the problem with zax is in the system tablespace. The best bet for
him would be to Restore a Cold backup and if running in archive log mode
roll the db forward to the current time.

HTH

Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
============================================
Live to learn... forget... and learn again.
============================================



-----Original Message-----
From: Pramod Gudula [mailto:[Email Address Removed]
Sent: Tuesday, April 30, 2002 12:08 PM
To: LazyDBA.com Discussion
Subject: RE: ORA-01578


Zax,

First find out which object is having problem.

Execute the below sql

The following query will tell you the object TYPE , OWNER and NAME of
a segment given the absolute file number "<AFN>" and block number "<BL>" of
the corrupt block - the database must be open in order to use this query:

SELECT tablespace_name, segment type, owner, segment_name
FROM dba_extents
WHERE file_id = <AFN>
and <BL> between block_id AND block_id + blocks - 1
;

in your case, AFN=1 and BL=37749


-----Original Message-----
From: zax zax [mailto:[Email Address Removed] Tuesday, April 30, 2002 4:51 PM
To: LazyDBA.com Discussion
Subject: ORA-01578


Hi All,
i got this msg , any help ?

ERROR:
ORA-01578: ORACLE data block corrupted (file # 1,
block # 37749)
ORA-01110: data file 1:
'E:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF'

zax

__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page