From: fbortel@nescape.net   
      
   copernicus wrote:   
      
   > Hi,   
   > I have a 2 Tb data warehouse.I need a backup strategy as the current   
   > backup strategy(cold backup) is taking too long.Is it possible to do a   
   > incremental backups using RMAN ? I guess I have to put the database in   
   > archivelog mode for this to work.But it is going to generate a lot of   
   > archive if I put in archivelog mode.   
   >   
   > I am not sure how to proceed.Plz advise.   
   >   
   > Thanks,   
   > Copernicus   
   It generates just as much in noarchivelog mode - the only   
   difference being that the files are reused...   
   In my book, no database deserves the label "Production"   
   if not running archive log mode. If only for the reduced downtime;   
   did you ever consider what time it takes to restore a cold backup   
   of a 2 TB database?!?   
      
   OTOH - it's 'just' a DWH, so there's no data, that cannot be   
   retrieved from the original systems...   
      
   Anyway - I'd go RMAN - it lets you do incremental, differential,   
   full hot and full cold backups, backup the archived redo logs,   
   and cleanup unnecessary backup sets.   
   --   
   Regards, Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)