Re: HELP! Can I recover from this?

Tim

It appears that you have a block corruption in your 'SYSTEM' tablespace. I say SYSTEM because your FileID# is 1. You should be able to get more information in your trace files. Try identifying your data block 1st.

TO give you an example, consider the following trace message.

Corrupt block=28000221 file=1. blocknum=221 found during buffer read on disk type=0. ver=1. dba=0 inc=0 seq=0 incseq=0 Thu Nov 26 15:21:40 1992
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [3339], [0], [671089185], [], [], []

To find out which table and data was affected run,

select * from dba_extents where file_id = 1 and block_id <= 545
and 545<block_id+blocks

Why 545 you ask? That is the block_id in decimal. Its hex value is 221 which is the last 4 digits of the block value above (28000221).

Find out if the block contains an index or table data. If index, just drop and recreate it. If table, need to drop and rebuild it with data.

As a last resort,

1.  Identify the level of damage ie the table(s) involved.
2.  Export your data
3.  Rebuild your database 
4.  Import your data.

I hope this is of some help.

ta
tony

-- 
 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  _        /_ __ /       |Colonial Mutual Invest Mgmt,Aust (ACN004021809)
 /(_)/ )(_/ \_/(///(/_)/_(   |EMAIL: TJambu_at_cmutual.com.au
 \_______/                   |PHONE: +61-3-2831639       FAX: +61-3-2831090