Re: Any way to force RMAN to skip TTS self-containment check?
- From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 3 Feb 2016 19:48:10 -0500
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
Other related posts:
