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
