On May 8, 12:21 pm, Cristian Cudizio <cristian.cudi..._at_yahoo.it>
wrote:
> On May 8, 11:21 am, sybrandb <sybra..._at_gmail.com> wrote:
>
>
>
>
>
> > On May 8, 11:11 am, Cristian Cudizio <cristian.cudi..._at_yahoo.it>
> > wrote:
>
> > > On May 8, 11:08 am, Cristian Cudizio <cristian.cudi..._at_yahoo.it>
> > > wrote:
>
> > > > On May 8, 10:27 am, sybrandb <sybra..._at_gmail.com> wrote:
>
> > > > > On May 8, 9:57 am, NetComrade <netcomradeNS..._at_bookexchange.net>
> > > > > wrote:
>
> > > > > > If you backup to NFS, which device you use, and what throughput do you
> > > > > > achieve. We'd like to be able to backup multiple db's at once, so
> > > > > > something in the range of 100Megs+/sec is what we are looking for
> > > > > > (obviously for cheap). Storage size is a few TB.
>
> > > > > > (need to buy a new one)
>
> > > > > > .......
> > > > > > We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc)
> > > > > > remove NSPAM to email
>
> > > > > Did you ever try to restore from such a NFS backup?
> > > > > I did. It wasn't funny. I never got the database back.
>
> > > > > --
> > > > > Sybrand Bakker
> > > > > Senior Oracle DBA
>
> > > > why?
>
> > > I've never tried, but i'm just curious to undertand what problems may
> > > arise.
> > > thanks.
>
> > > Cristian Cudizio
>
> > >http://oracledb.wordpress.comhttp://cristiancudizio.wordpress.com-Hidequoted text -
>
> > > - Show quoted text -
>
> > The savesets were incomplete, causing several datafiles NOT to
> > restore. IIRC, one of them was the SYSTEM tablespace.
> > Note: Absolutely no sign of any problem during backup!
>
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
>
> But do you think it was caused by NFS? Similar problems arised to me
> with backup on
> NTFS on windows machines (corrupted backups).
>
> Thanks,
>
> Cristian Cudizio
>
> http://oracledb.wordpress.comhttp://cristiancudizio.wordpress.com- Hide quoted text -
>
> - Show quoted text -
What I did observe was a backup to local disk and to tape restored
flawlessly, a backup to NFS didn't.
I never had any problems restoring a backup from NTFS drives (yes, I
did try), although obviously those were not networkdrives.
--
Sybrand Bakker
Senior Oracle DBA
Received on Tue May 08 2007 - 07:39:29 CDT
