From oracle-l-bounce@freelists.org Wed Jul 28 21:26:15 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6T2PxA27068 for ; Wed, 28 Jul 2004 21:26:09 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6T2Pn627050 for ; Wed, 28 Jul 2004 21:25:59 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3809072C1D0; Wed, 28 Jul 2004 21:04:00 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22388-46; Wed, 28 Jul 2004 21:04:00 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7864272C291; Wed, 28 Jul 2004 21:03:59 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 28 Jul 2004 21:02:28 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 74C1B72C093 for ; Wed, 28 Jul 2004 21:02:28 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 21883-36 for ; Wed, 28 Jul 2004 21:02:28 -0500 (EST) Received: from maillnx-us311.fmr.com (maillnx-us311.fmr.com [192.223.178.26]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1D2B472C077 for ; Wed, 28 Jul 2004 21:02:28 -0500 (EST) Received: from virmmk111nts.fmr.com (virmmk111nts.fmr.com [172.25.106.96]) by maillnx-us311.fmr.com (Switch-3.1.2/Switch-3.1.0) with SMTP id i6T2TdRn000588 for ; Wed, 28 Jul 2004 22:29:39 -0400 Received: from MSGBOSCLF2WIN.fmr.com ([10.46.17.175]) by MSGMROIM01WIN.DMN1.FMR.COM with Microsoft SMTPSVC(5.0.2195.6713); Wed, 28 Jul 2004 22:29:17 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.0.6556.0 content-class: urn:content-classes:message MIME-Version: 1.0 Subject: RE: System tablespace corrupted Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Date: Wed, 28 Jul 2004 22:29:16 -0400 Message-ID: <42BBD772AC30EA428B057864E203C9991159BC@MSGBOSCLF2WIN.DMN1.FMR.COM> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: System tablespace corrupted Thread-Index: AcR1CFng54OFXM/qQIebIYLMTOB9rgACm3rg From: "Khedr, Waleed" To: X-OriginalArrivalTime: 29 Jul 2004 02:29:17.0148 (UTC) FILETIME=[D891D1C0:01C47513] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 6354 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Waleed.Khedr@FMR.COM Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@hotmail.com]=20 Sent: Wednesday, July 28, 2004 9:06 PM To: oracle-l@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" Reply-To: oracle-l@freelists.org To: 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@hotmail.com]=3D20 Sent: Wednesday, July 28, 2004 8:18 PM To: oracle-l@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@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@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@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@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 -----------------------------------------------------------------