Re: Datawarehouse backup

could I get more input, I'm confused.
Do you mean run the database in archivelog mode, do an full online backup say once/week and delete the archivelogs during the week. If recovery is required just recover the full and run the etl for the week?

The reason I ask is I have numerous 200-500Gb database in noarchivelog mode. Exports only, they churn through 30-75Gb/day. All on 8i. Most of the data is rebuilt completely every day. Very hard to get deltas from our feeds. So exports are the choice as we rebuild completely. Nobody will give the downtime(or disk space) to do full backups. Everyone theoretically knows the risks. I've recovered somewhat completely many times using this method. But I'm interested in new approaches for when we move to 9i.

really, he can just use rman on his 9i, and do the cold backup with that. Easy peasy.

Mike

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