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
