Re: Export as Daily Backup

 Joe F <Work_at_Home.com> wrote in message news:qe8E3.490$68.15351_at_news2-hme0...
> 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?

        There have already been several excellent answers to this question. Our shop does both. If we need to recover the whole database, we have to cold backup for that. The export gives us a file from which we can recover a single user, and a single or group of tables. The two methods complement each other.

MB Received on Thu Sep 23 1999 - 07:42:08 CDT