RE: System tablespace corrupted

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Wed, 28 Jul 2004 21:05:31 -0400
Message-ID: <BAY2-F10i89QtpfTYSl0002d69a@hotmail.com>

Waleed
Thanks. Table name is

SQL> select count(*) from sys.RESOURCE_CONSUMER_GROUP$; select count(*) from sys.RESOURCE_CONSUMER_GROUP$

ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 1, block # 223) ORA-01110: data file 1: 'F:\ORACLE\ORADATA\CBS\SYSTEM01.DBF'

Regards
Rafiq

From: "Khedr, Waleed" <Waleed.Khedr_at_FMR.COM> Reply-To: oracle-l_at_freelists.org
To: <oracle-l_at_freelists.org>
Subject: RE: System tablespace corrupted Date: Wed, 28 Jul 2004 20:22:45 -0400

What is the table name?

-----Original Message-----

From: M Rafiq [mailto:rafiq9857_at_hotmail.com]=20 Sent: Wednesday, July 28, 2004 8:18 PM
To: oracle-l_at_freelists.org
Subject: System tablespace corrupted

Env: Windows 2000 SP 4 Oracle 9.2.0.5

While exporting full database, it was observed that there is 1 block is=20 corrupted and other is fractured as per dbv. After checking it was tracked=20
as a sys.table. dbinv alos points that corrupt block due media failure. SA=20
ran Compaq provided utility which says no corruption of media.

Database is a development instance and no archive on. Simple way to restore=20
complete database from cold backup of previous week.

Is there any other way to recover the table completely. DBMS_REPAIR package=20
does not look to work for complete recovery. Full export hanging after=20 generating errors for that block.

Regards
Rafiq

Planning a family vacation? Check out the MSN Family Travel guide!=20 http://dollar.msn.com

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


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

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

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


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

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

MSN Toolbar provides one-click access to Hotmail from any Web page – FREE download! http://toolbar.msn.click-url.com/go/onm00200413ave/direct/01/

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Wed Jul 28 2004 - 20:02:01 CDT