Re: Backing up Databases

Hi T R,

Comment embedded.

"T R" <trjunk01_at_hotmail.com> wrote in message news:zhG09.217355$q53.5484339_at_twister.austin.rr.com...
> export is a bad way of implementing a backup solution for a large db. it
> should be done as a secondary method of backing up and not the primary.
 the
> reason being, it is very inefficient and it takes a long time to import
 all
> the data back to restore if a problem arose.

You forget to mention that after you perform the import to restore after, how do you then recover all the changes that were made since the export was performed. As they say here is Australia, "I'll like to see that" !!

Export/Import is actually a very valuable "recovery" tool than a backup tool as such. Lose a table, what you do do. You perform a point in time recovery using your *O/S* backup (clone DB if you wish), then use export to recover the lost table, then use import to import the table back into your existing database. A bit of a fiddle with any constraints that need to be restored and bingo, no data lost.

Sounds pretty good to me !!

>
> RMAN (recovery manager) is should be used. it used to problematic but is
> pretty stable. this can also do incremental backups so this should reduce
> the time to perform the backups. also, recovery time is reduced. you can
> backup to a tape directly. check out the RMAN docs.
>
> "JohnWood" <jwood_at_microsoft.com> wrote in message
> news:u1209.3831$Vj3.299760_at_news0.telusplanet.net...
> > Hi,
> >
> > I am looking for advice what to use for backuping an Oracle database.
> >
> > I was planning to use the Oracle's Export Utility to create an .exp
 file.
> > Then using window2000's backup utility to backup the .exp file to a
 Compaq
> > DLT Tape. But as the database may grow to a 100 to 200G of data, it is
 not
> > feasible to purchase 3 more 72G drive to hold the exp file (I have no
 idea
> > how big the export file will be yet). I prefer to export or backup to
 the
> > DLT tape directly from Oracle. The DLT tape have a capacity of 40G or
 80G.
> >
> > Please advise what software or setup I can do to achieve this.
> >
> > Thanks.
> >
> >
> >
>
>
Received on Sun Jul 28 2002 - 03:24:43 CEST