Re: Datawarehouse backup

> 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?

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