Forum Stats

  • 3,839,996 Users
  • 2,262,557 Discussions
  • 7,901,120 Comments

Discussions

Why Incremental accumulative backup has the same size as a full backup

2»

Comments

  • tsangsir
    tsangsir Member Posts: 486 Silver Badge
    edited Nov 1, 2021 1:00AM
    1. I can't see anything showing "every two days system is backup size same as full backup".
    2. On 29/10, there were a FULL datafile backup (4134MB) and INCR1 datafile backup (190009). Its unreasonable that a INCRso much bigger than FULL.
    3. Why's there a FULL backup on Fri??
  • Mitya HORT
    Mitya HORT Member Posts: 18 Green Ribbon

    1 - [Mitya], Yes i recognize like this. but the same script was applied with another database instance. It's working properly.

    2- [Mitya], Yes it's not make sense that INCR size is more than Full bakcup.

    3- [Mitya] , on Tuesday - Sunday, script was applied with Incremental accumulative backup only. but system is backup full on Friday( 29-Oct-2021) It is strange. Can you check on this issue?

    Thank,

    Mitya

  • tsangsir
    tsangsir Member Posts: 486 Silver Badge

    Of course I can't check why you have a full backup on Fri, it's your system.

    But the most likely reason is another backup job was configured by someone or at somewhere else. 

  • Mitya HORT
    Mitya HORT Member Posts: 18 Green Ribbon

    Hi tsangsir,

    Yes correct. on Friday system should backup Incremental but system execute script incremental accumulate already but it's records size full back.

    and Script is executed by cronjob. no one configure another backup job.

  • tsangsir
    tsangsir Member Posts: 486 Silver Badge

    Then no one configured, but a full backup was run.

  • Mitya HORT
    Mitya HORT Member Posts: 18 Green Ribbon

    Yes..Now i have monitored Tuesday, and Wendesday, Script was executed incremental Accumulate and size of backup is incremental. Let monitor tomorrow and see.