> Date: Sat, 25 Jan 2003 16:13:30 -0500 > From: Paul Turpin <[EMAIL PROTECTED]> > Subject: DB2EUG Recovery versus full database load?
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
