Incrementally Updated Backups

RUN
{
allocate channel backup_disk4 type disk format '/rman/dupitdb/oradata/backup_test/%U';
allocate channel backup_disk2 type disk format '/rman/dupitdb/oradata/backup_test/%U';
allocate channel backup_disk3 type disk format '/rman/dupitdb/oradata/backup_test/%U';
  RECOVER COPY OF DATABASE
    WITH TAG 'incr_update0';
  BACKUP
    INCREMENTAL LEVEL 1
    FOR RECOVER OF COPY WITH TAG 'incr_update0'
    DATABASE;
}




puertorico $ rman target /

Recovery Manager: Release 10.1.0.4.0 - 64bit Production

Copyright (c) 1995, 2004, Oracle.  All rights reserved.

connected to target database: EMREP (DBID=3918347849)

RMAN> RUN
2> {
3> allocate channel backup_disk4 type disk format '/rman/dupitdb/oradata/backup_test/%U';
4> allocate channel backup_disk2 type disk format '/rman/dupitdb/oradata/backup_test/%U';
5> allocate channel backup_disk3 type disk format '/rman/dupitdb/oradata/backup_test/%U';
  RECOVER COPY OF DATABASE
6> 7>     WITH TAG 'incr_update0';
  BACKUP
8> 9>     INCREMENTAL LEVEL 1
    FOR RECOVER OF COPY WITH TAG 'incr_update0'
10>     DATABASE;
}
11> 12>
using target database controlfile instead of recovery catalog
allocated channel: backup_disk4
channel backup_disk4: sid=142 devtype=DISK

allocated channel: backup_disk2
channel backup_disk2: sid=163 devtype=DISK

allocated channel: backup_disk3
channel backup_disk3: sid=145 devtype=DISK

Starting recover at 27-SEP-13
no copy of datafile 1 found to recover
no copy of datafile 2 found to recover
no copy of datafile 3 found to recover
no copy of datafile 4 found to recover
no copy of datafile 5 found to recover
no copy of datafile 6 found to recover
no copy of datafile 7 found to recover
no copy of datafile 8 found to recover
no copy of datafile 9 found to recover
no copy of datafile 10 found to recover
no copy of datafile 11 found to recover
no copy of datafile 12 found to recover
Finished recover at 27-SEP-13

