Re: Help! Backup & Recovery in Oracle8 enterprise edition

the problem is not exactly well defined.

You take a backup, this means you intend to restore (may be).

-the full DB
-a single table (or package)

   a)if you drop a single table, how will you recover : with cold backup you need to restore the full DB. what about the other development of this day?

   b) if you need to restore the full DB : with a full import it takes longer that a simple restore of cold backup, especially if your cold or hot backup scripts generate a restore script. Then you just type 'restore.sh' and it takes 5 min instead of 1 hour.

Take both backup :

     export to restore single table
     cold   to restore the full DB

B. Polarski
http://www.geocities.com/bpolarsk
bpolarsk_at_yahoo.com

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!