Monday , September 25 2017
Home / Oracle DBA / RMAN INCREMENTAL BACKUPS

RMAN INCREMENTAL BACKUPS

RMAN INCREMENTAL BACKUPS:

Incase of incremental backup , rman takes the backup of only modified blocks.

The different levels of incrementals are:

  1. level 0  [ complete backup]
  2. level 1   [incremental backup]
  3. level2   [cumulative]

Incremental  backup is also called as diffrenial backup.

level 0 is the base  base backup for Incremental backup

From  10.2.0.4 levels[>] greaterthan 0 and 1 0f become  obsolete. (means take cumulative backup)

STEP 1: RAMN COMPLETE BACKUP:

RMAN> backup incremental level 0 database;

Starting backup at 05-JUL-17
using channel ORA_DISK_1
using channel ORA_DISK_2
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=00001 name=/u01/app/oracle/dbc/system01.dbf
input datafile file number=00004 name=/u01/app/oracle/dbc/users01.dbf
channel ORA_DISK_1: starting piece 1 at 05-JUL-17
channel ORA_DISK_2: starting incremental level 0 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00002 name=/u01/app/oracle/dbc/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/dbc/undotbs01.dbf
channel ORA_DISK_2: starting piece 1 at 05-JUL-17
channel ORA_DISK_2: finished piece 1 at 05-JUL-17
piece handle=/u01/app/oracle/fast_recovery_area/DBC/backupset/2017_07_05/o1_mf_nnnd0_TAG20170705T173808_dosoodsr_.bkp tag=TAG20170705T173808 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:06:20
channel ORA_DISK_1: finished piece 1 at 05-JUL-17
piece handle=/u01/app/oracle/fast_recovery_area/DBC/backupset/2017_07_05/o1_mf_nnnd0_TAG20170705T173808_dosood7b_.bkp tag=TAG20170705T173808 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:06:57
Finished backup at 05-JUL-17

Starting Control File and SPFILE Autobackup at 05-JUL-17
piece handle=/u01/app/oracle/product/11.2.0/db_home/dbs/c-1307993075-20170705-06 comment=NONE
Finished Control File and SPFILE Autobackup at 05-JUL-17

RMAN>

STEP 2: RMAN INCREMENTAL BACKUP:

RMAN> backup incremental level 1 database;

Starting backup at 05-JUL-17
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/dbc/system01.dbf
input datafile file number=00004 name=/u01/app/oracle/dbc/users01.dbf
channel ORA_DISK_1: starting piece 1 at 05-JUL-17
channel ORA_DISK_2: starting incremental level 1 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00002 name=/u01/app/oracle/dbc/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/dbc/undotbs01.dbf
channel ORA_DISK_2: starting piece 1 at 05-JUL-17
channel ORA_DISK_2: finished piece 1 at 05-JUL-17
piece handle=/u01/app/oracle/fast_recovery_area/DBC/backupset/2017_07_05/o1_mf_nnnd1_TAG20170705T175351_dosplsyx_.bkp tag=TAG20170705T175351 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:56
channel ORA_DISK_1: finished piece 1 at 05-JUL-17
piece handle=/u01/app/oracle/fast_recovery_area/DBC/backupset/2017_07_05/o1_mf_nnnd1_TAG20170705T175351_dosplst6_.bkp tag=TAG20170705T175351 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:56
Finished backup at 05-JUL-17

Starting Control File and SPFILE Autobackup at 05-JUL-17
piece handle=/u01/app/oracle/product/11.2.0/db_home/dbs/c-1307993075-20170705-07 comment=NONE
Finished Control File and SPFILE Autobackup at 05-JUL-17

STEP 3: RMAN CUMULATIVE BACKUP:

RMAN> backup incremental level 1 cumulative database;

Starting backup at 05-JUL-17
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/dbc/system01.dbf
input datafile file number=00004 name=/u01/app/oracle/dbc/users01.dbf
channel ORA_DISK_1: starting piece 1 at 05-JUL-17
channel ORA_DISK_2: starting incremental level 1 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00002 name=/u01/app/oracle/dbc/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/dbc/undotbs01.dbf
channel ORA_DISK_2: starting piece 1 at 05-JUL-17
channel ORA_DISK_2: finished piece 1 at 05-JUL-17
piece handle=/u01/app/oracle/fast_recovery_area/DBC/backupset/2017_07_05/o1_mf_nnnd1_TAG20170705T175657_dosprmg9_.bkp tag=TAG20170705T175657 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:56
channel ORA_DISK_1: finished piece 1 at 05-JUL-17
piece handle=/u01/app/oracle/fast_recovery_area/DBC/backupset/2017_07_05/o1_mf_nnnd1_TAG20170705T175657_dosprlpd_.bkp tag=TAG20170705T175657 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:06
Finished backup at 05-JUL-17

Starting Control File and SPFILE Autobackup at 05-JUL-17
piece handle=/u01/app/oracle/product/11.2.0/db_home/dbs/c-1307993075-20170705-08 comment=NONE
Finished Control File and SPFILE Autobackup at 05-JUL-17

RMAN>

 

Comments

comments

Check Also

How to switch on primary database to physical standby database

After configuration data guard then data is switching  into primary database  to standby database : …

Leave a Reply

Your email address will not be published. Required fields are marked *