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