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 E7E721960284 for ; Fri, 6 Jun 2014 21:30:09 +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 21:30:09 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5010B2C61F; Fri, 6 Jun 2014 15:30:09 -0400 (EDT) Authentication-Results: turing.freelists.org; dkim=fail (verification failed; insecure key) header.i=@gmail.com; dkim-adsp=none (insecure policy) 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 QRsUtWp+6Eg7; Fri, 6 Jun 2014 15:30:09 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F04C02C5FB; Fri, 6 Jun 2014 15:29:27 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 06 Jun 2014 15:28:46 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B6D842C5AE for ; Fri, 6 Jun 2014 15:28:46 -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 Qgp+WyOWZofh for ; Fri, 6 Jun 2014 15:28:46 -0400 (EDT) Received: from mail-pd0-f176.google.com (mail-pd0-f176.google.com [209.85.192.176]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 72A262C5A9 for ; Fri, 6 Jun 2014 15:28:19 -0400 (EDT) Received: by mail-pd0-f176.google.com with SMTP id p10so2784716pdj.35 for ; Fri, 06 Jun 2014 12:28:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=Dz7MkmRprgCNCM56Sf6biqo91hWMcAWwRN7yWsxxU7E=; b=b5AWf6Rvz7cYitfWXymrSmT1Li5/6Sxa+aMFX4oc497Vw/l9O/vqM1V4uanZdq60E4 y4Po8WDSbdi8g0jhdy067uttTswJo05awZGLmZOoc0FKJ7vTCMETxMTAy8eYZ98ZT5hL XEKV/ygaQW0BDdYovSAYAjxI9n4GqfuO4K8LPhvRk8Lse1FerbJuXWOJPtylQLUBo6SR igZQp2Jr+FPcB6ltb70S2H152WbrnmIZ9+vk5MXJfqQAnnYPyRHO1P5RKfpEX/nAC1/I PFx555JstosfI58DgScX0EdkjyuSWenCVqYxVAkWODnEhej1wSCsD2eIR/uHpRiUr3y3 2H9Q== MIME-Version: 1.0 X-Received: by 10.68.249.2 with SMTP id yq2mr4043636pbc.70.1402082899025; Fri, 06 Jun 2014 12:28:19 -0700 (PDT) Received: by 10.70.75.10 with HTTP; Fri, 6 Jun 2014 12:28:18 -0700 (PDT) Received: by 10.70.75.10 with HTTP; Fri, 6 Jun 2014 12:28:18 -0700 (PDT) In-Reply-To: <3653B77DCF6DDA4ABAD1E9416F1876D73FEDE5C8@ex03mail01.ad.rit.edu> References: <3653B77DCF6DDA4ABAD1E9416F1876D73FEDE509@ex03mail01.ad.rit.edu> <3653B77DCF6DDA4ABAD1E9416F1876D73FEDE5C8@ex03mail01.ad.rit.edu> Date: Fri, 6 Jun 2014 15:28:18 -0400 Message-ID: Subject: RE: Question On Data Guard And Database Refreshes From: Kenny Payton To: Scott Canaan Cc: oracle-l@freelists.org Content-Type: multipart/alternative; boundary=047d7b6720722466d204fb2fdd91 X-archive-position: 54893 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: k3nnyp@gmail.com Precedence: normal Reply-To: k3nnyp@gmail.com 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 --047d7b6720722466d204fb2fdd91 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I got the idea originally, as well as example scripts, from the Oracle Press book Oracle Data Guard 11g. It doesn't require previous RMAN backups so you don't have to worry about not using it now. Essentially it's duplicating the database across the network using RMAN. Just be careful not to overrun your network connections if you're not using separate and dedicated network interfaces for data guard. Kenny On Jun 6, 2014 3:19 PM, "Scott Canaan" wrote: > Yes, that might work. We don=E2=80=99t use RMAN now because it doesn=E2= =80=99t work > nice with our current backup system. That=E2=80=99s why we aren=E2=80=99= t using it for the > refresh. > > > > Scott Canaan =E2=80=9988 (srcdco@rit.edu) > > (585) 475-7886 =E2=80=93 work (585) 339-8659 =E2=80=93 cel= l > > =E2=80=9CLife is like a sewer, what you get out of it depends on what you= put into > it.=E2=80=9D =E2=80=93 Tom Lehrer > > > > *From:* Kenny Payton [mailto:k3nnyp@gmail.com] > *Sent:* Friday, June 06, 2014 3:19 PM > *To:* Scott Canaan > *Cc:* oracle-l@freelists.org > *Subject:* Re: Question On Data Guard And Database Refreshes > > > > If you're refreshing a significant part of sizeable databases you might > find it more efficient to automate RMAN duplicate across the wire. > > Kenny > > On Jun 6, 2014 1:36 PM, "Scott Canaan" wrote: > > 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 =E2=80=9Cup-to-date=E2=80=9D data in test. If both production and te= st 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= =E2=80=99t > use RMAN for backups. We are looking at using Data Pump between producti= on > 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 =E2=80=9988 (srcdco@rit.edu) > > (585) 475-7886 =E2=80=93 work (585) 339-8659 =E2=80=93 cel= l > > =E2=80=9CLife is like a sewer, what you get out of it depends on what you= put into > it.=E2=80=9D =E2=80=93 Tom Lehrer > > > --047d7b6720722466d204fb2fdd91 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

I got the idea originally, as well as example scripts, from = the Oracle Press book Oracle Data Guard 11g.

It doesn't require previous RMAN backups so you don'= t have to worry about not using it now.=C2=A0 Essentially it's duplicat= ing the database across the network using RMAN.

Just be careful not to overrun your network connections if y= ou're not using separate and dedicated network interfaces for data guar= d.=C2=A0

Kenny

On Jun 6, 2014 3:19 PM, "Scott Canaan"= <srcdco@rit.edu> wrote:

Yes, that might work.=C2= =A0 We don=E2=80=99t use RMAN now because it doesn=E2=80=99t work nice with= our current backup system.=C2=A0 That=E2=80=99s why we aren=E2=80=99t usin= g it for the refresh.

=C2=A0

Scott Canaan =E2=80=9988 = (srcdco@rit.edu)

(585) 475-7886 =E2= =80=93 work=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 (585) 339-8659 =E2=80=93 cell

=E2=80=9CLife is like a s= ewer, what you get out of it depends on what you put into it.=E2=80=9D =E2= =80=93 Tom Lehrer

=C2=A0

From: Kenny Pa= yton [mailto:k3nnyp@g= mail.com]
Sent: Friday, June 06, 2014 3:19 PM
To: Scott Canaan
Cc: orac= le-l@freelists.org
Subject: Re: Question On Data Guard And Database Refreshes=

=C2=A0

If you're refreshing a significant part of sizeable databases you mi= ght find it more efficient to automate RMAN duplicate across the wire.

Kenny

On Jun 6, 2014 1:36 PM, "Scott Canaan" <= ;srcdco@rit.edu>= wrote:

We have dived into the world of Data Guard and have = it working nicely.=C2=A0 Periodically, we get requests to refresh a test da= tabase from production to get =E2=80=9Cup-to-date=E2=80=9D data in test.=C2= =A0 If both production and test are Data Guarded, what is the best way to do t= he refresh?=C2=A0 We would like to not to have to rebuild the test secondar= y database if at all possible.=C2=A0 We don=E2=80=99t use RMAN for backups.= =C2=A0 We are looking at using Data Pump between production and test and letting Data Guard update the secondary from there.=

=C2=A0

Is there a better way, without purchasing a tool?=

=C2=A0

We are using Oracle 11.2.0.3 on Red Hat Linux.

=C2=A0

Thank you,

=C2=A0

Scott Canaan =E2=80=9988 (srcdco@rit.edu)

(585) 475-7886 =E2=80=93 work=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 (585) 339-8659 = =E2=80=93 cell

=E2=80=9CLife is like a sewer, what you get out of i= t depends on what you put into it.=E2=80=9D =E2=80=93 Tom Lehrer<= /u>

=C2=A0

--047d7b6720722466d204fb2fdd91-- -- http://www.freelists.org/webpage/oracle-l