Re: Test Refresh Strategies

Paula,

I'll be presenting on this topic on 14th November on the UKOUG 06 in Birmingham. http://conference.ukoug.org/default.asp?p=246&dlgact=shwprs&prs_prsid=499&day_dayid=1 I've done it in 9i and 10g but it should be working with 8i as well providing there are no severe bugs with Transportable Tablespaces.

Cheers,
Alex

On 10/31/06, Paula Stankus <paulastankus_at_yahoo.com> wrote:
> Guys,
>
> We are running a test database in Oracle, version 8.1.7 on Solaris 2.9.
>
> We have a good deal of data in test and frequently refresh various schemas
> (but on different schedules) with a large volume of data. We often refresh
> the schemas during the data. For this reason (to speed up the refreshes
> while keeping the test database and other schemas available during the day)
> we do NOT use archivelog on our test database. We run cold backups and
> exports at night. Unfortunately, our cold backups are starting to take a
> great deal of time because of the volume of data.
>
> Any suggestions to provide the following on an 8.1.7 database?:
>
> -optimum up-time 24x7
> -flexibility to load large volumes of data during the day using imports as
> well as CTAS quickly with minimal I/O
> -doing backups for easiest and fastest recovery
>
> Thanks for your advice.
> Paula
>
> ________________________________
> Access over 1 million songs - Yahoo! Music Unlimited Try it today.
>
>

-- 
Best regards,
Alex Gorbachev

The Pythian Group
Sr. Oracle DBA

http://www.pythian.com/blogs/author/alex/
http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l