 | | | System tablespace corrupted | System tablespace corrupted 2004-07-29 - By M Rafiq
Waleed, Michael,
Thanks for both of you for your suggestion. I did dropped(tuncate did not
work) the corrupted table, recreated usinf import from other database and
compiled invalids. Full export error gone now.
Thanks again for experimenting this issue.
But dbv still gives the error pointing to one block as corrupt page 223 is
influx most likely Media corrupt and page 224 is marked corrupt.
Should I restore it from cold backup to get rid off this error?
Regards
Rafiq
From: "Khedr, Waleed " <Waleed.Khedr@(protected) >
Reply-To: oracle-l@(protected)
To: <oracle-l@(protected) >
Subject: RE: System tablespace corrupted
Date: Wed, 28 Jul 2004 22:29:16 -0400
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@(protected)]
Sent: Wednesday, July 28, 2004 9:06 PM
To: oracle-l@(protected)
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 (See ORA-01578.ora-code.com): ORACLE data block corrupted (file # 1, block # 223)
ORA-01110 (See ORA-01110.ora-code.com): data file 1: 'F:\ORACLE\ORADATA\CBS\SYSTEM01.DBF '
Regards
Rafiq
From: "Khedr, Waleed " <Waleed.Khedr@(protected) >
Reply-To: oracle-l@(protected)
To: <oracle-l@(protected) >
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@(protected)]=20
Sent: Wednesday, July 28, 2004 8:18 PM
To: oracle-l@(protected)
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@(protected)
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@(protected)
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@(protected)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ __
Don’t just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
|