Re: Any way to force RMAN to skip TTS self-containment check?
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 3 Feb 2016 19:48:10 -0500
Message-ID: <56B29FCA.1070300_at_gmail.com>
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
Date: Wed, 3 Feb 2016 19:48:10 -0500
Message-ID: <56B29FCA.1070300_at_gmail.com>
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:
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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 04 2016 - 01:48:10 CET