- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Block corruption on Oracle data file
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2007 01:16 PM
тАО07-12-2007 01:16 PM
Block corruption on Oracle data file
*******************
I reviewed the data in the two corrupted blocks. Both blocks were corrupted in teh same way. This is, blocks were overwritten with exactly the
same data at the same offsets.
For block 73 we have:
------------------------------
$ diff 73_bad.hex 73_ok.hex
130,131c130,131
< 0004020 000b 0000 0c00 0000 0100 0100 0b00 000c
< 0004040 0000 0001 0002 041d 1825 3002 c10d 0180
---
> 0004020 0202 c108 ffff ffff ff02 c102 02c1 15ff
> 0004040 02c1 0207 7864 041d 1825 3002 c10d 0180
and for block 272:
------------------------
$ diff 272_bad.hex 272_fix.hex
130,131c130,131
< 0004020 000b 0000 0c00 0000 0100 0100 0b00 000c
< 0004040 0000 0001 0002 0000 0000 0000 0000 0000
---
> 0004020 0000 0000 0000 0000 0000 0000 0000 0000
> 0004040 0000 0000 0000 0000 0000 0000 0000 0000
(*.hex files have the output from od -vx *.dd command)
We can see that in both cases, block were overwritten with the following 22 byte pattern:
000b 0000 0c00 0000 0100 0100 0b00 000c 0000 0001 0002
starting at offset 2064 (4020 octal)
===
Any idea what is this 22 bit pattern means?what could cause a data corruption(either a h/w issue or some one messing up with that file accidentally).
Corrupted blocks have been fixed and the databse is currently up now.
Could some clarify in a better way.
We have not done a fsck on this FS(2TB) as it require to unmount and we want to avoid it at this moment.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-13-2007 08:25 AM
тАО07-13-2007 08:25 AM
Re: Block corruption on Oracle data file
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-13-2007 09:36 AM
тАО07-13-2007 09:36 AM
Re: Block corruption on Oracle data file
Now having said all of this, while it is possible that this is an OS problem, it is far more probable that this is an application error (Oracle). I would be spending most of my time at MetaLink. It almost certainly is not a file system corruption since you are able to extract the
data from a cooked file using dd. This is an extremely strong indication that the file system internal integrity is intact.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-13-2007 09:47 AM
тАО07-13-2007 09:47 AM
Re: Block corruption on Oracle data file
9000/800/S16K-A;B.11.11 U; 10.2.0.2.R;
Not yet done any dd/fsck till now.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-13-2007 09:49 AM
тАО07-13-2007 09:49 AM
Re: Block corruption on Oracle data file
9000/800/S16K-A;B.11.11; Oracle 10.2.0.2.R;
Not yet done any dd/fsck till now.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-18-2007 11:28 AM
тАО11-18-2007 11:28 AM