You running a Production database in No Archivelog mode without any backup
is like driving in the drak tying a Black clot across your eyes...


So in that case if it had not been the System Tablespace he could have used
certain pkgs to get at the corrupt blocks and try to reenter the data in
them.

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: zax zax [mailto:[Email Address Removed]
Sent: Tuesday, April 30, 2002 12:49 PM
To: Ganesh Raja
Subject: RE: ORA-01578


what if i don't have a backup, and the database is not
in archive mode ?



--- Ganesh Raja <[Email Address Removed] wrote:
> 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] Sent: 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] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit 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] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit 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] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit 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
>


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