Vishith, A Full Backup does not participate in an Incremental Backup strategy. Thus, if you take a Full Backup on Monday and then do an Incremental Level 1 Backup on Tuesday, the Incremental backup does not consider the Monday Full Backup as a Baseline. The Tuesday backup will, although issued as an Incemental Level 1 Backup, be executed as an Incremental Level 0 Backup.
Hi Hemant, Thanks for your videos. I tried to run an incremental 1 cumulative backup after level 0(level 0 is successful with all datafiles backed up) but it throws a warning below "no parent backup or copy of datafile 1 found" & took full backup. Can you please help.
Run these RMAN commands "LIST BACKUP" or "LIST BACKUP OF DATAFILE 1" and also "CROSSCHECK BACKUP" or "CROSSCHECK BACKUP OF DATAFILE 1" to see RMAN is aware of a datafile 1 backup. Also, confirm that your level 0 backup was done with "INCREMENTAL LEVEL 0" in the RMAN command.
Hi, Thanks for your prompt response .. I tried your commands and it says available only..I ran the command as Backup incremental level 0 database for full backup
I tried in another env and it works.. I believe the issue is due to i have done reset reincarnation lately.. i believe this might b a reason for the behavior.. it says no parent file only for system datafile, not other files.. any guess??
@@sribalaje Yes, a RESETLOGS creates a different incarnation. So the level-0 backup of the previous incarnation isn't the base of the current level-1 backup.
There is no separate command for an incremental restore. The RESTORE and RECOVER commands automatically identify and apply the Level-0 and Level-1 backups that are required. That is why you will see that although the BACKUP command has an INCREMENTAL keyword, the RESTORE and RECOVER commands do *not* have the keyword. You have to let Oracle RMAN automatically identify the Incremental backups to be used. See this demo with 11g : czcams.com/video/iqy2-fDd8yI/video.html There is only 1 exception when you use a specific Incremental backup --- the backup that is done with the FROM SCN clause and can only be used to update a Standby database (it cannot be used in a "normal" Restore/Recover scenario of a non-Standby database).
Vishith,
A Full Backup does not participate in an Incremental Backup strategy. Thus, if you take a Full Backup on Monday and then do an Incremental Level 1 Backup on Tuesday, the Incremental backup does not consider the Monday Full Backup as a Baseline. The Tuesday backup will, although issued as an Incemental Level 1 Backup, be executed as an Incremental Level 0 Backup.
Thank you very much.
You are welcome!
Hi Sir,
Can you explain about the differences between level 0 and a full backup thanks in advance.
Hi Hemant, Thanks for your videos. I tried to run an incremental 1 cumulative backup after level 0(level 0 is successful with all datafiles backed up) but it throws a warning below
"no parent backup or copy of datafile 1 found" & took full backup. Can you please help.
Run these RMAN commands "LIST BACKUP" or "LIST BACKUP OF DATAFILE 1" and also "CROSSCHECK BACKUP" or "CROSSCHECK BACKUP OF DATAFILE 1" to see RMAN is aware of a datafile 1 backup. Also, confirm that your level 0 backup was done with "INCREMENTAL LEVEL 0" in the RMAN command.
Hi, Thanks for your prompt response .. I tried your commands and it says available only..I ran the command as Backup incremental level 0 database for full backup
I tried in another env and it works.. I believe the issue is due to i have done reset reincarnation lately.. i believe this might b a reason for the behavior.. it says no parent file only for system datafile, not other files.. any guess??
@@sribalaje Yes, a RESETLOGS creates a different incarnation. So the level-0 backup of the previous incarnation isn't the base of the current level-1 backup.
Thanks but in my case i done reincarnation two days back but i started level 0 yesterday and level 1 today.. still got issues
sir what is the command to perform incremental restoration
There is no separate command for an incremental restore. The RESTORE and RECOVER commands automatically identify and apply the Level-0 and Level-1 backups that are required. That is why you will see that although the BACKUP command has an INCREMENTAL keyword, the RESTORE and RECOVER commands do *not* have the keyword. You have to let Oracle RMAN automatically identify the Incremental backups to be used.
See this demo with 11g : czcams.com/video/iqy2-fDd8yI/video.html
There is only 1 exception when you use a specific Incremental backup --- the backup that is done with the FROM SCN clause and can only be used to update a Standby database (it cannot be used in a "normal" Restore/Recover scenario of a non-Standby database).