RMAN Backup Types

                                             

v Incremental backup of only CDB & PDB datafiles

RMAN> backup incremental level 0 database tag 'Inc_Level_0' plus archivelog;
 
Starting backup at 16-APR-24
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=38 RECID=33 STAMP=1166446696
input archived log thread=1 sequence=39 RECID=34 STAMP=1166446735
input archived log thread=1 sequence=40 RECID=35 STAMP=1166450954
channel ORA_DISK_1: starting piece 1 at 16-APR-24
piece handle=/u01/app/oracle/fast_recovery_area/MAXCDB/backupset/2024_04_16/o1_mf_annnn_TAG20240416T140928_m1wdkrtq_.bkp tag=TAG20240416T140928 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 16-APR-24
 
v  Differential backups back up all blocks changed since the last backup, whether full or differential

RMAN> backup incremental level 1 tag 'Inc_Level_1' database plus archivelog;
 
Starting backup at 16-APR-24
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=38 RECID=33 STAMP=1166446696
input archived log thread=1 sequence=39 RECID=34 STAMP=1166446735
input archived log thread=1 sequence=40 RECID=35 STAMP=1166450954
input archived log thread=1 sequence=41 RECID=36 STAMP=1166450968
piece handle=/u01/app/oracle/fast_recovery_area/MAXCDB/backupset/2024_04_16/o1_mf_annnn_INC_LEVEL_1_m1wdtwnf_.bkp tag=INC_LEVEL_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 16-APR-24
 
v  Cumulative backups back up all blocks changed since the last full backup

RMAN> backup incremental level 1 cumulative tag 'Inc_Level_1_Cum' database plus archivelog;
 
Starting backup at 16-APR-24
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=38 RECID=33 STAMP=1166446696
input archived log thread=1 sequence=39 RECID=34 STAMP=1166446735
input archived log thread=1 sequence=40 RECID=35 STAMP=1166450954
input archived log thread=1 sequence=41 RECID=36 STAMP=1166450968
input archived log thread=1 sequence=42 RECID=37 STAMP=1166451254
input archived log thread=1 sequence=43 RECID=38 STAMP=1166451260
input archived log thread=1 sequence=44 RECID=39 STAMP=1166451503
channel ORA_DISK_1: starting piece 1 at 16-APR-24
channel ORA_DISK_1: finished piece 1 at 16-APR-24
piece handle=/u01/app/oracle/fast_recovery_area/MAXCDB/backupset/2024_04_16/o1_mf_annnn_INC_LEVEL_1_CUM_m1wf2obv_.bkp tag=INC_LEVEL_1_CUM comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 16-APR-24

r  Backup Strategy
 
o   Level 0 – Weekly
o   Level 1 – Daily
o   Archive log – Every after two hours
 
r  Level 0 Backup – Backup of spfile, control file, database and archivelog
 
RUN{
ALLOCATE CHANNEL chl1 TYPE DISK MAXPIECESIZE 10G;
ALLOCATE CHANNEL chl2 TYPE DISK MAXPIECESIZE 10G;
ALLOCATE CHANNEL chl3 TYPE DISK MAXPIECESIZE 10G;
BACKUP
FORMAT '/u01/backup/%d_D_LEVEL0_%T_%u_s%s_p%p'
INCREMENTAL LEVEL 0 DATABASE
CURRENT CONTROLFILE
FORMAT '/u01/backup/%d_C_LEVEL0_%T_%u'
SPFILE
FORMAT '/u01/backup/%d_S_LEVEL0_%T_%u'
PLUS ARCHIVELOG
FORMAT '/u01/backup/%d_A_LEVEL0_%T_%u_s%s_p%p';
RELEASE CHANNEL chl1;
RELEASE CHANNEL chl2;
RELEASE CHANNEL chl3;
}
 
r  Level 1 Backup
 
RUN{
ALLOCATE CHANNEL chl1 TYPE DISK MAXPIECESIZE 10G;
ALLOCATE CHANNEL chl2 TYPE DISK MAXPIECESIZE 10G;
ALLOCATE CHANNEL chl3 TYPE DISK MAXPIECESIZE 10G;
BACKUP
FORMAT '/u01/backup/%d_D_LEVEL1_LEVEL1_%T_%u_s%s_p%p'
INCREMENTAL LEVEL 1 DATABASE
CURRENT CONTROLFILE
FORMAT '/u01/backup/%d_C_LEVEL1_%T_%u'
SPFILE
FORMAT '/u01/backup/%d_S_LEVEL1_%T_%u'
PLUS ARCHIVELOG
FORMAT '/u01/backup/%d_A_LEVEL1_%T_%u_s%s_p%p';
RELEASE CHANNEL chl1;
RELEASE CHANNEL chl2;
RELEASE CHANNEL chl3;
}
 
r  Level 1 Cumulative Backup
 
RUN{
ALLOCATE CHANNEL chl1 TYPE DISK MAXPIECESIZE 10G;
ALLOCATE CHANNEL chl2 TYPE DISK MAXPIECESIZE 10G;
ALLOCATE CHANNEL chl3 TYPE DISK MAXPIECESIZE 10G;
BACKUP
FORMAT '/u01/backup/%d_D_LEVEL1_CUM_%T_%u_s%s_p%p'
INCREMENTAL LEVEL 1 CUMULATIVE DATABASE
CURRENT CONTROLFILE
FORMAT '/u01/backup/%d_C_LEVEL1_CUM_%T_%u'
SPFILE
FORMAT '/u01/backup/%d_S_LEVEL1_CUM_%T_%u'
PLUS ARCHIVELOG
FORMAT '/u01/backup/%d_A_LEVEL1_CUM_%T_%u_s%s_p%p';
RELEASE CHANNEL chl1;
RELEASE CHANNEL chl2;
RELEASE CHANNEL chl3;
}
 
r  SCN Level Backup
 
[oracle@dbserver ~]$ sqlplus / as sysdba
 
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jul 30 21:29:20 2024
Version 19.22.0.0.0
Copyright (c) 1982, 2023, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.22.0.0.0
 
SQL> select current_scn from v$database;
 
CURRENT_SCN
-----------
    3015166
 
SQL> select scn_to_timestamp(3015166) as timestamp from dual;
 
TIMESTAMP
---------------------------------------------------------------------------
30-JUL-24 09.29.57.000000000 PM
 
[oracle@dbserver ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Tue Jul 30 21:37:38 2024
Version 19.22.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
connected to target database: MAXCDB (DBID=2565367265)
 
RMAN> backup incremental from scn 3015166 database format '/u01/rman_%U' tag 'SCN_Backup';
 
Starting backup at 30-JUL-24
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=45 device type=DISK
RMAN-06755: warning: datafile 1: incremental-start SCN is too recent; using checkpoint SCN 3011362 instead
RMAN-06755: warning: datafile 3: incremental-start SCN is too recent; using checkpoint SCN 3011362 instead
RMAN-06755: warning: datafile 4: incremental-start SCN is too recent; using checkpoint SCN 3011362 instead
RMAN-06755: warning: datafile 12: incremental-start SCN is too recent; using checkpoint SCN 3011362 instead
RMAN-06755: warning: datafile 13: incremental-start SCN is too recent; using checkpoint SCN 3011362 instead
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/MAXCDB/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/MAXCDB/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/MAXCDB/undotbs01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/MAXCDB/users01.dbf
channel ORA_DISK_1: starting piece 1 at 30-JUL-24
channel ORA_DISK_1: finished piece 1 at 30-JUL-24
piece handle=/u01/rman_0q3186qk_26_1_1 tag=SCN_BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 30-JUL-24