| Block Corruption in Expdp [message #494589] |
Tue, 15 February 2011 23:00  |
pradies
Messages: 250
Registered: May 2008
|
Senior Member |
|
|
Hi,
I am facing issue of block curruption in my exp backup which I am taking through expdp command. (Refer Attachment of Screen shot of error)
I want to know few things about the block corruption.
1. Why the block corruption occur.
2. How can I resolve this.
3. Can I rosolve this by deleting the same record on which this error is coming. if yes then how can I track that row in a table.
I already tried for DB verify utility. It shows the below result.
===================================================================
C:\Documents and Settings\Administrator>dbv file='E:\ORADATA\AFCCV1\MONETA01.DBF' blocksize=8192
DBVERIFY: Release 11.1.0.6.0 - Production on Wed Feb 16 10:13:11 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
DBVERIFY - Verification starting : FILE = E:\ORADATA\AFCCV1\MONETA01.DBF
DBV-00600: Fatal Error - [28] [27070] [0] [0]
C:\Documents and Settings\Administrator>
================================================================
Kindly suggest if there is any resolution for the above corruption
Thanks and Regards
Pradeep
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Block Corruption in Expdp [message #494598 is a reply to message #494595] |
Tue, 15 February 2011 23:34  |
pradies
Messages: 250
Registered: May 2008
|
Senior Member |
|
|
Hi Swan,
My db blocksize is 8192.
NAME VALUE
-------------------- ----------
db_block_size 8192
db_name afccv1
One thing I want to ask Can I identify the row which is not readable due to curruption.
Thanks and Reagrds
Pradeep
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Block Corruption in Expdp [message #494627 is a reply to message #494624] |
Wed, 16 February 2011 01:57 |
pradies
Messages: 250
Registered: May 2008
|
Senior Member |
|
|
Hi Michal,
As you said "error in DBV execution" I am not able clarify/identify why there is error.
Might be it occurs due to tablespace is in use. or there is some permission error. but I am using windows and dbf file having read write permission. For Is in use I can't take db down right now so I will recheck dbv utility when I will be able to take downtime of db.
If you have any clues regarding this then please tell me.
Regards
Pradeep
|
|
|
|
| Re: Block Corruption in Expdp [message #494633 is a reply to message #494627] |
Wed, 16 February 2011 02:38 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:As you said "error in DBV execution" I am not able clarify/identify why there is error.
DBV-600 => bug => Oracle support
Quote:Might be it occurs due to tablespace is in use.
No.
Quote:or there is some permission error.
Maybe.
Quote:If you have any clues regarding this then please tell me.
DBV-600 => bug => Oracle support
Why did you say there is a "block corruption"?
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