Starting backup at 27-SEP-13
no parent backup or copy of datafile 4 found
no parent backup or copy of datafile 5 found
no parent backup or copy of datafile 10 found
no parent backup or copy of datafile 11 found
no parent backup or copy of datafile 12 found
no parent backup or copy of datafile 7 found
no parent backup or copy of datafile 9 found
no parent backup or copy of datafile 1 found
no parent backup or copy of datafile 3 found
no parent backup or copy of datafile 2 found
no parent backup or copy of datafile 6 found
no parent backup or copy of datafile 8 found
channel backup_disk4: starting datafile copy
input datafile fno=00004 name=/rman/dupitdb/oradata/GRID/oradata/emrep/users01.dbf
channel backup_disk2: starting datafile copy
input datafile fno=00005 name=/rman/dupitdb/oradata/GRID/oradata/emrep/mgmt.dbf
channel backup_disk3: starting datafile copy
input datafile fno=00010 name=/rman/dupitdb/oradata/GRID/oradata/emrep/DSG_DATA02.dbf
output filename=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-DSG_DATA_FNO-10_1noktiih tag=INCR_UPDATE0 recid=25 stamp=827247377
channel backup_disk3: datafile copy complete, elapsed time: 00:03:19
channel backup_disk3: starting datafile copy
input datafile fno=00011 name=/rman/dupitdb/oradata/GRID/oradata/emrep/users02.dbf
output filename=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-USERS_FNO-11_1ooktior tag=INCR_UPDATE0 recid=26 stamp=827247588
channel backup_disk3: datafile copy complete, elapsed time: 00:03:26
channel backup_disk3: starting datafile copy
input datafile fno=00012 name=/rman/dupitdb/oradata/GRID/oradata/emrep/users03.dbf
output filename=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-USERS_FNO-12_1poktiva tag=INCR_UPDATE0 recid=27 stamp=827247749
channel backup_disk3: datafile copy complete, elapsed time: 00:02:37
channel backup_disk3: starting datafile copy
input datafile fno=00007 name=/rman/dupitdb/oradata/GRID/oradata/emrep/php01.dbf
output filename=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-MGMT_TABLESPACE_FNO-5_1moktiih tag=INCR_UPDATE0 recid=29 stamp=827247838
channel backup_disk2: datafile copy complete, elapsed time: 00:10:55
channel backup_disk2: starting datafile copy
input datafile fno=00009 name=/rman/dupitdb/oradata/GRID/oradata/emrep/DSG_DATA01.dbf
output filename=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-PHP_FNO-7_1qoktj4a tag=INCR_UPDATE0 recid=28 stamp=827247834
channel backup_disk3: datafile copy complete, elapsed time: 00:01:28
channel backup_disk3: starting datafile copy
input datafile fno=00001 name=/rman/dupitdb/oradata/GRID/oradata/emrep/system01.dbf
output filename=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-SYSTEM_FNO-1_1soktj72 tag=INCR_UPDATE0 recid=30 stamp=827247910
channel backup_disk3: datafile copy complete, elapsed time: 00:01:15
channel backup_disk3: starting datafile copy
input datafile fno=00003 name=/rman/dupitdb/oradata/GRID/oradata/emrep/sysaux01.dbf
output filename=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-DSG_DATA_FNO-9_1roktj71 tag=INCR_UPDATE0 recid=31 stamp=827247929
channel backup_disk2: datafile copy complete, elapsed time: 00:01:32
channel backup_disk2: starting datafile copy
input datafile fno=00002 name=/rman/dupitdb/oradata/GRID/oradata/emrep/undotbs01.dbf
output filename=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-SYSAUX_FNO-3_1toktj9e tag=INCR_UPDATE0 recid=32 stamp=827247956
channel backup_disk3: datafile copy complete, elapsed time: 00:00:41
channel backup_disk3: starting datafile copy
input datafile fno=00006 name=/rman/dupitdb/oradata/GRID/oradata/emrep/mgmt_ecm_depot1.dbf
output filename=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-MGMT_ECM_DEPOT_TS_FNO-6_1voktjao tag=INCR_UPDATE0 recid=33 stamp=827247972
channel backup_disk3: datafile copy complete, elapsed time: 00:00:15
channel backup_disk3: starting datafile copy
input datafile fno=00008 name=/rman/dupitdb/oradata/GRID/oradata/emrep/stream_tbs.dbf
output filename=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-UNDOTBS1_FNO-2_1uoktj9u tag=INCR_UPDATE0 recid=34 stamp=827247978
channel backup_disk2: datafile copy complete, elapsed time: 00:00:45
output filename=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-STREAMS_TBS_FNO-8_20oktjb7 tag=INCR_UPDATE0 recid=35 stamp=827247978
channel backup_disk3: datafile copy complete, elapsed time: 00:00:04
output filename=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-USERS_FNO-4_1loktiih tag=INCR_UPDATE0 recid=36 stamp=827248036
channel backup_disk4: datafile copy complete, elapsed time: 00:14:19
Finished backup at 27-SEP-13

Starting Control File and SPFILE Autobackup at 27-SEP-13
piece handle=/rman/dupitdb/oradata/GRID/db10g/flash_recovery_area/EMREP/autobackup/2013_09_27/o1_mf_s_827248044_94c48xq3_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 27-SEP-13
released channel: backup_disk4
released channel: backup_disk2
released channel: backup_disk3

RMAN> RUN
2> {
3> allocate channel backup_disk4 type disk format '/rman/dupitdb/oradata/backup_test/%U';
allocate channel backup_disk2 type disk format '/rman/dupitdb/oradata/backup_test/%U';
allocate channel backup_disk3 type disk format '/rman/dupitdb/oradata/backup_test/%U';
  RECOVER COPY OF DATABASE
    WITH TAG 'incr_update0';
  BACKUP
    INCREMENTAL LEVEL 1
    FOR RECOVER OF COPY WITH TAG 'incr_update0'
    DATABASE;
}
4> 5> 6> 7> 8> 9> 10> 11> 12>
allocated channel: backup_disk4
channel backup_disk4: sid=142 devtype=DISK

allocated channel: backup_disk2
channel backup_disk2: sid=163 devtype=DISK

allocated channel: backup_disk3
channel backup_disk3: sid=145 devtype=DISK

