[oracle@orcloel7 ~]$ rman target=/ catalog=cat_zdlra/s3nhazdlra@zdlra Recovery Manager: Release 18.0.0.0.0 - Production on Thu Aug 15 15:31:08 2019 Version 18.6.0.0.0 Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL18 (DBID=3914023082) connected to recovery catalog database PL/SQL package CAT_ZDLRA.DBMS_RCVCAT version 18.03.00.00. in RCVCAT database is not current PL/SQL package CAT_ZDLRA.DBMS_RCVMAN version 18.03.00.00 in RCVCAT database is not current RMAN> RUN { 2> BACKUP INCREMENTAL LEVEL 0 DEVICE TYPE SBT FILESPERSET 1 DATABASE TAG 'BKP-DB-INC0'; 3> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT'; 4> BACKUP DEVICE TYPE SBT FILESPERSET 100 FORMAT '%U' ARCHIVELOG ALL NOT BACKED UP TAG 'BKP-ARCH'; 5> } Starting backup at 15-08-2019_15:31:23 allocated channel: ORA_SBT_TAPE_1 channel ORA_SBT_TAPE_1: SID=115 device type=SBT_TAPE channel ORA_SBT_TAPE_1: RA Library (ZDLRA) SID=9028E3E9B71A0C54E053010310AC6C3C channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set input datafile file number=00001 name=/u01/app/oracle/oradata/ORCL18/system01.dbf channel ORA_SBT_TAPE_1: starting piece 1 at 15-08-2019_15:31:26 channel ORA_SBT_TAPE_1: finished piece 1 at 15-08-2019_15:34:51 piece handle=ORCL18_1vu99dme_1_1 tag=BKP-DB-INC0 comment=API Version 2.0,MMS Version 12.2.0.2 channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:03:25 channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set input datafile file number=00003 name=/u01/app/oracle/oradata/ORCL18/sysaux01.dbf channel ORA_SBT_TAPE_1: starting piece 1 at 15-08-2019_15:34:51 channel ORA_SBT_TAPE_1: finished piece 1 at 15-08-2019_15:36:56 piece handle=ORCL18_20u99dsr_1_1 tag=BKP-DB-INC0 comment=API Version 2.0,MMS Version 12.2.0.2 channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:02:05 channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set input datafile file number=00004 name=/u01/app/oracle/oradata/ORCL18/undotbs01.dbf channel ORA_SBT_TAPE_1: starting piece 1 at 15-08-2019_15:36:56 channel ORA_SBT_TAPE_1: finished piece 1 at 15-08-2019_15:37:21 piece handle=ORCL18_21u99e0o_1_1 tag=BKP-DB-INC0 comment=API Version 2.0,MMS Version 12.2.0.2 channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25 channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set input datafile file number=00007 name=/u01/app/oracle/oradata/ORCL18/users01.dbf channel ORA_SBT_TAPE_1: starting piece 1 at 15-08-2019_15:37:21 channel ORA_SBT_TAPE_1: finished piece 1 at 15-08-2019_15:37:28 piece handle=ORCL18_22u99e1h_1_1 tag=BKP-DB-INC0 comment=API Version 2.0,MMS Version 12.2.0.2 channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:07 Finished backup at 15-08-2019_15:37:28 Starting Control File and SPFILE Autobackup at 15-08-2019_15:37:28 piece handle=c-3914023082-20190815-0c comment=API Version 2.0,MMS Version 12.2.0.2 Finished Control File and SPFILE Autobackup at 15-08-2019_15:37:48 sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT Starting backup at 15-08-2019_15:37:58 current log archived using channel ORA_SBT_TAPE_1 channel ORA_SBT_TAPE_1: starting archived log backup set channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set input archived log thread=1 sequence=16 RECID=13 STAMP=1016379475 input archived log thread=1 sequence=17 RECID=14 STAMP=1016379478 channel ORA_SBT_TAPE_1: starting piece 1 at 15-08-2019_15:38:02 channel ORA_SBT_TAPE_1: finished piece 1 at 15-08-2019_15:38:17 piece handle=24u99e2q_1_1 tag=BKP-ARCH comment=API Version 2.0,MMS Version 12.2.0.2 channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:15 Finished backup at 15-08-2019_15:38:17 Starting Control File and SPFILE Autobackup at 15-08-2019_15:38:17 piece handle=c-3914023082-20190815-0d comment=API Version 2.0,MMS Version 12.2.0.2 Finished Control File and SPFILE Autobackup at 15-08-2019_15:38:33 RMAN> list backup of database; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4067 Incr 0 329.24M SBT_TAPE 00:03:26 15-08-2019_15:34:52 BP Key: 4068 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC0 Handle: VB$_4142545763_3969I Media: List of Datafiles in backup set 4067 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 1 0 Incr 1624921 15-08-2019_15:31:26 NO /u01/app/oracle/oradata/ORCL18/system01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4072 Incr 0 136.51M SBT_TAPE 00:02:06 15-08-2019_15:36:57 BP Key: 4073 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC0 Handle: VB$_4142545763_4071I Media: List of Datafiles in backup set 4072 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 3 0 Incr 1625049 15-08-2019_15:34:51 NO /u01/app/oracle/oradata/ORCL18/sysaux01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4077 Incr 0 2.05M SBT_TAPE 00:00:21 15-08-2019_15:37:17 BP Key: 4078 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC0 Handle: VB$_4142545763_4076I Media: List of Datafiles in backup set 4077 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 4 0 Incr 1625123 15-08-2019_15:36:56 NO /u01/app/oracle/oradata/ORCL18/undotbs01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4082 Incr 0 48.00K SBT_TAPE 00:00:05 15-08-2019_15:37:26 BP Key: 4083 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC0 Handle: VB$_4142545763_4081I Media: List of Datafiles in backup set 4082 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 7 0 Incr 1625148 15-08-2019_15:37:22 NO /u01/app/oracle/oradata/ORCL18/users01.dbf RMAN> RUN { 2> BACKUP INCREMENTAL LEVEL 1 DEVICE TYPE SBT FILESPERSET 1 DATABASE TAG 'BKP-DB-INC1'; 3> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT'; 4> BACKUP DEVICE TYPE SBT FILESPERSET 100 FORMAT '%U' ARCHIVELOG ALL NOT BACKED UP TAG 'BKP-ARCH'; 5> } Starting backup at 15-08-2019_15:58:15 using channel ORA_SBT_TAPE_1 channel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set input datafile file number=00001 name=/u01/app/oracle/oradata/ORCL18/system01.dbf channel ORA_SBT_TAPE_1: starting piece 1 at 15-08-2019_15:58:16 channel ORA_SBT_TAPE_1: finished piece 1 at 15-08-2019_15:58:17 piece handle=ORCL18_26u99f8o_1_1 tag=BKP-DB-INC1 comment=API Version 2.0,MMS Version 12.2.0.2 channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:01 channel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set input datafile file number=00003 name=/u01/app/oracle/oradata/ORCL18/sysaux01.dbf channel ORA_SBT_TAPE_1: starting piece 1 at 15-08-2019_15:58:17 channel ORA_SBT_TAPE_1: finished piece 1 at 15-08-2019_15:58:18 piece handle=ORCL18_27u99f8p_1_1 tag=BKP-DB-INC1 comment=API Version 2.0,MMS Version 12.2.0.2 channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:01 channel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set input datafile file number=00004 name=/u01/app/oracle/oradata/ORCL18/undotbs01.dbf channel ORA_SBT_TAPE_1: starting piece 1 at 15-08-2019_15:58:18 channel ORA_SBT_TAPE_1: finished piece 1 at 15-08-2019_15:58:21 piece handle=ORCL18_28u99f8q_1_1 tag=BKP-DB-INC1 comment=API Version 2.0,MMS Version 12.2.0.2 channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:03 channel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set input datafile file number=00007 name=/u01/app/oracle/oradata/ORCL18/users01.dbf channel ORA_SBT_TAPE_1: starting piece 1 at 15-08-2019_15:58:22 channel ORA_SBT_TAPE_1: finished piece 1 at 15-08-2019_15:58:23 piece handle=ORCL18_29u99f8u_1_1 tag=BKP-DB-INC1 comment=API Version 2.0,MMS Version 12.2.0.2 channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:01 Finished backup at 15-08-2019_15:58:23 Starting Control File and SPFILE Autobackup at 15-08-2019_15:58:23 piece handle=c-3914023082-20190815-0e comment=API Version 2.0,MMS Version 12.2.0.2 Finished Control File and SPFILE Autobackup at 15-08-2019_15:58:31 sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT Starting backup at 15-08-2019_15:58:35 current log archived using channel ORA_SBT_TAPE_1 skipping archived logs of thread 1 from sequence 16 to 17; already backed up channel ORA_SBT_TAPE_1: starting archived log backup set channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set input archived log thread=1 sequence=18 RECID=15 STAMP=1016380714 input archived log thread=1 sequence=19 RECID=16 STAMP=1016380715 channel ORA_SBT_TAPE_1: starting piece 1 at 15-08-2019_15:58:36 channel ORA_SBT_TAPE_1: finished piece 1 at 15-08-2019_15:58:37 piece handle=2bu99f9c_1_1 tag=BKP-ARCH comment=API Version 2.0,MMS Version 12.2.0.2 channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:01 Finished backup at 15-08-2019_15:58:37 Starting Control File and SPFILE Autobackup at 15-08-2019_15:58:37 piece handle=c-3914023082-20190815-0f comment=API Version 2.0,MMS Version 12.2.0.2 Finished Control File and SPFILE Autobackup at 15-08-2019_15:58:44 RMAN> RMAN> RMAN> list backup of database; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4067 Incr 0 329.24M SBT_TAPE 00:03:26 15-08-2019_15:34:52 BP Key: 4068 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC0 Handle: VB$_4142545763_3969I Media: List of Datafiles in backup set 4067 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 1 0 Incr 1624921 15-08-2019_15:31:26 NO /u01/app/oracle/oradata/ORCL18/system01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4072 Incr 0 136.51M SBT_TAPE 00:02:06 15-08-2019_15:36:57 BP Key: 4073 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC0 Handle: VB$_4142545763_4071I Media: List of Datafiles in backup set 4072 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 3 0 Incr 1625049 15-08-2019_15:34:51 NO /u01/app/oracle/oradata/ORCL18/sysaux01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4077 Incr 0 2.05M SBT_TAPE 00:00:21 15-08-2019_15:37:17 BP Key: 4078 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC0 Handle: VB$_4142545763_4076I Media: List of Datafiles in backup set 4077 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 4 0 Incr 1625123 15-08-2019_15:36:56 NO /u01/app/oracle/oradata/ORCL18/undotbs01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4082 Incr 0 48.00K SBT_TAPE 00:00:05 15-08-2019_15:37:26 BP Key: 4083 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC0 Handle: VB$_4142545763_4081I Media: List of Datafiles in backup set 4082 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 7 0 Incr 1625148 15-08-2019_15:37:22 NO /u01/app/oracle/oradata/ORCL18/users01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4249 Incr 1 112.00K SBT_TAPE 00:00:03 15-08-2019_15:58:19 BP Key: 4250 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4248I Media: List of Datafiles in backup set 4249 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 1 1 Incr 1626240 15-08-2019_15:58:16 NO /u01/app/oracle/oradata/ORCL18/system01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4253 Incr 0 328.12M SBT_TAPE 00:00:03 15-08-2019_15:58:19 BP Key: 4254 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4248_1 Media: List of Datafiles in backup set 4253 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 1 0 Incr 1626240 15-08-2019_15:58:16 NO /u01/app/oracle/oradata/ORCL18/system01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4258 Incr 1 88.00K SBT_TAPE 00:00:03 15-08-2019_15:58:20 BP Key: 4259 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4257I Media: List of Datafiles in backup set 4258 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 3 1 Incr 1626244 15-08-2019_15:58:17 NO /u01/app/oracle/oradata/ORCL18/sysaux01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4262 Incr 0 136.10M SBT_TAPE 00:00:03 15-08-2019_15:58:20 BP Key: 4263 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4257_3 Media: List of Datafiles in backup set 4262 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 3 0 Incr 1626244 15-08-2019_15:58:17 NO /u01/app/oracle/oradata/ORCL18/sysaux01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4267 Incr 1 72.00K SBT_TAPE 00:00:04 15-08-2019_15:58:22 BP Key: 4268 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4266I Media: List of Datafiles in backup set 4267 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 4 1 Incr 1626247 15-08-2019_15:58:19 NO /u01/app/oracle/oradata/ORCL18/undotbs01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4271 Incr 0 2.07M SBT_TAPE 00:00:04 15-08-2019_15:58:22 BP Key: 4272 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4266_4 Media: List of Datafiles in backup set 4271 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 4 0 Incr 1626247 15-08-2019_15:58:19 NO /u01/app/oracle/oradata/ORCL18/undotbs01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4276 Incr 1 40.00K SBT_TAPE 00:00:02 15-08-2019_15:58:24 BP Key: 4277 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4275I Media: List of Datafiles in backup set 4276 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 7 1 Incr 1626251 15-08-2019_15:58:22 NO /u01/app/oracle/oradata/ORCL18/users01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4280 Incr 0 40.00K SBT_TAPE 00:00:02 15-08-2019_15:58:24 BP Key: 4281 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4275_7 Media: List of Datafiles in backup set 4280 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 7 0 Incr 1626251 15-08-2019_15:58:22 NO /u01/app/oracle/oradata/ORCL18/users01.dbf RMAN> RUN { 2> BACKUP INCREMENTAL LEVEL 1 DEVICE TYPE SBT FILESPERSET 1 DATABASE TAG 'BKP-DB-INC1'; 3> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT'; 4> BACKUP DEVICE TYPE SBT FILESPERSET 100 FORMAT '%U' ARCHIVELOG ALL NOT BACKED UP TAG 'BKP-ARCH'; 5> } Starting backup at 15-08-2019_16:19:32 using channel ORA_SBT_TAPE_1 channel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set input datafile file number=00001 name=/u01/app/oracle/oradata/ORCL18/system01.dbf channel ORA_SBT_TAPE_1: starting piece 1 at 15-08-2019_16:19:33 channel ORA_SBT_TAPE_1: finished piece 1 at 15-08-2019_16:19:36 piece handle=ORCL18_2du99ggl_1_1 tag=BKP-DB-INC1 comment=API Version 2.0,MMS Version 12.2.0.2 channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:03 channel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set input datafile file number=00003 name=/u01/app/oracle/oradata/ORCL18/sysaux01.dbf channel ORA_SBT_TAPE_1: starting piece 1 at 15-08-2019_16:19:36 channel ORA_SBT_TAPE_1: finished piece 1 at 15-08-2019_16:19:39 piece handle=ORCL18_2eu99ggo_1_1 tag=BKP-DB-INC1 comment=API Version 2.0,MMS Version 12.2.0.2 channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:03 channel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set input datafile file number=00004 name=/u01/app/oracle/oradata/ORCL18/undotbs01.dbf channel ORA_SBT_TAPE_1: starting piece 1 at 15-08-2019_16:19:39 channel ORA_SBT_TAPE_1: finished piece 1 at 15-08-2019_16:19:40 piece handle=ORCL18_2fu99ggr_1_1 tag=BKP-DB-INC1 comment=API Version 2.0,MMS Version 12.2.0.2 channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:01 channel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set input datafile file number=00007 name=/u01/app/oracle/oradata/ORCL18/users01.dbf channel ORA_SBT_TAPE_1: starting piece 1 at 15-08-2019_16:19:40 channel ORA_SBT_TAPE_1: finished piece 1 at 15-08-2019_16:19:41 piece handle=ORCL18_2gu99ggs_1_1 tag=BKP-DB-INC1 comment=API Version 2.0,MMS Version 12.2.0.2 channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:01 Finished backup at 15-08-2019_16:19:41 Starting Control File and SPFILE Autobackup at 15-08-2019_16:19:41 piece handle=c-3914023082-20190815-10 comment=API Version 2.0,MMS Version 12.2.0.2 Finished Control File and SPFILE Autobackup at 15-08-2019_16:19:49 sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT Starting backup at 15-08-2019_16:19:53 current log archived using channel ORA_SBT_TAPE_1 skipping archived logs of thread 1 from sequence 16 to 19; already backed up channel ORA_SBT_TAPE_1: starting archived log backup set channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set input archived log thread=1 sequence=20 RECID=17 STAMP=1016381992 input archived log thread=1 sequence=21 RECID=18 STAMP=1016381994 channel ORA_SBT_TAPE_1: starting piece 1 at 15-08-2019_16:19:54 channel ORA_SBT_TAPE_1: finished piece 1 at 15-08-2019_16:19:57 piece handle=2iu99gha_1_1 tag=BKP-ARCH comment=API Version 2.0,MMS Version 12.2.0.2 channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:03 Finished backup at 15-08-2019_16:19:57 Starting Control File and SPFILE Autobackup at 15-08-2019_16:19:58 piece handle=c-3914023082-20190815-11 comment=API Version 2.0,MMS Version 12.2.0.2 Finished Control File and SPFILE Autobackup at 15-08-2019_16:20:05 RMAN> list backup of database; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4067 Incr 0 329.24M SBT_TAPE 00:03:26 15-08-2019_15:34:52 BP Key: 4068 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC0 Handle: VB$_4142545763_3969I Media: List of Datafiles in backup set 4067 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 1 0 Incr 1624921 15-08-2019_15:31:26 NO /u01/app/oracle/oradata/ORCL18/system01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4072 Incr 0 136.51M SBT_TAPE 00:02:06 15-08-2019_15:36:57 BP Key: 4073 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC0 Handle: VB$_4142545763_4071I Media: List of Datafiles in backup set 4072 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 3 0 Incr 1625049 15-08-2019_15:34:51 NO /u01/app/oracle/oradata/ORCL18/sysaux01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4077 Incr 0 2.05M SBT_TAPE 00:00:21 15-08-2019_15:37:17 BP Key: 4078 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC0 Handle: VB$_4142545763_4076I Media: List of Datafiles in backup set 4077 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 4 0 Incr 1625123 15-08-2019_15:36:56 NO /u01/app/oracle/oradata/ORCL18/undotbs01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4082 Incr 0 48.00K SBT_TAPE 00:00:05 15-08-2019_15:37:26 BP Key: 4083 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC0 Handle: VB$_4142545763_4081I Media: List of Datafiles in backup set 4082 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 7 0 Incr 1625148 15-08-2019_15:37:22 NO /u01/app/oracle/oradata/ORCL18/users01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4249 Incr 1 112.00K SBT_TAPE 00:00:03 15-08-2019_15:58:19 BP Key: 4250 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4248I Media: List of Datafiles in backup set 4249 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 1 1 Incr 1626240 15-08-2019_15:58:16 NO /u01/app/oracle/oradata/ORCL18/system01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4253 Incr 0 328.12M SBT_TAPE 00:00:03 15-08-2019_15:58:19 BP Key: 4254 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4248_1 Media: List of Datafiles in backup set 4253 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 1 0 Incr 1626240 15-08-2019_15:58:16 NO /u01/app/oracle/oradata/ORCL18/system01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4258 Incr 1 88.00K SBT_TAPE 00:00:03 15-08-2019_15:58:20 BP Key: 4259 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4257I Media: List of Datafiles in backup set 4258 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 3 1 Incr 1626244 15-08-2019_15:58:17 NO /u01/app/oracle/oradata/ORCL18/sysaux01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4262 Incr 0 136.10M SBT_TAPE 00:00:03 15-08-2019_15:58:20 BP Key: 4263 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4257_3 Media: List of Datafiles in backup set 4262 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 3 0 Incr 1626244 15-08-2019_15:58:17 NO /u01/app/oracle/oradata/ORCL18/sysaux01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4267 Incr 1 72.00K SBT_TAPE 00:00:04 15-08-2019_15:58:22 BP Key: 4268 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4266I Media: List of Datafiles in backup set 4267 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 4 1 Incr 1626247 15-08-2019_15:58:19 NO /u01/app/oracle/oradata/ORCL18/undotbs01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4271 Incr 0 2.07M SBT_TAPE 00:00:04 15-08-2019_15:58:22 BP Key: 4272 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4266_4 Media: List of Datafiles in backup set 4271 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 4 0 Incr 1626247 15-08-2019_15:58:19 NO /u01/app/oracle/oradata/ORCL18/undotbs01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4276 Incr 1 40.00K SBT_TAPE 00:00:02 15-08-2019_15:58:24 BP Key: 4277 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4275I Media: List of Datafiles in backup set 4276 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 7 1 Incr 1626251 15-08-2019_15:58:22 NO /u01/app/oracle/oradata/ORCL18/users01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4280 Incr 0 40.00K SBT_TAPE 00:00:02 15-08-2019_15:58:24 BP Key: 4281 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4275_7 Media: List of Datafiles in backup set 4280 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 7 0 Incr 1626251 15-08-2019_15:58:22 NO /u01/app/oracle/oradata/ORCL18/users01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4502 Incr 1 96.00K SBT_TAPE 00:00:00 15-08-2019_16:19:33 BP Key: 4503 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4501I Media: List of Datafiles in backup set 4502 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 1 1 Incr 1627563 15-08-2019_16:19:33 NO /u01/app/oracle/oradata/ORCL18/system01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4506 Incr 0 328.11M SBT_TAPE 00:00:00 15-08-2019_16:19:33 BP Key: 4507 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4501_1 Media: List of Datafiles in backup set 4506 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 1 0 Incr 1627563 15-08-2019_16:19:33 NO /u01/app/oracle/oradata/ORCL18/system01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4511 Incr 1 832.00K SBT_TAPE 00:00:02 15-08-2019_16:19:38 BP Key: 4512 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4510I Media: List of Datafiles in backup set 4511 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 3 1 Incr 1627567 15-08-2019_16:19:36 NO /u01/app/oracle/oradata/ORCL18/sysaux01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4515 Incr 0 136.44M SBT_TAPE 00:00:02 15-08-2019_16:19:38 BP Key: 4516 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4510_3 Media: List of Datafiles in backup set 4515 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 3 0 Incr 1627567 15-08-2019_16:19:36 NO /u01/app/oracle/oradata/ORCL18/sysaux01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4520 Incr 1 472.00K SBT_TAPE 00:00:02 15-08-2019_16:19:41 BP Key: 4521 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4519I Media: List of Datafiles in backup set 4520 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 4 1 Incr 1627571 15-08-2019_16:19:39 NO /u01/app/oracle/oradata/ORCL18/undotbs01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4524 Incr 0 2.46M SBT_TAPE 00:00:02 15-08-2019_16:19:41 BP Key: 4525 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4519_4 Media: List of Datafiles in backup set 4524 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 4 0 Incr 1627571 15-08-2019_16:19:39 NO /u01/app/oracle/oradata/ORCL18/undotbs01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4529 Incr 1 40.00K SBT_TAPE 00:00:02 15-08-2019_16:19:42 BP Key: 4530 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4528I Media: List of Datafiles in backup set 4529 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 7 1 Incr 1627574 15-08-2019_16:19:40 NO /u01/app/oracle/oradata/ORCL18/users01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 4533 Incr 0 40.00K SBT_TAPE 00:00:02 15-08-2019_16:19:42 BP Key: 4534 Status: AVAILABLE Compressed: YES Tag: BKP-DB-INC1 Handle: VB$_4142545763_4528_7 Media: List of Datafiles in backup set 4533 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 7 0 Incr 1627574 15-08-2019_16:19:40 NO /u01/app/oracle/oradata/ORCL18/users01.dbf RMAN>