RE: System tablespace corrupted

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Wed, 28 Jul 2004 22:29:16 -0400
Message-ID: <42BBD772AC30EA428B057864E203C9991159BC@MSGBOSCLF2WIN.DMN1.FMR.COM>

It's not a critical table, and if you are not using consumers group it should have only (four rows):

OBJ# NAME MANDATORY CPU_METHOD DESCRIPTION STATUS
2534 OTHER_GROUPS 1 ROUND-ROBIN consumer group for users not included in any group in the active top-plan ACTIVE
2535 DEFAULT_CONSUMER_GROUP 1 ROUND-ROBIN consumer group for users not assigned to any group ACTIVE
2536 SYS_GROUP 1 ROUND-ROBIN
Group of system sessions
ACTIVE
2537 LOW_GROUP 0 ROUND-ROBIN
Group of low priority sessions
ACTIVE Rebuild the table and reload from another database. Check there is no triggers on the table, also check other object dependencies on this table.

Truncating the table and reloading it may work since it will not try to read the blocks.

Waleed

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

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

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]=3D20 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=3D20
corrupted and other is fractured as per dbv. After checking it was tracked=3D20
as a sys.table. dbinv alos points that corrupt block due media failure. SA=3D20
ran Compaq provided utility which says no corruption of media.

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

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

Regards
Rafiq

Planning a family vacation? Check out the MSN Family Travel guide!=3D20 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=20
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


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

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

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 - 21:26:15 CDT