FIGURE 12-8 Image copy backup of a tablespace using OEM
444 Oracle Database 11g DBA Handbook
Control File, SPFILE Backup
To back up the control file and SPFILE manually, use the following RMAN command:
RMAN> backup current controlfile spfile;
Starting backup at 30-AUG-07
starting full resync of recovery catalog
full resync complete
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 30-AUG-07
channel ORA_DISK_1: finished piece 1 at 30-AUG-07
piece handle=+RECOV/dw/backupset/2007_08_30/
ncnnf0_tag20070830t220903_0.311.632009363 tag=TAG20070830T220903
comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting compressed 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 30-AUG-07
channel ORA_DISK_1: finished piece 1 at 30-AUG-07
piece handle=+RECOV/dw/backupset/2007_08_30/
nnsnf0_tag20070830t220903_0.312.632009383 tag=TAG20070830T220903
comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 30-AUG-07
Starting Control File and SPFILE Autobackup at 30-AUG-07
piece handle=+RECOV/dw/autobackup/2007_08_30/
s_632009385.313.632009397 comment=NONE
Finished Control File and SPFILE Autobackup at 30-AUG-07
RMAN>
Note that because we already had autobackup set to on, we actually performed two backups
of the control file and the SPFILE.
Pages:
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686