Below is the method I use :
RMAN> run{
2> delete noprompt backup;
3> backup as compressed backupset database format 'F:\oracle\oradata\LSTDBY\bkp\full_bkp_%U';
4> backup as compressed backupset archivelog all format 'F:\oracle\oradata\LSTDBY\bkp\%d_%s_%p_%U.arc' delete all input;
5> backup as copy current controlfile format 'F:\oracle\oradata\LSTDBY\bkp\control.bkp';
6> }
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
29 29 1 1 AVAILABLE DISK F:\ORACLE\ORADATA\LSTDBY\BKP\NEW1_98_1_32MDP7JA_1_1.ARC
deleted backup piece
backup piece handle=F:\ORACLE\ORADATA\LSTDBY\BKP\NEW1_98_1_32MDP7JA_1_1.ARC recid=29 stamp=752655980
Deleted 1 objects
Starting backup at 01-JUN-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=F:\ORACLE\ORADATA\STDBY1\SYSTEM.DBF
input datafile fno=00003 name=F:\ORACLE\ORADATA\STDBY1\SYSAUX.DBF
input datafile fno=00002 name=F:\ORACLE\ORADATA\STDBY1\UNDO.DBF
channel ORA_DISK_1: starting piece 1 at 01-JUN-11
channel ORA_DISK_1: finished piece 1 at 01-JUN-11
piece handle=F:\ORACLE\ORADATA\LSTDBY\BKP\FULL_BKP_33MDP7L0_1_1 tag=TAG20110601T070711 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 01-JUN-11
channel ORA_DISK_1: finished piece 1 at 01-JUN-11
piece handle=F:\ORACLE\ORADATA\LSTDBY\BKP\FULL_BKP_34MDP7MD_1_1 tag=TAG20110601T070711 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 01-JUN-11
Starting backup at 01-JUN-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=93 recid=1 stamp=752203699
input archive log thread=1 sequence=94 recid=4 stamp=752203700
input archive log thread=1 sequence=95 recid=5 stamp=752203700
input archive log thread=1 sequence=96 recid=2 stamp=752203699
input archive log thread=1 sequence=97 recid=3 stamp=752203700
input archive log thread=1 sequence=98 recid=6 stamp=752203704
input archive log thread=1 sequence=99 recid=8 stamp=752203705
input archive log thread=1 sequence=100 recid=7 stamp=752203705
input archive log thread=1 sequence=101 recid=14 stamp=752203760
input archive log thread=1 sequence=102 recid=10 stamp=752203759
input archive log thread=1 sequence=103 recid=13 stamp=752203760
input archive log thread=1 sequence=104 recid=12 stamp=752203760
input archive log thread=1 sequence=105 recid=11 stamp=752203759
input archive log thread=1 sequence=106 recid=9 stamp=752203706
input archive log thread=1 sequence=107 recid=15 stamp=752203829
input archive log thread=1 sequence=108 recid=16 stamp=752206375
input archive log thread=1 sequence=109 recid=17 stamp=752206379
input archive log thread=1 sequence=110 recid=18 stamp=752208664
input archive log thread=1 sequence=111 recid=19 stamp=752231644
input archive log thread=1 sequence=112 recid=20 stamp=752241984
input archive log thread=1 sequence=113 recid=21 stamp=752241988
input archive log thread=1 sequence=114 recid=22 stamp=752284429
input archive log thread=1 sequence=115 recid=23 stamp=752284430
input archive log thread=1 sequence=116 recid=24 stamp=752284437
input archive log thread=1 sequence=117 recid=25 stamp=752306407
input archive log thread=1 sequence=118 recid=26 stamp=752320462
input archive log thread=1 sequence=119 recid=27 stamp=752320469
input archive log thread=1 sequence=120 recid=28 stamp=752348736
input archive log thread=1 sequence=121 recid=29 stamp=752360623
input archive log thread=1 sequence=122 recid=30 stamp=752629379
input archive log thread=1 sequence=123 recid=31 stamp=752629381
input archive log thread=1 sequence=124 recid=32 stamp=752629382
input archive log thread=1 sequence=125 recid=33 stamp=752632827
input archive log thread=1 sequence=126 recid=34 stamp=752632833
input archive log thread=1 sequence=127 recid=35 stamp=752633148
input archive log thread=1 sequence=128 recid=36 stamp=752633378
input archive log thread=1 sequence=129 recid=38 stamp=752636349
input archive log thread=1 sequence=130 recid=37 stamp=752636348
input archive log thread=1 sequence=131 recid=39 stamp=752636349
input archive log thread=1 sequence=132 recid=40 stamp=752636411
input archive log thread=1 sequence=133 recid=42 stamp=752654062
input archive log thread=1 sequence=134 recid=41 stamp=752654061
input archive log thread=1 sequence=135 recid=43 stamp=752654112
channel ORA_DISK_1: starting piece 1 at 01-JUN-11
channel ORA_DISK_1: finished piece 1 at 01-JUN-11
piece handle=F:\ORACLE\ORADATA\LSTDBY\BKP\NEW1_101_1_35MDP7MI_1_1.ARC tag=TAG20110601T070801 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:09
channel ORA_DISK_1: deleting archive log(s)
archive log filename=F:\ORACLE\ARCH\STDBY1\1_93_751864795.ARC recid=1 stamp=752203699
archive log filename=F:\ORACLE\ARCH\STDBY1\1_94_751864795.ARC recid=4 stamp=752203700
archive log filename=F:\ORACLE\ARCH\STDBY1\1_95_751864795.ARC recid=5 stamp=752203700
archive log filename=F:\ORACLE\ARCH\STDBY1\1_96_751864795.ARC recid=2 stamp=752203699
archive log filename=F:\ORACLE\ARCH\STDBY1\1_97_751864795.ARC recid=3 stamp=752203700
archive log filename=F:\ORACLE\ARCH\STDBY1\1_98_751864795.ARC recid=6 stamp=752203704
archive log filename=F:\ORACLE\ARCH\STDBY1\1_99_751864795.ARC recid=8 stamp=752203705
archive log filename=F:\ORACLE\ARCH\STDBY1\1_100_751864795.ARC recid=7 stamp=752203705
archive log filename=F:\ORACLE\ARCH\STDBY1\1_101_751864795.ARC recid=14 stamp=752203760
archive log filename=F:\ORACLE\ARCH\STDBY1\1_102_751864795.ARC recid=10 stamp=752203759
archive log filename=F:\ORACLE\ARCH\STDBY1\1_103_751864795.ARC recid=13 stamp=752203760
archive log filename=F:\ORACLE\ARCH\STDBY1\1_104_751864795.ARC recid=12 stamp=752203760
archive log filename=F:\ORACLE\ARCH\STDBY1\1_105_751864795.ARC recid=11 stamp=752203759
archive log filename=F:\ORACLE\ARCH\STDBY1\1_106_751864795.ARC recid=9 stamp=752203706
archive log filename=F:\ORACLE\ARCH\STDBY1\1_107_751864795.ARC recid=15 stamp=752203829
archive log filename=F:\ORACLE\ARCH\STDBY1\1_108_751864795.ARC recid=16 stamp=752206375
archive log filename=F:\ORACLE\ARCH\STDBY1\1_109_751864795.ARC recid=17 stamp=752206379
archive log filename=F:\ORACLE\ARCH\STDBY1\1_110_751864795.ARC recid=18 stamp=752208664
archive log filename=F:\ORACLE\ARCH\STDBY1\1_111_751864795.ARC recid=19 stamp=752231644
archive log filename=F:\ORACLE\ARCH\STDBY1\1_112_751864795.ARC recid=20 stamp=752241984
archive log filename=F:\ORACLE\ARCH\STDBY1\1_113_751864795.ARC recid=21 stamp=752241988
archive log filename=F:\ORACLE\ARCH\STDBY1\1_114_751864795.ARC recid=22 stamp=752284429
archive log filename=F:\ORACLE\ARCH\STDBY1\1_115_751864795.ARC recid=23 stamp=752284430
archive log filename=F:\ORACLE\ARCH\STDBY1\1_116_751864795.ARC recid=24 stamp=752284437
archive log filename=F:\ORACLE\ARCH\STDBY1\1_117_751864795.ARC recid=25 stamp=752306407
archive log filename=F:\ORACLE\ARCH\STDBY1\1_118_751864795.ARC recid=26 stamp=752320462
archive log filename=F:\ORACLE\ARCH\STDBY1\1_119_751864795.ARC recid=27 stamp=752320469
archive log filename=F:\ORACLE\ARCH\STDBY1\1_120_751864795.ARC recid=28 stamp=752348736
archive log filename=F:\ORACLE\ARCH\STDBY1\1_121_751864795.ARC recid=29 stamp=752360623
archive log filename=F:\ORACLE\ARCH\STDBY1\1_122_751864795.ARC recid=30 stamp=752629379
archive log filename=F:\ORACLE\ARCH\STDBY1\1_123_751864795.ARC recid=31 stamp=752629381
archive log filename=F:\ORACLE\ARCH\STDBY1\1_124_751864795.ARC recid=32 stamp=752629382
archive log filename=F:\ORACLE\ARCH\STDBY1\1_125_751864795.ARC recid=33 stamp=752632827
archive log filename=F:\ORACLE\ARCH\STDBY1\1_126_751864795.ARC recid=34 stamp=752632833
archive log filename=F:\ORACLE\ARCH\STDBY1\1_127_751864795.ARC recid=35 stamp=752633148
archive log filename=F:\ORACLE\ARCH\STDBY1\1_128_751864795.ARC recid=36 stamp=752633378
archive log filename=F:\ORACLE\ARCH\STDBY1\1_129_751864795.ARC recid=38 stamp=752636349
archive log filename=F:\ORACLE\ARCH\STDBY1\1_130_751864795.ARC recid=37 stamp=752636348
archive log filename=F:\ORACLE\ARCH\STDBY1\1_131_751864795.ARC recid=39 stamp=752636349
archive log filename=F:\ORACLE\ARCH\STDBY1\1_132_751864795.ARC recid=40 stamp=752636411
archive log filename=F:\ORACLE\ARCH\STDBY1\1_133_751864795.ARC recid=42 stamp=752654062
archive log filename=F:\ORACLE\ARCH\STDBY1\1_134_751864795.ARC recid=41 stamp=752654061
archive log filename=F:\ORACLE\ARCH\STDBY1\1_135_751864795.ARC recid=43 stamp=752654112
Finished backup at 01-JUN-11
Starting backup at 01-JUN-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying current control file
output filename=F:\ORACLE\ORADATA\LSTDBY\BKP\CONTROL.BKP tag=TAG20110601T070814 recid=24 stamp=752656096
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 01-JUN-11
RMAN>
RMAN> run{
2> delete noprompt backup;
3> backup as compressed backupset database format 'F:\oracle\oradata\LSTDBY\bkp\full_bkp_%U';
4> backup as compressed backupset archivelog all format 'F:\oracle\oradata\LSTDBY\bkp\%d_%s_%p_%U.arc' delete all input;
5> backup as copy current controlfile format 'F:\oracle\oradata\LSTDBY\bkp\control.bkp';
6> }
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
29 29 1 1 AVAILABLE DISK F:\ORACLE\ORADATA\LSTDBY\BKP\NEW1_98_1_32MDP7JA_1_1.ARC
deleted backup piece
backup piece handle=F:\ORACLE\ORADATA\LSTDBY\BKP\NEW1_98_1_32MDP7JA_1_1.ARC recid=29 stamp=752655980
Deleted 1 objects
Starting backup at 01-JUN-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=F:\ORACLE\ORADATA\STDBY1\SYSTEM.DBF
input datafile fno=00003 name=F:\ORACLE\ORADATA\STDBY1\SYSAUX.DBF
input datafile fno=00002 name=F:\ORACLE\ORADATA\STDBY1\UNDO.DBF
channel ORA_DISK_1: starting piece 1 at 01-JUN-11
channel ORA_DISK_1: finished piece 1 at 01-JUN-11
piece handle=F:\ORACLE\ORADATA\LSTDBY\BKP\FULL_BKP_33MDP7L0_1_1 tag=TAG20110601T070711 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 01-JUN-11
channel ORA_DISK_1: finished piece 1 at 01-JUN-11
piece handle=F:\ORACLE\ORADATA\LSTDBY\BKP\FULL_BKP_34MDP7MD_1_1 tag=TAG20110601T070711 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 01-JUN-11
Starting backup at 01-JUN-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=93 recid=1 stamp=752203699
input archive log thread=1 sequence=94 recid=4 stamp=752203700
input archive log thread=1 sequence=95 recid=5 stamp=752203700
input archive log thread=1 sequence=96 recid=2 stamp=752203699
input archive log thread=1 sequence=97 recid=3 stamp=752203700
input archive log thread=1 sequence=98 recid=6 stamp=752203704
input archive log thread=1 sequence=99 recid=8 stamp=752203705
input archive log thread=1 sequence=100 recid=7 stamp=752203705
input archive log thread=1 sequence=101 recid=14 stamp=752203760
input archive log thread=1 sequence=102 recid=10 stamp=752203759
input archive log thread=1 sequence=103 recid=13 stamp=752203760
input archive log thread=1 sequence=104 recid=12 stamp=752203760
input archive log thread=1 sequence=105 recid=11 stamp=752203759
input archive log thread=1 sequence=106 recid=9 stamp=752203706
input archive log thread=1 sequence=107 recid=15 stamp=752203829
input archive log thread=1 sequence=108 recid=16 stamp=752206375
input archive log thread=1 sequence=109 recid=17 stamp=752206379
input archive log thread=1 sequence=110 recid=18 stamp=752208664
input archive log thread=1 sequence=111 recid=19 stamp=752231644
input archive log thread=1 sequence=112 recid=20 stamp=752241984
input archive log thread=1 sequence=113 recid=21 stamp=752241988
input archive log thread=1 sequence=114 recid=22 stamp=752284429
input archive log thread=1 sequence=115 recid=23 stamp=752284430
input archive log thread=1 sequence=116 recid=24 stamp=752284437
input archive log thread=1 sequence=117 recid=25 stamp=752306407
input archive log thread=1 sequence=118 recid=26 stamp=752320462
input archive log thread=1 sequence=119 recid=27 stamp=752320469
input archive log thread=1 sequence=120 recid=28 stamp=752348736
input archive log thread=1 sequence=121 recid=29 stamp=752360623
input archive log thread=1 sequence=122 recid=30 stamp=752629379
input archive log thread=1 sequence=123 recid=31 stamp=752629381
input archive log thread=1 sequence=124 recid=32 stamp=752629382
input archive log thread=1 sequence=125 recid=33 stamp=752632827
input archive log thread=1 sequence=126 recid=34 stamp=752632833
input archive log thread=1 sequence=127 recid=35 stamp=752633148
input archive log thread=1 sequence=128 recid=36 stamp=752633378
input archive log thread=1 sequence=129 recid=38 stamp=752636349
input archive log thread=1 sequence=130 recid=37 stamp=752636348
input archive log thread=1 sequence=131 recid=39 stamp=752636349
input archive log thread=1 sequence=132 recid=40 stamp=752636411
input archive log thread=1 sequence=133 recid=42 stamp=752654062
input archive log thread=1 sequence=134 recid=41 stamp=752654061
input archive log thread=1 sequence=135 recid=43 stamp=752654112
channel ORA_DISK_1: starting piece 1 at 01-JUN-11
channel ORA_DISK_1: finished piece 1 at 01-JUN-11
piece handle=F:\ORACLE\ORADATA\LSTDBY\BKP\NEW1_101_1_35MDP7MI_1_1.ARC tag=TAG20110601T070801 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:09
channel ORA_DISK_1: deleting archive log(s)
archive log filename=F:\ORACLE\ARCH\STDBY1\1_93_751864795.ARC recid=1 stamp=752203699
archive log filename=F:\ORACLE\ARCH\STDBY1\1_94_751864795.ARC recid=4 stamp=752203700
archive log filename=F:\ORACLE\ARCH\STDBY1\1_95_751864795.ARC recid=5 stamp=752203700
archive log filename=F:\ORACLE\ARCH\STDBY1\1_96_751864795.ARC recid=2 stamp=752203699
archive log filename=F:\ORACLE\ARCH\STDBY1\1_97_751864795.ARC recid=3 stamp=752203700
archive log filename=F:\ORACLE\ARCH\STDBY1\1_98_751864795.ARC recid=6 stamp=752203704
archive log filename=F:\ORACLE\ARCH\STDBY1\1_99_751864795.ARC recid=8 stamp=752203705
archive log filename=F:\ORACLE\ARCH\STDBY1\1_100_751864795.ARC recid=7 stamp=752203705
archive log filename=F:\ORACLE\ARCH\STDBY1\1_101_751864795.ARC recid=14 stamp=752203760
archive log filename=F:\ORACLE\ARCH\STDBY1\1_102_751864795.ARC recid=10 stamp=752203759
archive log filename=F:\ORACLE\ARCH\STDBY1\1_103_751864795.ARC recid=13 stamp=752203760
archive log filename=F:\ORACLE\ARCH\STDBY1\1_104_751864795.ARC recid=12 stamp=752203760
archive log filename=F:\ORACLE\ARCH\STDBY1\1_105_751864795.ARC recid=11 stamp=752203759
archive log filename=F:\ORACLE\ARCH\STDBY1\1_106_751864795.ARC recid=9 stamp=752203706
archive log filename=F:\ORACLE\ARCH\STDBY1\1_107_751864795.ARC recid=15 stamp=752203829
archive log filename=F:\ORACLE\ARCH\STDBY1\1_108_751864795.ARC recid=16 stamp=752206375
archive log filename=F:\ORACLE\ARCH\STDBY1\1_109_751864795.ARC recid=17 stamp=752206379
archive log filename=F:\ORACLE\ARCH\STDBY1\1_110_751864795.ARC recid=18 stamp=752208664
archive log filename=F:\ORACLE\ARCH\STDBY1\1_111_751864795.ARC recid=19 stamp=752231644
archive log filename=F:\ORACLE\ARCH\STDBY1\1_112_751864795.ARC recid=20 stamp=752241984
archive log filename=F:\ORACLE\ARCH\STDBY1\1_113_751864795.ARC recid=21 stamp=752241988
archive log filename=F:\ORACLE\ARCH\STDBY1\1_114_751864795.ARC recid=22 stamp=752284429
archive log filename=F:\ORACLE\ARCH\STDBY1\1_115_751864795.ARC recid=23 stamp=752284430
archive log filename=F:\ORACLE\ARCH\STDBY1\1_116_751864795.ARC recid=24 stamp=752284437
archive log filename=F:\ORACLE\ARCH\STDBY1\1_117_751864795.ARC recid=25 stamp=752306407
archive log filename=F:\ORACLE\ARCH\STDBY1\1_118_751864795.ARC recid=26 stamp=752320462
archive log filename=F:\ORACLE\ARCH\STDBY1\1_119_751864795.ARC recid=27 stamp=752320469
archive log filename=F:\ORACLE\ARCH\STDBY1\1_120_751864795.ARC recid=28 stamp=752348736
archive log filename=F:\ORACLE\ARCH\STDBY1\1_121_751864795.ARC recid=29 stamp=752360623
archive log filename=F:\ORACLE\ARCH\STDBY1\1_122_751864795.ARC recid=30 stamp=752629379
archive log filename=F:\ORACLE\ARCH\STDBY1\1_123_751864795.ARC recid=31 stamp=752629381
archive log filename=F:\ORACLE\ARCH\STDBY1\1_124_751864795.ARC recid=32 stamp=752629382
archive log filename=F:\ORACLE\ARCH\STDBY1\1_125_751864795.ARC recid=33 stamp=752632827
archive log filename=F:\ORACLE\ARCH\STDBY1\1_126_751864795.ARC recid=34 stamp=752632833
archive log filename=F:\ORACLE\ARCH\STDBY1\1_127_751864795.ARC recid=35 stamp=752633148
archive log filename=F:\ORACLE\ARCH\STDBY1\1_128_751864795.ARC recid=36 stamp=752633378
archive log filename=F:\ORACLE\ARCH\STDBY1\1_129_751864795.ARC recid=38 stamp=752636349
archive log filename=F:\ORACLE\ARCH\STDBY1\1_130_751864795.ARC recid=37 stamp=752636348
archive log filename=F:\ORACLE\ARCH\STDBY1\1_131_751864795.ARC recid=39 stamp=752636349
archive log filename=F:\ORACLE\ARCH\STDBY1\1_132_751864795.ARC recid=40 stamp=752636411
archive log filename=F:\ORACLE\ARCH\STDBY1\1_133_751864795.ARC recid=42 stamp=752654062
archive log filename=F:\ORACLE\ARCH\STDBY1\1_134_751864795.ARC recid=41 stamp=752654061
archive log filename=F:\ORACLE\ARCH\STDBY1\1_135_751864795.ARC recid=43 stamp=752654112
Finished backup at 01-JUN-11
Starting backup at 01-JUN-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying current control file
output filename=F:\ORACLE\ORADATA\LSTDBY\BKP\CONTROL.BKP tag=TAG20110601T070814 recid=24 stamp=752656096
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 01-JUN-11
RMAN>
No comments:
Post a Comment