Re: Hot backups for Oracle 7/Solaris

Rich do not NFS mount Oracle datafiles. I believe if you call oracle you will be told that this is not supported. I am not a unix "expert" but I believe that an application like Oracle cannot guarentee that a write has taken place for an NFS mounted file system. A unix "sync" call will not guarentee the write ...

In article <ngreene.819687952_at_houws001.shl.com>, ngreene_at_locws140049.shl.com says...
>
>Rich Moldovan <richmo_at_azstarnet.com> writes:
>
>>I currently have been assigned the task of backing up an recently
>>started Oracle data base. Oracle 7 is running on a Sparc/Solaris
>>platform and the data files reside on an NFS mounted drive. The
>>NFS server is an Auspex file server running SunOS 4.1.3. We already
>>have tape backup facilities on the Auspex. My problem is - since
>>the database is serving a 24hour/7day manufacturing facility, it is
>>impracticle to shut the database down for cold backups. It seems
>>ludicrous to backup a 2 gig data file that is 98% empty at this
>>point. Does anyone have any recomendations for this situation.
>
>Rich:
>
>Be VERY VERY VERFY careful NFS mounting your Oracle datafiles. You are headed
>toward some problems with datafile corruption if/when anything goes wrong
>between the two systems.
>
>I guess my next question would be, if your 2gb datafile is 98% empty, then why
>is it 2GB?
>--
>Neil Greene
>Senior Oracle DBA / Unix System Administrator
>SHL Systemhouse, Inc. LA Outsourcing Center
><HREF=mailto:ngreene_at_shl.com>
>--
>Neil Greene
>Senior Oracle DBA / Unix System Administrator
>SHL Systemhouse, Inc. LA Outsourcing Center
><HREF=mailto:ngreene_at_shl.com>
Received on Sat Dec 23 1995 - 00:00:00 CET