Re: Backing up Databases

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.

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 - 01:46:39 CEST