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@xxxxxxxxx> 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

Other related posts: