Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

Database Duplication Strategies

Nirmalya Das

2006-05-24


Here's the scenario:

-------------------------------------------------------------------------------
Production environment: (State of Michigan)

Sun E6500 (10 processors, 20G memory)
Veritas HA with three way mirroring disk suits
SUN OS 5.9
Oracle 9.2.0.7 (2TB of data)

The backups are done nightly (using scripts) by breaking the third mirror and
using Veritas netbackup.

Performance testing environment: (State of California)
    (big pipe connecting the two states)

- This environment currently gets refreshed by bringing physical tapes from
Michigan and refreshing the "performance testing" instance.
- Takes at least 7-10 days.

-------------------------------------------------------------------------------

Proposed Solution:

- Create a standby database in California using Data Guard (bandwidth is
sufficient)
- Use RMAN with Recovery Catalog to backup the standby database
- Use RMAN Duplicate to create the "Performance Testing" database.

-------------------------------------------------------------------------------

- This should dramatically reduce the time required to refresh
the "Performance Testing" database.
- Even though the Veritas HA is used on the production site, The standby in
California should provide another level of protection from total disaster
in Michigan.
- Data Guard is free

What do you all think about the approach. Did I miss any obvious pitfalls?
Comments/suggestions are appreciated.

TIA,

Nirmalya
--
http://www.freelists.org/webpage/oracle-l


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.