1. RMAN script file to run from the commandline
# redirect the copy of database to different location
run
{
backup
as copy
db_file_name_convert=('+DATA/CVRman/Datafile/','/SHARED/backup1/')
tag="redirect_copy"
database;
}
2. Script called in the command line to run the redirect copy to different location
rman target="/" @ rman_5.cmd | tee -a rman_5.log
Recovery Manager: Release 11.2.0.4.0 - Production on Wed May 14 01:26:49 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: CVRMAN (DBID=657566608)
RMAN> # redirect the copy of database to different location
2> run
3> {
4> backup
5> as copy
6> db_file_name_convert=('+DATA/CVRman/Datafile/','/SHARED/backup1/')
7> tag="redirect_copy"
8> database;
9> }
10>
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 datafile file number=00001 name=+DATA/cvrman/datafile/system.256.847354793
output file name=/SHARED/backup1/system.256.847354793 tag=REDIRECT_COPY RECID=15 STAMP=847502867
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=+DATA/cvrman/datafile/sysaux.257.847354793
output file name=/SHARED/backup1/sysaux.257.847354793 tag=REDIRECT_COPY RECID=16 STAMP=847502910
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=+DATA/cvrman/datafile/example.dbf
output file name=/SHARED/backup1/example.dbf tag=REDIRECT_COPY RECID=17 STAMP=847502934
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=+DATA/cvrman/datafile/undotbs1.258.847354795
output file name=/SHARED/backup1/undotbs1.258.847354795 tag=REDIRECT_COPY RECID=18 STAMP=847502940
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00006 name=+DATA/cvrman/datafile/tbs1.294.847433665
output file name=/SHARED/backup1/tbs1.294.847433665 tag=REDIRECT_COPY RECID=19 STAMP=847502944
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=+DATA/cvrman/controlfile/backup.306.847502945 tag=REDIRECT_COPY RECID=20 STAMP=847502946
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=+DATA/cvrman/datafile/users.259.847354795
output file name=/SHARED/backup1/users.259.847354795 tag=REDIRECT_COPY RECID=21 STAMP=847502948
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 14-MAY-14
channel ORA_DISK_1: finished piece 1 at 14-MAY-14
piece handle=+DATA/cvrman/backupset/2014_05_14/nnsnf0_redirect_copy_0.314.847502949 tag=REDIRECT_COPY comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 14-MAY-14
Recovery Manager complete.
3.List the copy of the database with tag "REDIRECT_COPY"
rman target="/"
Recovery Manager: Release 11.2.0.4.0 - Production on Wed May 14 01:32:01 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: CVRMAN (DBID=657566608)
RMAN> list copy of database tag="REDIRECT_COPY"
2> ;
using target database control file instead of recovery catalog
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time
------- ---- - --------------- ---------- ---------------
15 1 A 14-MAY-14 1053021 14-MAY-14
Name: /SHARED/backup1/system.256.847354793
Tag: REDIRECT_COPY
16 2 A 14-MAY-14 1053042 14-MAY-14
Name: /SHARED/backup1/sysaux.257.847354793
Tag: REDIRECT_COPY
18 3 A 14-MAY-14 1053064 14-MAY-14
Name: /SHARED/backup1/undotbs1.258.847354795
Tag: REDIRECT_COPY
21 4 A 14-MAY-14 1053072 14-MAY-14
Name: /SHARED/backup1/users.259.847354795
Tag: REDIRECT_COPY
17 5 A 14-MAY-14 1053055 14-MAY-14
Name: /SHARED/backup1/example.dbf
Tag: REDIRECT_COPY
19 6 A 14-MAY-14 1053070 14-MAY-14
Name: /SHARED/backup1/tbs1.294.847433665
Tag: REDIRECT_COPY
