Home -> Usenet -> comp.databases.oracle -> Hot vs Archive backups in V7 on unix

Hot vs Archive backups in V7 on unix

From: Ron Beery <rbeery_at_wtcp.DaytonOH.NCR.COM>
Date: 3 Jan 94 20:54:08 GMT
Message-ID: <2545_at_wtcp.DaytonOH.NCR.COM> 







I'm looking into Oracle V7 backup strategies in Unix for a
database needing 6x24, 1x20 availability.  I am considering two
options.



    
  
  1.   Daily Hot backups. And weekly cold backups.

  
  2.   Daily backups of archive logs, control file and init.ora
files.  And weekly cold backups.






Conceptually, option 2 doesn't seem all that much different
from daily cold backups.  I keep the archive files around for
eight days; therefore, I should need only the Sunday tape and
possibly one weeknight tape for recovery.  And all files are on
RAID.  Other than needing more archive files for recovery, I
don't see much difference.



What is the Net Wisdom and Net Experience using option 2?  It
seems too simple.  What am I overlooking?  



ps. Additional backups via database exports are down the road.


-- 
Ron Beery 
"Everthing is computerized.  What could possibly go wrong?"


Received on Mon Jan 03 1994 - 21:54:08 CET












Original text of this message