1. Create RMAN command file that use two substitution variables.
cat rman_3.cmd
#Take rman backup of database including current controlfile
connect target /
run
{
backup database
tag "&1"
format="+&2"
;
}
list backup of database
tag="&1";
cat rman_script.sh
#!/bin/sh
arg1="$1"
arg2="$2"
rman cmdfile="rman_3.cmd" using $arg1 $arg2
exit 0;
2. Run the rman_script.sh by passing two arguments ,first is the tag name and second is the format value
sh rman_script.sh full_backup DATA
Recovery Manager: Release 11.2.0.4.0 - Production on Tue May 13 05:42:18 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN> #Take rman backup of database including current controlfile
2> connect target *
3> run
4> {
5> backup database
6> tag "full_backup"
7> format="+DATA"
8> ;
9> }
10> list backup of database
11> tag="full_backup";
12>
13>
connected to target database: CVRMAN (DBID=657566608)
Starting backup at 13-MAY-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=47 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/cvrman/datafile/system.256.847354793
input datafile file number=00002 name=+DATA/cvrman/datafile/sysaux.257.847354793
input datafile file number=00005 name=+DATA/cvrman/datafile/example.dbf
input datafile file number=00003 name=+DATA/cvrman/datafile/undotbs1.258.847354795
input datafile file number=00004 name=+DATA/cvrman/datafile/users.259.847354795
channel ORA_DISK_1: starting piece 1 at 13-MAY-14
channel ORA_DISK_1: finished piece 1 at 13-MAY-14
piece handle=+DATA/cvrman/backupset/2014_05_13/nnndf0_full_backup_0.290.847431749 tag=FULL_BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 13-MAY-14
channel ORA_DISK_1: finished piece 1 at 13-MAY-14
piece handle=+DATA/cvrman/backupset/2014_05_13/ncsnf0_full_backup_0.292.847431825 tag=FULL_BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 13-MAY-14
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17 Full 1.06G DISK 00:01:14 13-MAY-14
BP Key: 17 Status: AVAILABLE Compressed: NO Tag: FULL_BACKUP
Piece Name: +DATA/cvrman/backupset/2014_05_13/nnndf0_full_backup_0.290.847431749
List of Datafiles in backup set 17
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1012322 13-MAY-14 +DATA/cvrman/datafile/system.256.847354793
2 Full 1012322 13-MAY-14 +DATA/cvrman/datafile/sysaux.257.847354793
3 Full 1012322 13-MAY-14 +DATA/cvrman/datafile/undotbs1.258.847354795
4 Full 1012322 13-MAY-14 +DATA/cvrman/datafile/users.259.847354795
5 Full 1012322 13-MAY-14 +DATA/cvrman/datafile/example.dbf
Recovery Manager complete.
