POUWIEL|COM

JeroenPouwiel

Backup controlfile

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.

Comments are closed.

Categories