Re: Datawarehouse backup
- From: Scott Dial <smd@xxxxxxxxxxxxxxxxxxxxxxx>
- To: Tim Gorman <tim@xxxxxxxxx>
- Date: Thu, 10 Mar 2005 09:13:24 -0500
> If you are in the habit of "taking the db out of archivelog mode"
> arbitrarily, then it is likely that the database is in an unrecoverable
> state much of the time even after you re-enable it.
>
We take backups afterwards. It's a data warehouse. If there's a problem, we
reload the data.
> Let me make some guesses at some characteristics of your >1Tb DW(s):
>
> * tables are not partitioned
They are.
> * bitmap indexes are more trouble than they are worth
nope.
> * star transformations are an unknown
nope.
>
> Just curious; are any of these observations true?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
