Subject | Re: [firebird-support] Stuck OIT after NBackup lock + fixup? |
---|---|
Author | Ivan Přenosil |
Post date | 2013-10-08T10:15:47Z |
> I've started using NBackup lock + local file copy + Nbackup unlockIt is because in locked database there is always at least one transaction active.
> (merge the delta file) for backing up my FB 2.5 database.
>
> After the copy has been completed, I do Nbackup fixup (remove the lock
> but don't try to merge any delta file) on the local copy and then
> transfer it to a remote backup volume. After that I use the local copy
> for test/development/debug purposes.
>
> I've noticed that after this process, the local copy (now operating as a
> test database) has a stuck OIT, so a sweep is required.
>
> Why does that happen,
> and is there a quicker way than a full sweep to solve it?I do not think so.
Ivan