Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

Missing datafiles after reboot

James A. Donovan
Honored Contributor

Missing datafiles after reboot

Recently, we had a server crash, and after the system came back up, we found that several Oracle data files were missing. We ended up having to do a restore from tape.

Would the following settings in fstab for the vxfs filesystems be a reason why the files went missing? And if so, please explain...

rw,suid,delaylog,nodatainlog

thanks...
Remember, wherever you go, there you are...
7 REPLIES
harry d brown jr
Honored Contributor

Re: Missing datafiles after reboot


"mount" options are not going to cause the system to "delete" files. I could understand if they were corrupt, but deleted? Nay. You might want to look into peoples shells for that answer.

You also might want to consider mirrored or raid'ed disk storage.


live free or die
harry
Live Free or Die
harry d brown jr
Honored Contributor

Re: Missing datafiles after reboot


Jim,

I realize this might sound silly, but how is your system for patches? Don't feel bad, I recently found "current" servers we are deploying, with 268 missing "recommended" patches.

live free or die
harry
Live Free or Die
Michael Tully
Honored Contributor

Re: Missing datafiles after reboot

Hi Jim,

I have one Oracle system and I have the filesystem mounting options like this:

rw,suid,log,datainlog

These options are fully explained in the 'mount_vxfs' man page.

Having the options you have does not explain missing files. I could understand if the filesystem got corrupted in some way, but definitely not missing files. Any one else got access that perhaps they shouldn't have?

Michael

Anyone for a Mutiny ?
T G Manikandan
Honored Contributor

Re: Missing datafiles after reboot

This cannot happen.
Probably the file system was not mounted exactly as before or the files were moved by someone.


Thanks
Brian Crabtree
Honored Contributor

Re: Missing datafiles after reboot

One thing also to consider, is that the fstab was not kept current, and someone mounted additional mount points without updating the file, or changed the mounting. This has happened on a few systems that I support.

Brian
harry d brown jr
Honored Contributor

Re: Missing datafiles after reboot


Jim,

Why was the system rebooted in the first place?

Also, here's a great jfs paper:

http://www.interex.org/pubcontent/enterprise/may00/08sysadx.html

live free or die
harry
Live Free or Die
Graham Cameron_1
Honored Contributor

Re: Missing datafiles after reboot

If a user with appropriate permissions rm's one or more datafiles, then the kernel does not actually deallocate the space until all attached processes die.

Thus Oracle will keep on running. No more users can connect but those connected are unaffected until you shutdown oracle or reboot.

I know this from personal experience and my heart still sinks when I recall the day I rm'd the files of a live and running database instead of the test system - no-one noticed until a new user tried to log in!

Maybe that's what happened to you.
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.