Question On Data Guard And Database Refreshes
From: Scott Canaan <srcdco_at_rit.edu>
Date: Fri, 06 Jun 2014 17:34:48 +0000
Message-id: <3653B77DCF6DDA4ABAD1E9416F1876D73FEDE509_at_ex03mail01.ad.rit.edu>
We have dived into the world of Data Guard and have it working nicely. Periodically, we get requests to refresh a test database from production to get "up-to-date" data in test. If both production and test are Data Guarded, what is the best way to do the refresh? We would like to not to have to rebuild the test secondary database if at all possible. We don't use RMAN for backups. We are looking at using Data Pump between production and test and letting Data Guard update the secondary from there.
Date: Fri, 06 Jun 2014 17:34:48 +0000
Message-id: <3653B77DCF6DDA4ABAD1E9416F1876D73FEDE509_at_ex03mail01.ad.rit.edu>
We have dived into the world of Data Guard and have it working nicely. Periodically, we get requests to refresh a test database from production to get "up-to-date" data in test. If both production and test are Data Guarded, what is the best way to do the refresh? We would like to not to have to rebuild the test secondary database if at all possible. We don't use RMAN for backups. We are looking at using Data Pump between production and test and letting Data Guard update the secondary from there.
Is there a better way, without purchasing a tool?
We are using Oracle 11.2.0.3 on Red Hat Linux.
Thank you,
Scott Canaan '88 (srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>)
(585) 475-7886 - work (585) 339-8659 - cell"Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 06 2014 - 19:34:48 CEST