Re: Question On Data Guard And Database Refreshes
- From: Kenny Payton <k3nnyp@xxxxxxxxx>
- To: srcdco@xxxxxxx
- Date: Fri, 6 Jun 2014 15:18:37 -0400
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" <srcdco@xxxxxxx> 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 “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@xxxxxxx)
>
> (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
>
>
>
Other related posts:
