archive logs to NFS storage

Hi,

Environment:
Solaris 9 on SPARC
Oracle 9i EE

We do on our production system one nightly cold backup. In case the machine with storage goes into flames 1 minute before a backup we loose the whole day of work.

I was thinking of a simple solution to add an extra log_archive_dest_x parameter which points to an NFS share from PC with Linux.

With redo archive files and last backup I am able to recover and lost only what was in not archived redo log, or what has not been coppied. That is a lot better tha a whole day.

I thought that it would be simple to implement and whould do no harm to database. With log_archive_min_succeed_dest=1 even if my Linux NFS server disappears it should not have any bad impact on database.

This is where I was wrong. Even with NFS mount with soft; or with soft,retry=2. Database goes untill it fills all available redo logs. The ARCH process does not release the redo logs and database stops. This is not good.

Anyone with similar problem? How to make NFS "umount" itself if things go wrong, I think now about rsync maybe?

The perfect solution whould be standby database but it requires the same architecture (SPARC) which is expensive. This is not an option now.

Thanks for your comments.
Remigiusz Boguszewicz Received on Fri Feb 25 2005 - 08:13:20 CST