would be nice to be able to override the check with just a parameter...
We know they are not self contained and need to do a cleanup at the end.
how about a warning and a are you sure?
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 8:56 AM, Jack van Zanen <jack@xxxxxxxxxxxx> 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
-------------------------
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@xxxxxxxxx> 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@xxxxxxxxxxxxxxxx> 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@xxxxxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>,
Date: 02/02/2016 12:52 PM
Subject: Any way to force RMAN to skip TTS self-containment check?
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
------------------------------
This is related to my earlier question about RMAN and CONTEXT INDEXES
existing. The version is 11.2.0.2.
Thanks!
Chris