Starting recover at 27-SEP-13
no copy of datafile 1 found to recover
no copy of datafile 2 found to recover
no copy of datafile 3 found to recover
no copy of datafile 4 found to recover
no copy of datafile 5 found to recover
no copy of datafile 6 found to recover
no copy of datafile 7 found to recover
no copy of datafile 8 found to recover
no copy of datafile 9 found to recover
no copy of datafile 10 found to recover
no copy of datafile 11 found to recover
no copy of datafile 12 found to recover
Finished recover at 27-SEP-13

Starting backup at 27-SEP-13
channel backup_disk4: starting incremental level 1 datafile backupset
channel backup_disk4: specifying datafile(s) in backupset
input datafile fno=00004 name=/rman/dupitdb/oradata/GRID/oradata/emrep/users01.dbf
input datafile fno=00003 name=/rman/dupitdb/oradata/GRID/oradata/emrep/sysaux01.dbf
input datafile fno=00002 name=/rman/dupitdb/oradata/GRID/oradata/emrep/undotbs01.dbf
input datafile fno=00008 name=/rman/dupitdb/oradata/GRID/oradata/emrep/stream_tbs.dbf
channel backup_disk4: starting piece 1 at 27-SEP-13
channel backup_disk2: starting incremental level 1 datafile backupset
channel backup_disk2: specifying datafile(s) in backupset
input datafile fno=00005 name=/rman/dupitdb/oradata/GRID/oradata/emrep/mgmt.dbf
input datafile fno=00009 name=/rman/dupitdb/oradata/GRID/oradata/emrep/DSG_DATA01.dbf
input datafile fno=00001 name=/rman/dupitdb/oradata/GRID/oradata/emrep/system01.dbf
input datafile fno=00006 name=/rman/dupitdb/oradata/GRID/oradata/emrep/mgmt_ecm_depot1.dbf
channel backup_disk2: starting piece 1 at 27-SEP-13
channel backup_disk3: starting incremental level 1 datafile backupset
channel backup_disk3: specifying datafile(s) in backupset
input datafile fno=00010 name=/rman/dupitdb/oradata/GRID/oradata/emrep/DSG_DATA02.dbf
input datafile fno=00011 name=/rman/dupitdb/oradata/GRID/oradata/emrep/users02.dbf
input datafile fno=00012 name=/rman/dupitdb/oradata/GRID/oradata/emrep/users03.dbf
input datafile fno=00007 name=/rman/dupitdb/oradata/GRID/oradata/emrep/php01.dbf
channel backup_disk3: starting piece 1 at 27-SEP-13
channel backup_disk3: finished piece 1 at 27-SEP-13
piece handle=/rman/dupitdb/oradata/backup_test/24oktk1r_1_1 comment=NONE
channel backup_disk3: backup set complete, elapsed time: 00:04:15
channel backup_disk2: finished piece 1 at 27-SEP-13
piece handle=/rman/dupitdb/oradata/backup_test/23oktk1r_1_1 comment=NONE
channel backup_disk2: backup set complete, elapsed time: 00:06:20
channel backup_disk4: finished piece 1 at 27-SEP-13
piece handle=/rman/dupitdb/oradata/backup_test/22oktk1q_1_1 comment=NONE
channel backup_disk4: backup set complete, elapsed time: 00:08:07
Finished backup at 27-SEP-13

Starting Control File and SPFILE Autobackup at 27-SEP-13
piece handle=/rman/dupitdb/oradata/GRID/db10g/flash_recovery_area/EMREP/autobackup/2013_09_27/o1_mf_s_827249185_94c5dlfq_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 27-SEP-13
released channel: backup_disk4
released channel: backup_disk2
released channel: backup_disk3

RMAN> RUN
2> {
3> allocate channel backup_disk4 type disk format '/rman/dupitdb/oradata/backup_test/%U';
4> allocate channel backup_disk2 type disk format '/rman/dupitdb/oradata/backup_test/%U';
5> allocate channel backup_disk3 type disk format '/rman/dupitdb/oradata/backup_test/%U';
  RECOVER COPY OF DATABASE
6> 7>     WITH TAG 'incr_update0';
8>   BACKUP
9>     INCREMENTAL LEVEL 1
10>     FOR RECOVER OF COPY WITH TAG 'incr_update0'
11>     DATABASE;
}
12>
allocated channel: backup_disk4
channel backup_disk4: sid=142 devtype=DISK

allocated channel: backup_disk2
channel backup_disk2: sid=163 devtype=DISK

