Re: Datawarehouse backup

Thanks Jared,Tim,Niall and Scott for all your valuable inputs.

Niall,
<<If you don't care enough
about the db to run in archivelog mode (because you can always recreate the data perhaps) then why back it up at all.>> We can recreate the data for a Week but ot for a Month. That is why we back it up(cold backup) on weekly basis.

<<In addition your recovery procedure seems to omit putting the tablespaces back in read-write mode before you run your ETL jobs>> good catch. thanks a lot.

Jared & Tim,

As Scott mentioned, the dw database generates huge amount of archivelogs The reason we are not running in archive log mode is that the backup servers can't keep up with. That is why we decided to go with NOARCHIVELOG mode.

On Thu, 10 Mar 2005 07:54:55 -0500, Scott Dial <smd_at_triquetra.homelinux.org> wrote:
> I work with >1TB data warehouses, and yes, I take my db out of archivelog mode for large data loads. We even have 100GB arch volumes that the backup servers can't keep up with. Not only that, but it wastes a lot of time.
>

--
http://www.freelists.org/webpage/oracle-l