Home » RDBMS Server » Server Administration » How do I move this cluster object to another tablespace?
How do I move this cluster object to another tablespace? [message #291565] Fri, 04 January 2008 22:13 Go to next message
trantuananh24hg
Messages: 668
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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 #291649 is a reply to message #291573] Sat, 05 January 2008 11:46 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you, Michel!

I am reading this document, thanks again!
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 Go to previous message
BlackSwan
Messages: 25050
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

Previous Topic: cdump...?
Next Topic: Rollback Segments
Goto Forum:
  


Current Time: Sat Dec 10 05:22:30 CST 2016

Total time taken to generate the page: 0.11108 seconds