APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
SYMPTOMS:
Database Names: UAT
RMAN DUPLICATE without TARGET fails with RMAN-03002 / RMAN-06171 :
$ rman auxiliary /
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Mar 3 03:11:38 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to auxiliary database: UAT (not mounted)
RMAN> run
2> {
3> allocate channel c1 device type disk;
4> allocate channel c2 device type disk;
5> allocate channel c3 device type disk;
6> allocate channel c4 device type disk;
7> allocate channel c5 device type disk;
8> allocate channel c6 device type disk;
9> allocate channel c7 device type disk;
10> allocate channel c8 device type disk;
11> DUPLICATE DATABASE TO 'UAT' BACKUP LOCATION '/<backup dir>/';
12> release channel t1;
13> release channel t2;
14> release channel t3;
15> release channel t4;
16> release channel t5;
17> release channel t6;
18> release channel t7;
19> release channel t8;
20> }
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 03/03/2012 03:11:49
RMAN-06171: not connected to target database
CAUSE:
In Target less RMAN DUPLICATE, if there is a need to allocate manual channels, it must be auxiliary channels only, and can not be a normal channel (a.k.a. target channel).
Therefore, following channel allocation is incorrect in target less DUPLICATE:
allocate channel c1 device type disk;
It must be changed to :
allocate auxiliary channel c1 device type disk;
SOLUTION:
Allocate AUXILIARY channels instead of normal channels. Hence the correct script is:
run
{
allocate auxiliary channel c1 device type disk;
allocate auxiliary channel c2 device type disk;
allocate auxiliary channel c3 device type disk;
allocate auxiliary channel c4 device type disk;
allocate auxiliary channel c5 device type disk;
allocate auxiliary channel c6 device type disk;
allocate auxiliary channel c7 device type disk;
allocate auxiliary channel c8 device type disk;
DUPLICATE DATABASE TO 'UAT' BACKUP LOCATION '/<backup dir>/';
release channel t1;
release channel t2;
release channel t3;
release channel t4;
release channel t5;
release channel t6;
release channel t7;
release channel t8;
}
Recent Posts
