Re: How to backup a 2 Tb Oracle data warehouse ?

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