link between file and pv ?

[Systeemingenieurs Infoc]

Small problem : i have a vg that is formed by 7 pv's. The vg contains 1 big fs.

It apears that 3 pv's (= 3 lun's on a clariion 4700 device) are logicaly corrupted (the raid-verify on the box reveiled this) ; the fs is fsck'ed and mounted.

Is there a way to know which files (= oracle database files) resides on which pv ?

[Patrick Wallek · Accepted solution]

There is no easy way that I know of. It will also depend greatly on your configuration. If your clariion is set up to stripe across all volumes, or if you set the LV up to stripe, then all files could possibly reside on all disks.

The easiest thing I can think of to do, if you truly do have some corruption of your Oracle data files, is restore from a known good backup.

[Michael Tully]

If you have the 'inq' program suppplied by EMC you may be able to map this out. Given we don't know how your FC4700 is setup it is a little difficult to suggest anything else other than to get EMC to fix the corruption and restore, like Patrick has suggested.

[Systeemingenieurs Infoc]

We're restoring the backups right now (about 850 Gb - could take a while).

Patrick,
The clariion does stripe across alle volumes in the raidgroup. So it might be that alle files reside on all physical disks. The physical disks are (now at last) ok. There is logical corruption on the LUNs, however. The
corrupted LUNs (= pv's on my hpux box) are identified. According to my limited knowledge there is a good chance that not all files have parts on the damaged LUNs ???

Since we've decided to restore all data, my initial question is no longer relevant. For future disasters a 'inq' tool could be very valuable. I'll contact our EMC-representative to abtain such a tool.

Tanx for the responces !!