Re: No recovery situation

From: <Riyaj_Shamsudeen_at_i2.com>
Date: Tue, 13 Feb 2001 09:48:01 -0800
Message-ID: <F001.002B2932.20010213071532@fatcity.com>

Hi

    How did you find you have corrupt blocks ? Did you have any ORA-1578 errors ? Any alert log messages for the same ?

    I would first find out which objects exist in that particular corrupted block (or ) alternatively you could analyze all the objects in the system tablespace like this.
set pages 0
spool /tmp/exec_as.sql
select 'analyze table '||owner||'.'||table_name||' validate structure cascade;'
from dba_tables
where tablespace_name='SYSTEM'
/
spool off
spool /tmp/exec_as1.out
@/tmp/exec_as.sql
spool off
spool /tmp/exec_as.sql
select 'analyze cluster '||owner||'.'||cluster_name||' validate structure cascad
e;'
from dba_clusters
where tablespace_name='SYSTEM'
/
spool off
spool /tmp/exec_as2.out
@/tmp/exec_as.sql
spool off

    If the corrupted object is an index, depending upon what index is corrupted, you could potentially drop and recreate the index..

Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies www.i2.com

                                                                                       
                       
                    Beatriz                                                            
                       
                    Martinez             To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>  
                    Jimenez              cc:                                           
                       
                    <beamar_at_cidau        Subject:     No recovery situation            
                       
                    t.es>                                                              
                       
                    Sent by:                                                           
                       
                    root_at_fatcity.                                                      
                       
                    com                                                                
                       
                                                                                       
                       
                                                                                       
                       
                    02/13/01                                                           
                       
                    06:30 AM                                                           
                       
                    Please                                                             
                       
                    respond to                                                         
                       
                    ORACLE-L                                                           
                       
                                                                                       
                       
                                                                                       
                       

Hello list,
I know that the answer to my question itīs going to be a negative one, but I have to try to do all that I can do. Until yesterday I was doing some attempt with an Oracle installation, without a backup copy. And, unfortunately, I had to format my computer (!!!).
Now I have the data associated with this installation, I could save the datafiles (*dbf). The database was in a non archivelog mode, and what is the worst thing of all, it had some corrupt blocks in the system.dbf file.
Could I do something with them, or are they totally unworhty? Could anybody give me an advice?
Maybe it would be easier for me to start from the beginning again.... A lot of thanks,

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Beatriz Martinez Jimenez
  INET: beamar_at_cidaut.es

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: Riyaj_Shamsudeen_at_i2.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Feb 13 2001 - 11:48:01 CST