Another good treatment of the use of partitioning in DW to reduce backups is a paper by Jeff Maresh posted online at “http://www.EvDBT.com/papers.htm”, entitled “Managing the Data Lifecycle”.
-Tim
on 10/24/03 4:34 PM, Michael Kline at [EMAIL PROTECTED] wrote:
I'm working at a Data Warehouse and they are looking for backup possibilities...
This is almost a TB, a baby, and it may be that RMAN with incremental could be a good solution.
If say for instance there is a single tablespace of some 100 gig and they add 200,000,000 records to one of the tables and we do an incremental backup. Is the whole tablespace slated for backup?
Also if this tablespace was lost, and we recover.. What happens during that process? Does RMAN basically have to filter through two complete copies of that tablespace or just once and then get changed blocks?
What solutions have some doing this found to be "best practice"?
Thanks.
Michael Kline, Principal Consultant
Business To Business Solutions, LLC
Richmond, VA
804-744-1545
