Re: Backing up Databases

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 26 Jul 2002 15:44:29 -0700
Message-ID: <92eeeff0.0207261444.dbd043b_at_posting.google.com>

"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.

If you are not a 24/7 shop, then cold physical backup is the best protection. I have created a batch script to run on Win2K server which,
1) Connects to a database
2) Extracts all necessary info on datafiles, controlfiles, redologs, non-default parameters etc.

3) Shuts down instance
4) Zips up all files using Winzip's command line utility.
5) Starts up instance
6) Copies zip file to another location from where your backup utility

can pick it up.
7) Generates a timestamped log file of the entire process.

If you are interested, then email me.

HTH
//Rauf Sarwar Received on Sat Jul 27 2002 - 00:44:29 CEST