Re: Datawarehouse backup
- From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
- To: <jkstill@xxxxxxxxx>
- Date: Thu, 10 Mar 2005 09:57:09 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
