RMAN Scripts ....................................
RUN
{
ALLOCATE CHANNEL CH1 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF1_%d_%t_%s_%p_%U';
ALLOCATE CHANNEL CH2 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF2_%d_%t_%s_%p_%U';
ALLOCATE CHANNEL CH3 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF3_%d_%t_%s_%p_%U';
ALLOCATE CHANNEL CH4 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF4_%d_%t_%s_%p_%U';
ALLOCATE CHANNEL CH5 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF5_%d_%t_%s_%p_%U';
ALLOCATE CHANNEL CH6 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF6_%d_%t_%s_%p_%U';
ALLOCATE CHANNEL CH7 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF7_%d_%t_%s_%p_%U';
ALLOCATE CHANNEL CH8 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF8_%d_%t_%s_%p_%U';
ALLOCATE CHANNEL CH9 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF9_%d_%t_%s_%p_%U';
ALLOCATE CHANNEL CH10 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF10_%d_%t_%s_%p_%U';
SET LIMIT CHANNEL CH1 KBYTES 2097152;
SET LIMIT CHANNEL CH2 KBYTES 2097152;
SET LIMIT CHANNEL CH3 KBYTES 2097152;
SET LIMIT CHANNEL CH4 KBYTES 2097152;
SET LIMIT CHANNEL CH5 KBYTES 2097152;
SET LIMIT CHANNEL CH6 KBYTES 2097152;
SET LIMIT CHANNEL CH7 KBYTES 2097152;
SET LIMIT CHANNEL CH8 KBYTES 2097152;
SET LIMIT CHANNEL CH9 KBYTES 2097152;
SET LIMIT CHANNEL CH10 KBYTES 2097152;
BACKUP DATABASE;
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
BACKUP ARCHIVELOG ALL FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_ARCHIVE_%d_%t_%s_%p_%U' DELETE INPUT;
BACKUP CURRENT CONTROLFILE
TAG = CF1
FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_CONTRL_%d_%t_%s_%p_%U';
}
Output :-
=====================================================================
RMAN> RUN
2> {
3> ALLOCATE CHANNEL CH1 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF1_%d_%t_%s_%p_%U';
4> ALLOCATE CHANNEL CH2 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF2_%d_%t_%s_%p_%U';
5> ALLOCATE CHANNEL CH3 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF3_%d_%t_%s_%p_%U';
6> ALLOCATE CHANNEL CH4 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF4_%d_%t_%s_%p_%U';
7> ALLOCATE CHANNEL CH5 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF5_%d_%t_%s_%p_%U';
8> ALLOCATE CHANNEL CH6 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF6_%d_%t_%s_%p_%U';
9> ALLOCATE CHANNEL CH7 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF7_%d_%t_%s_%p_%U';
10> ALLOCATE CHANNEL CH8 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF8_%d_%t_%s_%p_%U';
11> ALLOCATE CHANNEL CH9 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF9_%d_%t_%s_%p_%U';
12> ALLOCATE CHANNEL CH10 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF10_%d_%t_%s_%p_%U';
13> SET LIMIT CHANNEL CH1 KBYTES 2097152;
14> SET LIMIT CHANNEL CH2 KBYTES 2097152;
15> SET LIMIT CHANNEL CH3 KBYTES 2097152;
16> SET LIMIT CHANNEL CH4 KBYTES 2097152;
17> SET LIMIT CHANNEL CH5 KBYTES 2097152;
18> SET LIMIT CHANNEL CH6 KBYTES 2097152;
19> SET LIMIT CHANNEL CH7 KBYTES 2097152;
20> SET LIMIT CHANNEL CH8 KBYTES 2097152;
21> SET LIMIT CHANNEL CH9 KBYTES 2097152;
22> SET LIMIT CHANNEL CH10 KBYTES 2097152;
23> BACKUP DATABASE;
24> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
25> BACKUP ARCHIVELOG ALL FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_ARCHIVE_%d_%t_%s_%p_%U' DELETE INPUT;
26> BACKUP CURRENT CONTROLFILE
27> TAG = CF1
28> FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_CONTRL_%d_%t_%s_%p_%U';
29> }
using target database control file instead of recovery catalog
allocated channel: CH1
channel CH1: SID=10 device type=DISK
allocated channel: CH2
channel CH2: SID=9 device type=DISK
allocated channel: CH3
channel CH3: SID=133 device type=DISK
allocated channel: CH4
channel CH4: SID=196 device type=DISK
allocated channel: CH5
channel CH5: SID=12 device type=DISK
allocated channel: CH6
channel CH6: SID=74 device type=DISK
allocated channel: CH7
channel CH7: SID=135 device type=DISK
allocated channel: CH8
channel CH8: SID=198 device type=DISK
allocated channel: CH9
channel CH9: SID=5 device type=DISK
allocated channel: CH10
channel CH10: SID=73 device type=DISK
Starting backup at 18-JUL-14
channel CH1: starting full datafile backup set
channel CH1: specifying datafile(s) in backup set
input datafile file number=00008 name=D:\APP\ORADATA\SPFTL\TBFES.DBF
input datafile file number=00012 name=D:\APP\ORADATA\SPFTL\MIG_BCBL01.DBF
channel CH1: starting piece 1 at 18-JUL-14
channel CH2: starting full datafile backup set
channel CH2: specifying datafile(s) in backup set
input datafile file number=00023 name=D:\APP\ORADATA\STLBAS\ORBIMG01.DBF
input datafile file number=00029 name=D:\APP\ORADATA\ORCL\RND_TBS.DBF
input datafile file number=00016 name=D:\APP\ORADATA\STLBAS\ORBSYS01.DBF
channel CH2: starting piece 1 at 18-JUL-14
channel CH3: starting full datafile backup set
channel CH3: specifying datafile(s) in backup set
input datafile file number=00022 name=D:\APP\ORADATA\STLBAS\ORBIND01.DBF
input datafile file number=00027 name=D:\APP\ORADATA\SPFTL\SHRINK_TEST.DBF
input datafile file number=00021 name=D:\APP\ORADATA\STLBAS\ORBMAV01.DBF
channel CH3: starting piece 1 at 18-JUL-14
channel CH4: starting full datafile backup set
channel CH4: specifying datafile(s) in backup set
input datafile file number=00003 name=D:\APP\ORADATA\ORCL\UNDOTBS01.DBF
input datafile file number=00013 name=D:\APP\ORADATA\SPFTL\STLBAS01.DBF
input datafile file number=00024 name=D:\APP\ORADATA\STLBAS\ORBBBR01.DBF
channel CH4: starting piece 1 at 18-JUL-14
channel CH5: starting full datafile backup set
channel CH5: specifying datafile(s) in backup set
input datafile file number=00026 name=D:\APP\ORADATA\STLBAS\MYBANK01.DBF
input datafile file number=00002 name=D:\APP\ORADATA\ORCL\SYSAUX01.DBF
input datafile file number=00020 name=D:\APP\ORADATA\STLBAS\ORBLOG01.DBF
channel CH5: starting piece 1 at 18-JUL-14
channel CH6: starting full datafile backup set
channel CH6: specifying datafile(s) in backup set
input datafile file number=00010 name=D:\APP\ORADATA\SPFTL\DATA.DBF
input datafile file number=00007 name=D:\APP\ORADATA\SPFTL\TRBFES.DBF
input datafile file number=00028 name=D:\APP\ORADATA\ORCL\RECLAIM01.DBF
channel CH6: starting piece 1 at 18-JUL-14
channel CH7: starting full datafile backup set
channel CH7: specifying datafile(s) in backup set
input datafile file number=00001 name=D:\APP\ORADATA\ORCL\SYSTEM01.DBF
input datafile file number=00015 name=D:\APP\ORADATA\STLBAS\ORBMAS01.DBF
input datafile file number=00006 name=D:\APP\ORADATA\SPFTL\TBACNTS.DBF
channel CH7: starting piece 1 at 18-JUL-14
channel CH8: starting full datafile backup set
channel CH8: specifying datafile(s) in backup set
input datafile file number=00014 name=D:\APP\ORADATA\STLBAS\ORBITS01.DBF
input datafile file number=00025 name=D:\APP\ORADATA\ORCL\APEX_DATA01.DBF
input datafile file number=00011 name=D:\APP\ORADATA\SPFTL\TBSTRAN .DBF
channel CH8: starting piece 1 at 18-JUL-14
channel CH9: starting full datafile backup set
channel CH9: specifying datafile(s) in backup set
input datafile file number=00004 name=D:\APP\ORADATA\ORCL\USERS01.DBF
input datafile file number=00005 name=D:\APP\ORADATA\ORCL\EXAMPLE01.DBF
input datafile file number=00009 name=D:\APP\ORADATA\SPFTL\TBAML.DBF
channel CH9: starting piece 1 at 18-JUL-14
channel CH10: starting full datafile backup set
channel CH10: specifying datafile(s) in backup set
input datafile file number=00019 name=D:\APP\ORADATA\STLBAS\ORBDT301.DBF
input datafile file number=00018 name=D:\APP\ORADATA\STLBAS\ORBDT201.DBF
input datafile file number=00017 name=D:\APP\ORADATA\STLBAS\ORBDT101.DBF
channel CH10: starting piece 1 at 18-JUL-14
channel CH4: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF4_ORCL_853204137_24_1_0OPDLN59_1_1 tag=TAG20140718T010852 comment=NONE
channel CH4: backup set complete, elapsed time: 00:01:30
channel CH8: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF8_ORCL_853204150_28_1_0SPDLN5M_1_1 tag=TAG20140718T010852 comment=NONE
channel CH8: backup set complete, elapsed time: 00:05:28
channel CH3: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF3_ORCL_853204136_23_1_0NPDLN58_1_1 tag=TAG20140718T010852 comment=NONE
channel CH3: backup set complete, elapsed time: 00:08:22
channel CH6: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF6_ORCL_853204144_26_1_0QPDLN5G_1_1 tag=TAG20140718T010852 comment=NONE
channel CH6: backup set complete, elapsed time: 00:08:21
channel CH10: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF10_ORCL_853204153_30_1_0UPDLN5P_1_1 tag=TAG20140718T010852 comment=NONE
channel CH10: backup set complete, elapsed time: 00:09:05
channel CH9: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF9_ORCL_853204151_29_1_0TPDLN5N_1_1 tag=TAG20140718T010852 comment=NONE
channel CH9: backup set complete, elapsed time: 00:09:17
channel CH5: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF5_ORCL_853204139_25_1_0PPDLN5B_1_1 tag=TAG20140718T010852 comment=NONE
channel CH5: backup set complete, elapsed time: 00:11:16
channel CH7: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF7_ORCL_853204148_27_1_0RPDLN5K_1_1 tag=TAG20140718T010852 comment=NONE
channel CH7: backup set complete, elapsed time: 00:11:29
channel CH1: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF1_ORCL_853204134_21_1_0LPDLN56_1_1 tag=TAG20140718T010852 comment=NONE
channel CH1: starting piece 2 at 18-JUL-14
channel CH2: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF2_ORCL_853204135_22_1_0MPDLN57_1_1 tag=TAG20140718T010852 comment=NONE
channel CH2: starting piece 2 at 18-JUL-14
channel CH2: finished piece 2 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF2_ORCL_853204135_22_2_0MPDLN57_2_1 tag=TAG20140718T010852 comment=NONE
channel CH2: backup set complete, elapsed time: 00:14:00
channel CH1: finished piece 2 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF1_ORCL_853204134_21_2_0LPDLN56_2_1 tag=TAG20140718T010852 comment=NONE
channel CH1: starting piece 3 at 18-JUL-14
channel CH1: finished piece 3 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF1_ORCL_853204134_21_3_0LPDLN56_3_1 tag=TAG20140718T010852 comment=NONE
channel CH1: backup set complete, elapsed time: 00:16:16
Finished backup at 18-JUL-14
Starting Control File and SPFILE Autobackup at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\BKP_CF_C-1350456456-20140718-01 comment=NONE
Finished Control File and SPFILE Autobackup at 18-JUL-14
sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT
Starting backup at 18-JUL-14
current log archived
channel CH1: starting archived log backup set
channel CH1: specifying archived log(s) in backup set
input archived log thread=1 sequence=9 RECID=12 STAMP=853205123
channel CH1: starting piece 1 at 18-JUL-14
channel CH2: starting archived log backup set
channel CH2: specifying archived log(s) in backup set
input archived log thread=1 sequence=10 RECID=13 STAMP=853205124
channel CH2: starting piece 1 at 18-JUL-14
channel CH1: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_ARCHIVE_ORCL_853205125_32_1_10PDLO45_1_1 tag=TAG20140718T012524 comment=NONE
channel CH1: backup set complete, elapsed time: 00:00:02
channel CH1: deleting archived log(s)
archived log file name=D:\APP\ORADATA\ARCHIVE\ARC0000000009_0853199878.0001 RECID=12 STAMP=853205123
channel CH2: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_ARCHIVE_ORCL_853205125_33_1_11PDLO45_1_1 tag=TAG20140718T012524 comment=NONE
channel CH2: backup set complete, elapsed time: 00:00:02
channel CH2: deleting archived log(s)
archived log file name=D:\APP\ORADATA\ARCHIVE\ARC0000000010_0853199878.0001 RECID=13 STAMP=853205124
Finished backup at 18-JUL-14
Starting backup at 18-JUL-14
channel CH1: starting full datafile backup set
channel CH1: specifying datafile(s) in backup set
including current control file in backup set
channel CH1: starting piece 1 at 18-JUL-14
channel CH1: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_CONTRL_ORCL_853205133_34_1_12PDLO4D_1_1 tag=CF1 comment=NONE
channel CH1: backup set complete, elapsed time: 00:00:01
Finished backup at 18-JUL-14
Starting Control File and SPFILE Autobackup at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\BKP_CF_C-1350456456-20140718-02 comment=NONE
Finished Control File and SPFILE Autobackup at 18-JUL-14
released channel: CH1
released channel: CH2
released channel: CH3
released channel: CH4
released channel: CH5
released channel: CH6
released channel: CH7
released channel: CH8
released channel: CH9
released channel: CH10
RMAN>
RUN
{
ALLOCATE CHANNEL CH1 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF1_%d_%t_%s_%p_%U';
ALLOCATE CHANNEL CH2 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF2_%d_%t_%s_%p_%U';
ALLOCATE CHANNEL CH3 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF3_%d_%t_%s_%p_%U';
ALLOCATE CHANNEL CH4 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF4_%d_%t_%s_%p_%U';
ALLOCATE CHANNEL CH5 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF5_%d_%t_%s_%p_%U';
ALLOCATE CHANNEL CH6 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF6_%d_%t_%s_%p_%U';
ALLOCATE CHANNEL CH7 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF7_%d_%t_%s_%p_%U';
ALLOCATE CHANNEL CH8 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF8_%d_%t_%s_%p_%U';
ALLOCATE CHANNEL CH9 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF9_%d_%t_%s_%p_%U';
ALLOCATE CHANNEL CH10 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF10_%d_%t_%s_%p_%U';
SET LIMIT CHANNEL CH1 KBYTES 2097152;
SET LIMIT CHANNEL CH2 KBYTES 2097152;
SET LIMIT CHANNEL CH3 KBYTES 2097152;
SET LIMIT CHANNEL CH4 KBYTES 2097152;
SET LIMIT CHANNEL CH5 KBYTES 2097152;
SET LIMIT CHANNEL CH6 KBYTES 2097152;
SET LIMIT CHANNEL CH7 KBYTES 2097152;
SET LIMIT CHANNEL CH8 KBYTES 2097152;
SET LIMIT CHANNEL CH9 KBYTES 2097152;
SET LIMIT CHANNEL CH10 KBYTES 2097152;
BACKUP DATABASE;
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
BACKUP ARCHIVELOG ALL FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_ARCHIVE_%d_%t_%s_%p_%U' DELETE INPUT;
BACKUP CURRENT CONTROLFILE
TAG = CF1
FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_CONTRL_%d_%t_%s_%p_%U';
}
Output :-
=====================================================================
RMAN> RUN
2> {
3> ALLOCATE CHANNEL CH1 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF1_%d_%t_%s_%p_%U';
4> ALLOCATE CHANNEL CH2 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF2_%d_%t_%s_%p_%U';
5> ALLOCATE CHANNEL CH3 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF3_%d_%t_%s_%p_%U';
6> ALLOCATE CHANNEL CH4 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF4_%d_%t_%s_%p_%U';
7> ALLOCATE CHANNEL CH5 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF5_%d_%t_%s_%p_%U';
8> ALLOCATE CHANNEL CH6 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF6_%d_%t_%s_%p_%U';
9> ALLOCATE CHANNEL CH7 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF7_%d_%t_%s_%p_%U';
10> ALLOCATE CHANNEL CH8 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF8_%d_%t_%s_%p_%U';
11> ALLOCATE CHANNEL CH9 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF9_%d_%t_%s_%p_%U';
12> ALLOCATE CHANNEL CH10 TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF10_%d_%t_%s_%p_%U';
13> SET LIMIT CHANNEL CH1 KBYTES 2097152;
14> SET LIMIT CHANNEL CH2 KBYTES 2097152;
15> SET LIMIT CHANNEL CH3 KBYTES 2097152;
16> SET LIMIT CHANNEL CH4 KBYTES 2097152;
17> SET LIMIT CHANNEL CH5 KBYTES 2097152;
18> SET LIMIT CHANNEL CH6 KBYTES 2097152;
19> SET LIMIT CHANNEL CH7 KBYTES 2097152;
20> SET LIMIT CHANNEL CH8 KBYTES 2097152;
21> SET LIMIT CHANNEL CH9 KBYTES 2097152;
22> SET LIMIT CHANNEL CH10 KBYTES 2097152;
23> BACKUP DATABASE;
24> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
25> BACKUP ARCHIVELOG ALL FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_ARCHIVE_%d_%t_%s_%p_%U' DELETE INPUT;
26> BACKUP CURRENT CONTROLFILE
27> TAG = CF1
28> FORMAT 'K:\ORCL_RMAN_BACKUP\RMAN_CONTRL_%d_%t_%s_%p_%U';
29> }
using target database control file instead of recovery catalog
allocated channel: CH1
channel CH1: SID=10 device type=DISK
allocated channel: CH2
channel CH2: SID=9 device type=DISK
allocated channel: CH3
channel CH3: SID=133 device type=DISK
allocated channel: CH4
channel CH4: SID=196 device type=DISK
allocated channel: CH5
channel CH5: SID=12 device type=DISK
allocated channel: CH6
channel CH6: SID=74 device type=DISK
allocated channel: CH7
channel CH7: SID=135 device type=DISK
allocated channel: CH8
channel CH8: SID=198 device type=DISK
allocated channel: CH9
channel CH9: SID=5 device type=DISK
allocated channel: CH10
channel CH10: SID=73 device type=DISK
Starting backup at 18-JUL-14
channel CH1: starting full datafile backup set
channel CH1: specifying datafile(s) in backup set
input datafile file number=00008 name=D:\APP\ORADATA\SPFTL\TBFES.DBF
input datafile file number=00012 name=D:\APP\ORADATA\SPFTL\MIG_BCBL01.DBF
channel CH1: starting piece 1 at 18-JUL-14
channel CH2: starting full datafile backup set
channel CH2: specifying datafile(s) in backup set
input datafile file number=00023 name=D:\APP\ORADATA\STLBAS\ORBIMG01.DBF
input datafile file number=00029 name=D:\APP\ORADATA\ORCL\RND_TBS.DBF
input datafile file number=00016 name=D:\APP\ORADATA\STLBAS\ORBSYS01.DBF
channel CH2: starting piece 1 at 18-JUL-14
channel CH3: starting full datafile backup set
channel CH3: specifying datafile(s) in backup set
input datafile file number=00022 name=D:\APP\ORADATA\STLBAS\ORBIND01.DBF
input datafile file number=00027 name=D:\APP\ORADATA\SPFTL\SHRINK_TEST.DBF
input datafile file number=00021 name=D:\APP\ORADATA\STLBAS\ORBMAV01.DBF
channel CH3: starting piece 1 at 18-JUL-14
channel CH4: starting full datafile backup set
channel CH4: specifying datafile(s) in backup set
input datafile file number=00003 name=D:\APP\ORADATA\ORCL\UNDOTBS01.DBF
input datafile file number=00013 name=D:\APP\ORADATA\SPFTL\STLBAS01.DBF
input datafile file number=00024 name=D:\APP\ORADATA\STLBAS\ORBBBR01.DBF
channel CH4: starting piece 1 at 18-JUL-14
channel CH5: starting full datafile backup set
channel CH5: specifying datafile(s) in backup set
input datafile file number=00026 name=D:\APP\ORADATA\STLBAS\MYBANK01.DBF
input datafile file number=00002 name=D:\APP\ORADATA\ORCL\SYSAUX01.DBF
input datafile file number=00020 name=D:\APP\ORADATA\STLBAS\ORBLOG01.DBF
channel CH5: starting piece 1 at 18-JUL-14
channel CH6: starting full datafile backup set
channel CH6: specifying datafile(s) in backup set
input datafile file number=00010 name=D:\APP\ORADATA\SPFTL\DATA.DBF
input datafile file number=00007 name=D:\APP\ORADATA\SPFTL\TRBFES.DBF
input datafile file number=00028 name=D:\APP\ORADATA\ORCL\RECLAIM01.DBF
channel CH6: starting piece 1 at 18-JUL-14
channel CH7: starting full datafile backup set
channel CH7: specifying datafile(s) in backup set
input datafile file number=00001 name=D:\APP\ORADATA\ORCL\SYSTEM01.DBF
input datafile file number=00015 name=D:\APP\ORADATA\STLBAS\ORBMAS01.DBF
input datafile file number=00006 name=D:\APP\ORADATA\SPFTL\TBACNTS.DBF
channel CH7: starting piece 1 at 18-JUL-14
channel CH8: starting full datafile backup set
channel CH8: specifying datafile(s) in backup set
input datafile file number=00014 name=D:\APP\ORADATA\STLBAS\ORBITS01.DBF
input datafile file number=00025 name=D:\APP\ORADATA\ORCL\APEX_DATA01.DBF
input datafile file number=00011 name=D:\APP\ORADATA\SPFTL\TBSTRAN .DBF
channel CH8: starting piece 1 at 18-JUL-14
channel CH9: starting full datafile backup set
channel CH9: specifying datafile(s) in backup set
input datafile file number=00004 name=D:\APP\ORADATA\ORCL\USERS01.DBF
input datafile file number=00005 name=D:\APP\ORADATA\ORCL\EXAMPLE01.DBF
input datafile file number=00009 name=D:\APP\ORADATA\SPFTL\TBAML.DBF
channel CH9: starting piece 1 at 18-JUL-14
channel CH10: starting full datafile backup set
channel CH10: specifying datafile(s) in backup set
input datafile file number=00019 name=D:\APP\ORADATA\STLBAS\ORBDT301.DBF
input datafile file number=00018 name=D:\APP\ORADATA\STLBAS\ORBDT201.DBF
input datafile file number=00017 name=D:\APP\ORADATA\STLBAS\ORBDT101.DBF
channel CH10: starting piece 1 at 18-JUL-14
channel CH4: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF4_ORCL_853204137_24_1_0OPDLN59_1_1 tag=TAG20140718T010852 comment=NONE
channel CH4: backup set complete, elapsed time: 00:01:30
channel CH8: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF8_ORCL_853204150_28_1_0SPDLN5M_1_1 tag=TAG20140718T010852 comment=NONE
channel CH8: backup set complete, elapsed time: 00:05:28
channel CH3: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF3_ORCL_853204136_23_1_0NPDLN58_1_1 tag=TAG20140718T010852 comment=NONE
channel CH3: backup set complete, elapsed time: 00:08:22
channel CH6: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF6_ORCL_853204144_26_1_0QPDLN5G_1_1 tag=TAG20140718T010852 comment=NONE
channel CH6: backup set complete, elapsed time: 00:08:21
channel CH10: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF10_ORCL_853204153_30_1_0UPDLN5P_1_1 tag=TAG20140718T010852 comment=NONE
channel CH10: backup set complete, elapsed time: 00:09:05
channel CH9: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF9_ORCL_853204151_29_1_0TPDLN5N_1_1 tag=TAG20140718T010852 comment=NONE
channel CH9: backup set complete, elapsed time: 00:09:17
channel CH5: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF5_ORCL_853204139_25_1_0PPDLN5B_1_1 tag=TAG20140718T010852 comment=NONE
channel CH5: backup set complete, elapsed time: 00:11:16
channel CH7: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF7_ORCL_853204148_27_1_0RPDLN5K_1_1 tag=TAG20140718T010852 comment=NONE
channel CH7: backup set complete, elapsed time: 00:11:29
channel CH1: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF1_ORCL_853204134_21_1_0LPDLN56_1_1 tag=TAG20140718T010852 comment=NONE
channel CH1: starting piece 2 at 18-JUL-14
channel CH2: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF2_ORCL_853204135_22_1_0MPDLN57_1_1 tag=TAG20140718T010852 comment=NONE
channel CH2: starting piece 2 at 18-JUL-14
channel CH2: finished piece 2 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF2_ORCL_853204135_22_2_0MPDLN57_2_1 tag=TAG20140718T010852 comment=NONE
channel CH2: backup set complete, elapsed time: 00:14:00
channel CH1: finished piece 2 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF1_ORCL_853204134_21_2_0LPDLN56_2_1 tag=TAG20140718T010852 comment=NONE
channel CH1: starting piece 3 at 18-JUL-14
channel CH1: finished piece 3 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_BKP_DF1_ORCL_853204134_21_3_0LPDLN56_3_1 tag=TAG20140718T010852 comment=NONE
channel CH1: backup set complete, elapsed time: 00:16:16
Finished backup at 18-JUL-14
Starting Control File and SPFILE Autobackup at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\BKP_CF_C-1350456456-20140718-01 comment=NONE
Finished Control File and SPFILE Autobackup at 18-JUL-14
sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT
Starting backup at 18-JUL-14
current log archived
channel CH1: starting archived log backup set
channel CH1: specifying archived log(s) in backup set
input archived log thread=1 sequence=9 RECID=12 STAMP=853205123
channel CH1: starting piece 1 at 18-JUL-14
channel CH2: starting archived log backup set
channel CH2: specifying archived log(s) in backup set
input archived log thread=1 sequence=10 RECID=13 STAMP=853205124
channel CH2: starting piece 1 at 18-JUL-14
channel CH1: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_ARCHIVE_ORCL_853205125_32_1_10PDLO45_1_1 tag=TAG20140718T012524 comment=NONE
channel CH1: backup set complete, elapsed time: 00:00:02
channel CH1: deleting archived log(s)
archived log file name=D:\APP\ORADATA\ARCHIVE\ARC0000000009_0853199878.0001 RECID=12 STAMP=853205123
channel CH2: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_ARCHIVE_ORCL_853205125_33_1_11PDLO45_1_1 tag=TAG20140718T012524 comment=NONE
channel CH2: backup set complete, elapsed time: 00:00:02
channel CH2: deleting archived log(s)
archived log file name=D:\APP\ORADATA\ARCHIVE\ARC0000000010_0853199878.0001 RECID=13 STAMP=853205124
Finished backup at 18-JUL-14
Starting backup at 18-JUL-14
channel CH1: starting full datafile backup set
channel CH1: specifying datafile(s) in backup set
including current control file in backup set
channel CH1: starting piece 1 at 18-JUL-14
channel CH1: finished piece 1 at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\RMAN_CONTRL_ORCL_853205133_34_1_12PDLO4D_1_1 tag=CF1 comment=NONE
channel CH1: backup set complete, elapsed time: 00:00:01
Finished backup at 18-JUL-14
Starting Control File and SPFILE Autobackup at 18-JUL-14
piece handle=K:\ORCL_RMAN_BACKUP\BKP_CF_C-1350456456-20140718-02 comment=NONE
Finished Control File and SPFILE Autobackup at 18-JUL-14
released channel: CH1
released channel: CH2
released channel: CH3
released channel: CH4
released channel: CH5
released channel: CH6
released channel: CH7
released channel: CH8
released channel: CH9
released channel: CH10
RMAN>
No comments:
Post a Comment