You add a datafile, you backup your controlfile. It’s that simple….
/dba/rman/bin/backup_controlfile contains:
run {
backup current controlfile
tag ''
format 'hotincr0_ctrfile_tsm_tapepool_%d_%s_%p_%t' ;
}
So here’s what it looks like:
W2ZZXJFF02():/dba/rman/bin>. oraenv
ORACLE_SID = [OCP04] ? OCP04
W2ZZXJFF02(OCP04):/dba/rman/bin>rman target / catalog rman@rman001
Recovery Manager: Release 10.1.0.5.0 - 64bit Production
Copyright (c) 1995, 2004, Oracle. All rights reserved.
connected to target database: OCP04 (DBID=18978123)
recovery catalog database Password:
connected to recovery catalog database
RMAN> @backup_controlfile
RMAN> run {
2> backup current controlfile
3> tag ''
4> format 'hotincr0_ctrfile_tsm_tapepool_%d_%s_%p_%t' ;
5> }
Starting backup at 17-MAR-09
starting full resync of recovery catalog
full resync complete
configuration for SBT_TAPE channel 2 is ignored
configuration for SBT_TAPE channel 3 is ignored
configuration for SBT_TAPE channel 4 is ignored
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=435 devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: Data Protection for Oracle: version 5.3.3.0
channel ORA_SBT_TAPE_1: starting full datafile backupset
channel ORA_SBT_TAPE_1: specifying datafile(s) in backupset
including current controlfile in backupset
channel ORA_SBT_TAPE_1: starting piece 1 at 17-MAR-09
channel ORA_SBT_TAPE_1: finished piece 1 at 17-MAR-09
piece handle=hotincr0_ctrfile_tsm_tapepool_OCP04_62690_1_681737754 comment=API Version 2.0,MMS Version 5.3.3.0
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:04
Finished backup at 17-MAR-09
RMAN> **end-of-file**
RMAN> quit
Recovery Manager complete.