Forum Discussion

tyadagiri's avatar
tyadagiri
Level 4
8 years ago

Differential Incremental backup running as FULL

Hi

Here is my setup: 

OS: RHEL5

File system backup: Cold backup RMAN files

Issue: Differential Incremental backups scheduled during weekdays runs as FULL backup on the FS

Schedule Types: D-D(Differential Incremental backup) - Frequency based- Runs every day (except Saturdays) 

W-F (Differential Incremental backup) - Calendar based- runs every Saturday (Excluded on last Saturday of the month)

M-F (FULL backup) - Calender based-runs on every last Saturday

Here we use Ctrl M as schedule and dependent on RMAN jobs, we have one FS that is /orabkup and in this FS we have data_l0 (level 0-FULL) and data_l1(level 1-Incremental)

Every day RMAN INCR job removes the old files and dumps the changes ones in level 1 folder. On Saturday (W-F & M-F) RMAN FULL runs and removes old files in level 0 and dumps new files which will be a FULL backup.

Once the Saturdays W-F gets completed and the D-D the next day NBU takes the backup of both level0 and level1 directories under the /orabkup FS even though the modified time is only the time stamp of the weekend.

This is causing the issues with all the backups overrun.

I suspect the problem is with Frequency based D-D backups as the W-F/M-F will run until next day say 15:00 hrs Sunday and on Sunday when INCR D-D backup is initiated the backup is FULL with the same amount of data that is backed up as FULL.

The Frequency is set as 6 hours. 

Please guide me if I need to change the frequency based schedules.

 

 

3 Replies