allocated channel: backup_disk3
channel backup_disk3: sid=145 devtype=DISK

Starting recover at 27-SEP-13
channel backup_disk4: starting incremental datafile backupset restore
channel backup_disk4: specifying datafile copies to recover
recovering datafilecopy fno=00007 name=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-PHP_FNO-7_1qoktj4a
recovering datafilecopy fno=00010 name=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-DSG_DATA_FNO-10_1noktiih
recovering datafilecopy fno=00011 name=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-USERS_FNO-11_1ooktior
recovering datafilecopy fno=00012 name=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-USERS_FNO-12_1poktiva
channel backup_disk2: starting incremental datafile backupset restore
channel backup_disk2: specifying datafile copies to recover
recovering datafilecopy fno=00001 name=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-SYSTEM_FNO-1_1soktj72
recovering datafilecopy fno=00005 name=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-MGMT_TABLESPACE_FNO-5_1moktiih
recovering datafilecopy fno=00006 name=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-MGMT_ECM_DEPOT_TS_FNO-6_1voktjao
recovering datafilecopy fno=00009 name=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-DSG_DATA_FNO-9_1roktj71
channel backup_disk3: starting incremental datafile backupset restore
channel backup_disk3: specifying datafile copies to recover
recovering datafilecopy fno=00002 name=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-UNDOTBS1_FNO-2_1uoktj9u
recovering datafilecopy fno=00003 name=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-SYSAUX_FNO-3_1toktj9e
recovering datafilecopy fno=00004 name=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-USERS_FNO-4_1loktiih
recovering datafilecopy fno=00008 name=/rman/dupitdb/oradata/backup_test/data_D-EMREP_I-3918347849_TS-STREAMS_TBS_FNO-8_20oktjb7
channel backup_disk4: restored backup piece 1
piece handle=/rman/dupitdb/oradata/backup_test/24oktk1r_1_1 tag=TAG20130927T151817
channel backup_disk4: restore complete
channel backup_disk2: restored backup piece 1
piece handle=/rman/dupitdb/oradata/backup_test/23oktk1r_1_1 tag=TAG20130927T151817
channel backup_disk2: restore complete
channel backup_disk3: restored backup piece 1
piece handle=/rman/dupitdb/oradata/backup_test/22oktk1q_1_1 tag=TAG20130927T151817
channel backup_disk3: restore complete
Finished recover at 27-SEP-13

Starting backup at 27-SEP-13
channel backup_disk4: starting incremental level 1 datafile backupset
channel backup_disk4: specifying datafile(s) in backupset
input datafile fno=00004 name=/rman/dupitdb/oradata/GRID/oradata/emrep/users01.dbf
input datafile fno=00003 name=/rman/dupitdb/oradata/GRID/oradata/emrep/sysaux01.dbf
input datafile fno=00002 name=/rman/dupitdb/oradata/GRID/oradata/emrep/undotbs01.dbf
input datafile fno=00008 name=/rman/dupitdb/oradata/GRID/oradata/emrep/stream_tbs.dbf
channel backup_disk4: starting piece 1 at 27-SEP-13
channel backup_disk2: starting incremental level 1 datafile backupset
channel backup_disk2: specifying datafile(s) in backupset
input datafile fno=00005 name=/rman/dupitdb/oradata/GRID/oradata/emrep/mgmt.dbf
input datafile fno=00009 name=/rman/dupitdb/oradata/GRID/oradata/emrep/DSG_DATA01.dbf
input datafile fno=00001 name=/rman/dupitdb/oradata/GRID/oradata/emrep/system01.dbf
input datafile fno=00006 name=/rman/dupitdb/oradata/GRID/oradata/emrep/mgmt_ecm_depot1.dbf
channel backup_disk2: starting piece 1 at 27-SEP-13
channel backup_disk3: starting incremental level 1 datafile backupset
channel backup_disk3: specifying datafile(s) in backupset
input datafile fno=00010 name=/rman/dupitdb/oradata/GRID/oradata/emrep/DSG_DATA02.dbf
input datafile fno=00011 name=/rman/dupitdb/oradata/GRID/oradata/emrep/users02.dbf
input datafile fno=00012 name=/rman/dupitdb/oradata/GRID/oradata/emrep/users03.dbf
input datafile fno=00007 name=/rman/dupitdb/oradata/GRID/oradata/emrep/php01.dbf
channel backup_disk3: starting piece 1 at 27-SEP-13