recovery

[KOGOE Jean_Baptiste]

my server work on HPUX 11; but I've a big problem, because I badly mount an lvol on a file system /home04 that already contained oracle controle,log, and datafiles with sam; and then I've lost all my oracle files, the problem is that I haven't any backup of the database. can I recover my old file system /home04 with oracle data & control files ?

[A. Clay Stephenson]

Simply mounting a filesystem wouldn't do any harm but if , for example, you created a new filesystem on this LVOL then it's hopeless. If you can explain exactly what you did, it may be possible to tell you more.

[KOGOE Jean_Baptiste]

ok let me tell u what I've done.
in my absence a friend of mine have installed 3 oracle databases on 3 lvols
(lvolhome04 mount on /home04,lvolhome05 mount on /home05,lvolhome06 mount on /home06) but he has forget to put the files system on the /etc/fstab.
today I restart the server and the filesytem /home04 .. /home06 wasn't available; instead of mounting the /dev/vg01/lvolhome04 .. by command line ( mount /dev/vg01/lvolhome04 /home04 ..)
I launch SAM and create a new file system
on /home04 on which i mount /dev/vg01/home04 ... and then I've lost the old oracle FS that existed on /home04. the problem is that how can i recover the content of an old file system that I've detroyed without a previous backup.Those HPUX put the content a the prevous FS in a directory where I can check ?

[A. Clay Stephenson]

In technical terms, you are now toast. There is no way to reverse the effects of a mkfs/newfs command. It's time to rebuild your databsae from scratch. When multiple admins are responsible for a box, it's essential that they communicate.