Re: Refreshing a multi TB database

Ram,

1. As long as you're on 9i there is no such thing as "flashback database". It's a 10G feature.
2. If you will get upgraded to 10G someday.

For initial estimation you would consider:

1. The amount of archivelog generated on production box.
2. The amount of flashback logs generated on test box.
3. Time needed to flashback and rollforward test box Vs full restore+recover.
4. Altering (if not already) production box to be in a force logging mode (perhaps).

The additional bonus of this schema - you can sort of mix standby (greatly lagging behind for the most of the time however) and test in a one box.

From the above figures you can drive the initial estimation. We are currently considering this schema for refreshing test DB from our ~2.3TB production database but so far have done only initial testing. We have had no problems with activation/flashback/rollforward but still not rolled this into some real world scenario so currently we don't have answer to a (b) and the first part of the (c).

On 3/20/07, William Wagman <wjwagman_at_ucdavis.edu> wrote:
> Alexander,
>
> This is an interesting solution and of course, leads to further
> questions. Our developers have been asking for a 'sandbox' if you will
> where they can play yet have it refreshed form production on a daily
> basis. Currently the database is 9i and I use RMAN to clone the
> test/devel database but haven't really figured out yet how to automate
> that process so it doesn't happen on a daily basis. So two questions...
>
> 1) Has anyone worked out a means to do this using 9i? If so how?
>
> 2) You mention some restrictions in the solution you provided. I am
> curious in knowing those restrictions. Are the flashback storage
> requirements simply the sum of the archive generation in a 24 hour
> period or are there other issues which must be taken into account? Have
> you done this and how difficult was it to implement?
>
> Thanks.
>
>
> Bill Wagman
> Univ. of California at Davis
> IET Campus Data Center
> wjwagman_at_ucdavis.edu
> (530) 754-6208

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