Re: Database Recovery

vfomov_at_aol.com (VFomov) wrote:

]Always have an offline backup and a full export before your procedures.

While a full export is a great thing to have around, I seen no point in having an offline backup around. What use can it be? The database has been opened since the offline backup, so the data is old, restoring from it would mean loss of data unless you have archived re-do logs to roll forward with.

If you have these archived re-do logs, then why the offline backup? Just use a hot backup and the archived re-do logs.

If I'm missing something here, I'd REALLY like to know (right now).

--
 ,-,_|\ George Dau - Unix (Solaris, DEC Unix, Linux), Oracle, Internet. __

/    * \ Home: gedau_at_pobox.com         !  Any views or opinions expressed (OO)
\_,--\_/ Work: gedau_at_isa.mim.com.au    !  above may be mine, but are NOT ( \/ )
      v   WWW: http://pobox.com/~gedau !  necessarily those of M.I.M.     W--W