| How do I move this cluster object to another tablespace? [message #291565] |
Fri, 04 January 2008 22:13  |
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
Hi all!
I found a cluster object which located on corrupted block
ERROR:
ORA-01578: ORACLE data block corrupted (file # 288, block # 23213)
ORA-01110: data file 288: '/u01/oracle/proddata/system10.dbf'
SQL> host dbv file=/u01/oracle/proddata/system10.dbf blocksize=8192
DBVERIFY: Release 9.2.0.6.0 - Production on Fri Jan 4 14:44:18 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
DBVERIFY - Verification starting : FILE = /u01/oracle/proddata/system10.dbf
Page 23213 is marked corrupt
***
Corrupt block relative dba: 0x48005aad (file 288, block 23213)
Bad check value found during dbv:
Data in bad block -
type: 6 format: 2 rdba: 0x48005aad
last change scn: 0x056c.da56cb7e seq: 0x1 flg: 0x04
consistency value in tail: 0xcb7e0601
check value in block header: 0xa8b6, computed block checksum: 0x20
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
DBVERIFY - Verification complete
Total Pages Examined : 128000
Total Pages Processed (Data) : 25023
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 15474
Total Pages Failing (Index): 0
Total Pages Processed (Other): 5828
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 81674
Total Pages Marked Corrupt : 1
Total Pages Influx : 0
Highest block SCN : 5965089155823 (1388.3674548975)
And this is the object
SEGMENT_NAME SEGMENT_TYPE OWNER TABLESPACE_NAME
------------------- ------------------- ------------ ------------------------
C_OBJ# CLUSTER SYS SYSTEM
Can I move it to another tablespace?
Thank you!
|
|
|
|
| Re: How do I move this cluster object to another tablespace? [message #291573 is a reply to message #291565] |
Sat, 05 January 2008 01:18  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
No, you can't move it because this is a mandatory database (SYS) basic object.
You will have advantage to read Metalink note 28814.1, Handling Oracle block corruptions in Oracle7/8/8i/9i/10g
In this case, unfortunatly you have to restore/recover your system tablespace file from a backup.
If you are not in ARCHIVELOG mode or have no backup, you have to export the database, recreate it and reimport.
There may be tricker ways but they need experience to be used.
Regards
Michel
[Updated on: Sat, 05 January 2008 01:19] Report message to a moderator |
|
|
|
|
|
| Re: How do I move this cluster object to another tablespace? [message #291650 is a reply to message #291565] |
Sat, 05 January 2008 12:00 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
I have input & it is up to you to decide what to do with it.
I have had corrupted blocks in the past, but never in the SYSTEM tablespace (thankfully).
It has been a while & my memory is less than 100% perfect.
There is either an initSID.ora parameter of a DBMS_?????? call
that instructs Oracle to no longer report the corrupt block.
It is like covering your eyes with your hands to avoid seeing some unpleasant event.
It does not correct the problem, it just hides it from being reported.
The ONLY long term Best Practice is to move the existing data into a new database; but I realize that is easier said than done!
Nothing is impossible for the person who does not have to actually do it!
[Updated on: Sat, 05 January 2008 12:00] by Moderator Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
