backup incremental level 0 database plus archivelog

[oratest@oracle dbs]$  rman target/

Recovery Manager: Release 19.0.0.0.0 - Production on Thu Sep 9 00:42:53 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1608118455)

RMAN> backup incremental level 0 database plus archivelog;


Starting backup at 09-SEP-21
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=471 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=21 STAMP=1082265443
input archived log thread=1 sequence=2 RECID=22 STAMP=1082354497
input archived log thread=1 sequence=3 RECID=23 STAMP=1082412592
input archived log thread=1 sequence=4 RECID=24 STAMP=1082470208
input archived log thread=1 sequence=5 RECID=25 STAMP=1082554248
input archived log thread=1 sequence=6 RECID=26 STAMP=1082640636
input archived log thread=1 sequence=7 RECID=27 STAMP=1082677257
input archived log thread=1 sequence=9 RECID=29 STAMP=1082766943
input archived log thread=1 sequence=10 RECID=30 STAMP=1082766950
input archived log thread=1 sequence=11 RECID=31 STAMP=1082766986
input archived log thread=1 sequence=12 RECID=32 STAMP=1082766988
input archived log thread=1 sequence=13 RECID=33 STAMP=1082766991
input archived log thread=1 sequence=14 RECID=34 STAMP=1082767405
channel ORA_DISK_1: starting piece 1 at 09-SEP-21
channel ORA_DISK_1: finished piece 1 at 09-SEP-21
piece handle=/u01/app/oracle/oradata/ORCL/backup/1f08je1e_1_1 tag=TAG20210909T004325 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:56
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=13 RECID=9 STAMP=1081792908
input archived log thread=1 sequence=14 RECID=10 STAMP=1081863051
input archived log thread=1 sequence=15 RECID=11 STAMP=1081953019
input archived log thread=1 sequence=16 RECID=12 STAMP=1082066461
input archived log thread=1 sequence=17 RECID=19 STAMP=1082263361
input archived log thread=1 sequence=18 RECID=20 STAMP=1082263367
input archived log thread=1 sequence=19 RECID=18 STAMP=1082263356
channel ORA_DISK_1: starting piece 1 at 09-SEP-21
channel ORA_DISK_1: finished piece 1 at 09-SEP-21
piece handle=/u01/app/oracle/oradata/ORCL/backup/1g08je36_1_1 tag=TAG20210909T004325 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:47
Finished backup at 09-SEP-21

Starting backup at 09-SEP-21
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/ORCL/sysaux01.dbf
input datafile file number=00001 name=/u01/app/oracle/oradata/ORCL/system01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ORCL/undotbs01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/data02.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/data01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/ORCL/users01.dbf
channel ORA_DISK_1: starting piece 1 at 09-SEP-21
channel ORA_DISK_1: finished piece 1 at 09-SEP-21
piece handle=/u01/app/oracle/oradata/ORCL/backup/1h08je4m_1_1 tag=TAG20210909T004510 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:06
Finished backup at 09-SEP-21

Starting backup at 09-SEP-21
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=15 RECID=35 STAMP=1082767577
channel ORA_DISK_1: starting piece 1 at 09-SEP-21
channel ORA_DISK_1: finished piece 1 at 09-SEP-21
piece handle=/u01/app/oracle/oradata/ORCL/backup/1i08je6p_1_1 tag=TAG20210909T004617 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 09-SEP-21

Starting Control File and SPFILE Autobackup at 09-SEP-21
piece handle=/u01/app/oracle/oradata/ORCL/backup/c-1608118455-20210909-00 comment=NONE
Finished Control File and SPFILE Autobackup at 09-SEP-21

RMAN> list backup of database summary;


List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
--- -- -- - ----------- --------------- ------- ------- ---------- ---
1     B  F  A  DISK   11-AUG-21     1     1       NO  TAG20210811T222830
4     B  F  A  DISK   11-AUG-21     1     1       NO  TAG20210811T223126
7     B  F  A  DISK   11-AUG-21     1     1       NO  TAG20210811T223345
10    B  F  A DISK    11-AUG-21     1     1       NO  TAG20210811T224016
12    B  F  A DISK    11-AUG-21     1     1       NO  TAG20210811T224942

28    B  F  A DISK    12-AUG-21     1     1       NO  TAG20210812T223307
30    B  0  A DISK    12-AUG-21     1     1       NO  TAG20210812T224824
32    B  1  A DISK    12-AUG-21     1     1       NO  TAG20210812T225022
34    B  1  A DISK    12-AUG-21     1     1       NO  TAG20210812T225145
36    B  F  A DISK    25-AUG-21     1     1       NO  TAG20210825T220051
40    B  F  A DISK    03-SEP-21     1     1       NO  TAG20210903T044703
47    B  0  A DISK    09-SEP-21     1     1       NO  TAG20210909T004510

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter: https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

Tag Archives: backup incremental level 0 database plus archivelog

19c RMAN CONCEPTS:

Backup-based Cloning of a database using RMAN