Hot and Cold Backups??

From: <stuco_at_mailcity.com>
Date: Wed, 01 Jul 1998 15:19:37 GMT
Message-ID: <6ndk29$abf$1@nnrp1.dejanews.com>

I am pretty anal and paranoid when it comes to the safety and recoverability of production databases. So I have a question about Hot and Cold Backups.

My database is running in archivelog mode and is brought down every night for cold backups. I also do a full export of the database, place it on a separate disk and that also is backed up in that nightly process.

Is there any good use in doing hot backups?? My understanding of hot backups is that is it useful for databases that can't afford to be shutdown. In that case there should be daily hot backups and a weekly export and cold backup.

So, with my scenario above, give me a good reason to add hot backups to my strategy.

Thanks for clarifying my understanding of this thing we call ORACLE!

Stuart Cowen
Paladin Consulting - Dallas

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 01 1998 - 10:19:37 CDT