Re: Any way to force RMAN to skip TTS self-containment check?

From: Mladen Gogala <>
Date: Wed, 3 Feb 2016 19:48:10 -0500
Message-ID: <>

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>_at_<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:

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

Received on Thu Feb 04 2016 - 01:48:10 CET

Original text of this message