Hi Mladen,
We are using a tape location rather than disk location and when I was
looking into this script (had to fix it when we upgraded to 11G) I am
pretty sure I could not do that with backup location.
But....We had to refresh and make it work asap and this worked as we
wanted, so have to admit I may not have exhausted all research/testing
avenues.
Jack
Jack van Zanen
-------------------------
This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient. If you are not the intended recipient,
please be aware that any disclosure, copying, distribution or use of this
e-mail or any attachment is prohibited. If you have received this e-mail in
error, please contact the sender and delete all copies.
Thank you for your cooperation
On Thu, Feb 4, 2016 at 11:48 AM, Mladen Gogala <gogala.mladen@xxxxxxxxx>
wrote:
On 02/03/2016 04:56 PM, Jack van Zanen wrote:
We had the same issue and resolved as well by not connecting to the
target, just the catalog.
Our backups are on tape though, so that should not be a show stopper.
connect catalog <rman_user>/<password>@<catalog>
connect auxiliary /
set echo on;
run {
set until scn <scn number>;
set dbid <dbid>;
allocate auxiliary channel ch1 type sbt parms
'ENV=(TDPO_OPTFILE=<path>dr.opt)';
duplicate database <prod> to <test>
skip tablespace
.................
.................
.................
Jack van Zanen
Hi Jack,
That is actually a very cool new feature of the 11GR2 database, called
"target-less duplicate". You don't even need catalog to do that, you can
use "BACKUP LOCATION" parameter instead. That is well documented on Tim
Hall's page:
https://oracle-base.com/articles/11g/duplicate-database-using-rman-11gr2#backup_based_duplication
It is no longer necessary to connect to the target database, in order to
duplicate it. With the catalog, you may need the "DBID" argument if you
have several databases named "PROD". The statement would look like this:
duplicate database PROD DBID 1234567890 to TEST
SKIP TABLESPACE ....
Regards
--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217
--
//www.freelists.org/webpage/oracle-l
