-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Li, Jackie (Yanhui) wrote:
Our firm runs oracle 9i using NFS file system from Netapp(3040 running 7.2), we have noticed few cases now that when the NFS file system is full, oracle database crash and can not even start after that.
It turns out that database has logical corruption, does anybody experience similar issues?
If you log Oracle to the same vol with Oracle data, ruh roh.
I recommend splitting Oracle online (and archive) logs to their own volumes to mitigate damage should Oracle data vols fill. This should allow you to replay to a consistent point-in-time once youve resolved the full data volume problem. I also recommend multi-plexing the logs to NAS and local disk just to be paranoid.
You can also flip a bit on your filer (vol autosize; done on a per-volume basis) to auto-grow a volume a specified value should you hit a threshold. This assumed you have spare aggr capacity. Use wisely.
Hope this helps your avoid future issues.
- -- Nick Silkey