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

From: Jack van Zanen <jack_at_vanzanen.com>
Date: Thu, 4 Feb 2016 08:56:20 +1100
Message-ID: <CAFeFPA_LdpyW8YAj036oFkDzaMKw1wXeGWSvqJwjm+BrAm+x7w_at_mail.gmail.com>

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

---

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 Wed, Feb 3, 2016 at 8:20 AM, Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:

> I wanted to do that, but the backup pieces are on Netbackup library and I
> think backup location has to be a disk location and I'm not sure which
> backup pieces I need. I should have been using a catalog for these so I'm
> going to remedy that situation shortly so next time I can do the duplicate
> using just the catalog without connecting to the target.
>
> Chris
>
>
> On Tue, Feb 2, 2016 at 3:05 PM, Peter Khmelnitsky <
> peter.khmelnitsky_at_qmassociates.com> wrote:
>
>> Hi
>>
>> I had this problem before. The so;lution is:
>>
>> 1.Use RMAN backup as a source.
>> 2.Do not use target and use :
>> The RMAN command should look like this:
>>
>> RMAN>
>> connect auxiliary /
>> run
>> {
>> allocate auxiliary channel c1 device type disk;
>> allocate auxiliary channel c2 device type disk;
>> allocate auxiliary channel c3 device type disk;
>> duplicate database to <db_name_of_clone database> *backup location*
>> <the location of all backup pieces>
>> until time "to_date('02/09/2016 17:00', 'MM/DD/YYYY HH24:MI')"
>> skip tablespace <list of tablespaces you want to skip>
>> }
>>
>> As there is no connection to the target it will be no TTS check and
>> duplicate will proceed without it.
>> I sucssefully used this approach since we mover to 11g from 10g
>>
>> Yours
>> Peter
>>
>>
>> From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
>> To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>,
>> Date: 02/02/2016 12:52 PM
>> Subject: Any way to force RMAN to skip TTS self-containment check?
>> Sent by: oracle-l-bounce_at_freelists.org
>> ------------------------------
>>
>>
>>
>> This is related to my earlier question about RMAN and CONTEXT INDEXES
>> existing. The version is 11.2.0.2.
>>
>> Thanks!
>>
>> Chris
>>
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 03 2016 - 22:56:20 CET