Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id 3F3A6196026E for ; Fri, 6 Jun 2014 19:36:51 +0200 (CEST) Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTP for ; Fri, 6 Jun 2014 19:36:50 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2BC2E2C523; Fri, 6 Jun 2014 13:36:50 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id JriLleLYc2TO; Fri, 6 Jun 2014 13:36:50 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 31DDB2C50D; Fri, 6 Jun 2014 13:36:09 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 06 Jun 2014 13:35:28 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 31EF42C4DD for ; Fri, 6 Jun 2014 13:35:28 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id uf8dg7o26Jxo for ; Fri, 6 Jun 2014 13:35:20 -0400 (EDT) Received: from sc3app27.rit.edu (sc3app27.rit.edu [129.21.35.56]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 309272BF18 for ; Fri, 6 Jun 2014 13:34:51 -0400 (EDT) Received: from ex03cas01b.ad.rit.edu (ex03cas01b.ad.rit.edu [129.21.16.183]) by smtp-server.rit.edu (PMDF V6.3-x14 #31420) with ESMTPS id <0N6R0006BCU18W@smtp-server.rit.edu> for oracle-l@freelists.org; Fri, 06 Jun 2014 13:34:50 -0400 (EDT) Received: from EX03MAIL01.ad.rit.edu ([fe80::31ca:94a5:9350:8f43]) by ex03cas01b.ad.rit.edu ([fe80::9184:8c43:67e5:c43c%11]) with mapi id 14.03.0181.006; Fri, 06 Jun 2014 13:34:49 -0400 Date: Fri, 06 Jun 2014 17:34:48 +0000 From: Scott Canaan Subject: Question On Data Guard And Database Refreshes X-Originating-IP: [129.21.169.9] To: "oracle-l@freelists.org" Message-id: <3653B77DCF6DDA4ABAD1E9416F1876D73FEDE509@ex03mail01.ad.rit.edu> MIME-version: 1.0 Content-type: multipart/alternative; boundary=_000_3653B77DCF6DDA4ABAD1E9416F1876D73FEDE509ex03mail01adrit_ Content-language: en-US Thread-Topic: Question On Data Guard And Database Refreshes Accept-Language: en-US X-RIT-Received-From: 129.21.16.183 X-MS-Has-Attach: X-MS-TNEF-Correlator: X-archive-position: 54883 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: srcdco@rit.edu Precedence: normal Reply-To: srcdco@rit.edu List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --_000_3653B77DCF6DDA4ABAD1E9416F1876D73FEDE509ex03mail01adrit_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable We have dived into the world of Data Guard and have it working nicely. Per= iodically, we get requests to refresh a test database from production to ge= t "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 r= ebuild the test secondary database if at all possible. We don't use RMAN f= or 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@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 --_000_3653B77DCF6DDA4ABAD1E9416F1876D73FEDE509ex03mail01adrit_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

We have dived into the world of Data Guard and have = it working nicely.  Periodically, we get requests to refresh a test da= tabase 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 RM= AN 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.<= /o:p>

 

Thank you,

 

Scott Canaan ’88 (srcdco@rit.edu)

(585) 475-7886 – work    &= nbsp;           (585) 339= -8659 – cell

“Life is like a sewer, what you get out of it = depends on what you put into it.” – Tom Lehrer

 

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