Re: Export as Daily Backup

Exports are one of the oldest and easiest backup methods. Exports have been known to fail, but this is rare. You will experience problems only with large databases. Recovery using import is a lot longer than backup with export. Time required to recover using an export file can easily exceed acceptable allowances. Consider carefully before using as your only backup/recovery. And before I ramble on more ... No you don't have to backup control files with a full database export.

Joe F wrote:

> I'm thinking of using Export Full as my daily backup routine.
> As it only backs up actual data whereas the Hot and Cold backups, backup the
> whole datafile (in NT) including all the empty space.
> I will then copy the Export.dmp to Tape
>
> Questions;
> 1) Are there any pitfalls in this arrangement?
> 2) Does one also have to backup the Control Files?
>
> Many thanks
> Joe
Received on Thu Sep 16 1999 - 21:11:30 CDT