RMAN Copy from image copy using tag at database level and tablespace level

1.Script file to take copy from image copy at database level and tablespace level

cat rman_6.cmd
# To take a copy of the image copy with specific tag for copy of database as well as tablespace level copy
run
{
backup as copy
tag="NEW_REDIRECT_COPY"
COPY OF DATABASE
FROM TAG ="REDIRECT_COPY"; # Database level copy
BACKUP AS COPY
TAG="NEW_REDIRECT_TBS_COPY"  #Tablespace level copy
COPY OF TABLESPACE EXAMPLE FROM TAG="REDIRECT_COPY"
COPY OF TABLESPACE SYSTEM FROM TAG="NEW_DIRECT_COPY";
}

2.script called from the RMAN command line

rman target="/" @ rman_6.cmd | tee -a rman_6.log

Recovery Manager: Release 11.2.0.4.0 - Production on Wed May 14 01:46:40 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: CVRMAN (DBID=657566608)

RMAN> # To take a copy of the image copy with specific tag for copy of database as well as tablespace level copy
2> run
3> {
4> backup as copy
5> tag="NEW_REDIRECT_COPY"
6> COPY OF DATABASE
7> FROM TAG ="REDIRECT_COPY";
8> BACKUP AS COPY
9> TAG="NEW_REDIRECT_TBS_COPY"
10> COPY OF TABLESPACE EXAMPLE FROM TAG="REDIRECT_COPY"
11> COPY OF TABLESPACE SYSTEM FROM TAG="NEW_REDIRECT_COPY";
12> }
13>
14>
Starting backup at 14-MAY-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=24 device type=DISK
channel ORA_DISK_1: starting datafile copy
input is copy of datafile 00001: /SHARED/backup1/system.256.847354793
output file name=+DATA/cvrman/datafile/system.315.847504011 tag=NEW_REDIRECT_COPY RECID=22 STAMP=847504027
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input is copy of datafile 00002: /SHARED/backup1/sysaux.257.847354793
output file name=+DATA/cvrman/datafile/sysaux.316.847504037 tag=NEW_REDIRECT_COPY RECID=23 STAMP=847504049
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input is copy of datafile 00005: /SHARED/backup1/example.dbf
output file name=+DATA/cvrman/datafile/example.274.847504053 tag=NEW_REDIRECT_COPY RECID=24 STAMP=847504060
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input is copy of datafile 00003: /SHARED/backup1/undotbs1.258.847354795
output file name=+DATA/cvrman/datafile/undotbs1.279.847504069 tag=NEW_REDIRECT_COPY RECID=25 STAMP=847504069
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:04
channel ORA_DISK_1: starting datafile copy
input is copy of datafile 00006: /SHARED/backup1/tbs1.294.847433665
output file name=+DATA/cvrman/datafile/tbs1.277.847504071 tag=NEW_REDIRECT_COPY RECID=26 STAMP=847504071
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input is copy of datafile 00004: /SHARED/backup1/users.259.847354795
output file name=+DATA/cvrman/datafile/users.278.847504073 tag=NEW_REDIRECT_COPY RECID=27 STAMP=847504073
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 14-MAY-14



Starting backup at 14-MAY-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input is copy of datafile 00001: +DATA/cvrman/datafile/system.315.847504011
output file name=+DATA/cvrman/datafile/system.296.847504077 tag=NEW_REDIRECT_TBS_COPY RECID=28 STAMP=847504116
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:46
channel ORA_DISK_1: starting datafile copy
input is copy of datafile 00005: /SHARED/backup1/example.dbf
output file name=+DATA/cvrman/datafile/example.297.847504123 tag=NEW_REDIRECT_TBS_COPY RECID=29 STAMP=847504130
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
Finished backup at 14-MAY-14

Recovery Manager complete.

3.List the copy with tag NEW_REDIRECTT_TBS_COPY

RMAN> list copy
2> tag="NEW_REDIRECT_TBS_COPY";

specification does not match any control file copy in the repository
List of Datafile Copies
=======================

Key     File S Completion Time Ckp SCN    Ckp Time
------- ---- - --------------- ---------- ---------------
28      1    A 14-MAY-14       1053021    14-MAY-14
        Name: +DATA/cvrman/datafile/system.296.847504077
        Tag: NEW_REDIRECT_TBS_COPY

29      5    A 14-MAY-14       1053055    14-MAY-14
        Name: +DATA/cvrman/datafile/example.297.847504123
        Tag: NEW_REDIRECT_TBS_COPY