‎Datawareshouse(Oracle) has corrupted and error on disk while ran batch job. | DELL Technologies

Start a discussion

UNSOLVED

SoCool1

updated

18 years ago

SoCool1

13 Posts

0

478

April 23rd, 2009 11:00

Datawareshouse(Oracle) has corrupted and error on disk while ran batch job.

I checked the symmetrix was clean and ran STP collected on all devices on this host (list of below picture). I have found just one device has many IO on it.
Is it root cause of this issue?

total I/O per sec
http://www.temppic.com/img.php?24-04-2009:1240510971_0.32370000.jpg

Kbyte Read per sec-->
http://www.temppic.com/img.php?24-04-2009:1240510972_0.09337900.jpg

read per sec -->
http://www.temppic.com/img.php?24-04-2009:1240510972_0.90891300.jpg

M
MikeMac1
2 Intern
•
292 Posts
191
0
Posted April 23rd, 2009 11:00
Surachet, I moved your thread to Symmetrix. I would suggest opening up a service request to have the Symmetrix checked out. It's hard to say from a few screen shots if this is the root cause of Oracle corruption and deeper investigation of the Symmetrix should be done.
H
HankDorsett
66 Posts
191
0
Posted April 23rd, 2009 12:00
What does the messages or event log show?
S
SKT2
2 Intern
•
1340 Posts
191
0
Posted April 23rd, 2009 12:00
what is the configuration of that particular LUN?
S
SKT2
2 Intern
•
1340 Posts
191
0
Posted April 23rd, 2009 12:00
which OS and powerpath version?
E
emc_troy
2 Intern
•
142 Posts
191
0
Posted April 23rd, 2009 14:00
I've see corrupted Oracle on AIX because of power path pseudo devices were not matching their major/minor numbers
M
MikeMac1
2 Intern
•
292 Posts
191
0
Posted May 6th, 2009 07:00
SoCool, were the reply's to your post able to answer your questions? Did you have to open a service request to have the Symm checked out? Please mark the helpful and correct posts and also mark the thread as answered. Doing so helps others identify what posts were the most useful.