I was having a conversation with an Oracle DBA recently and we were
discussing
recovery of a large data warehouse (10TB). He suggested that there was
no need to
backup the database, but rather the files used to load the warehouse. He
said that in
tests he had done reloading the entire database was much quicker than
doing a database
restore. Because of the parallel capabilities in the Oracle "loader" he
could reload the
database very quickly (several hours) versus a day or longer recovery. I
didn't get all
the details about his database, but I suspect that he had the data
spread out over a number of
disk devices to avoid disk contention.
I know that EEE can do a lot of parallel loading, but also can do a lot
of parallel recovery
operations. Has anyone tested a scenario in a large database using EEE,
where they
tested the speed of reloading the entire database versus recovering it?
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
