RE: Question On Data Guard And Database Refreshes
- From: Scott Canaan <srcdco@xxxxxxx>
- To: Kenny Payton <k3nnyp@xxxxxxxxx>
- Date: Fri, 06 Jun 2014 19:30:40 +0000
I did try this a couple of times and got errors and it would never complete.
It might have been due to the network.
Scott Canaan ’88 (srcdco@xxxxxxx<mailto: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
From: Kenny Payton [mailto:k3nnyp@xxxxxxxxx]
Sent: Friday, June 06, 2014 3:28 PM
To: Scott Canaan
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Question On Data Guard And Database Refreshes
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" <srcdco@xxxxxxx<mailto:srcdco@xxxxxxx>>
wrote:
Yes, that might work. We don’t use RMAN now because it doesn’t work nice with
our current backup system. That’s why we aren’t using it for the refresh.
Scott Canaan ’88 (srcdco@xxxxxxx<mailto:srcdco@xxxxxxx>)
(585) 475-7886<tel:%28585%29%20475-7886> – work (585)
339-8659<tel:%28585%29%20339-8659> – cell
“Life is like a sewer, what you get out of it depends on what you put into it.”
– Tom Lehrer
From: Kenny Payton [mailto:k3nnyp@xxxxxxxxx<mailto:k3nnyp@xxxxxxxxx>]
Sent: Friday, June 06, 2014 3:19 PM
To: Scott Canaan
Cc: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
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" <srcdco@xxxxxxx<mailto: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<mailto:srcdco@xxxxxxx>)
(585) 475-7886<tel:%28585%29%20475-7886> – work (585)
339-8659<tel:%28585%29%20339-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: