The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Copycluster and backup consistency

bmurrellbmurrell Community Edition User

It's unclear from the documentation at what point a copycluster or backup is consistent.
For a backup, the documentation states "This type of backup provides a consistent image of the database at the time the backup occurred.", but if a backup takes 1.5 hours, is that the start or end of the backup or copycluster ?
In some databases (Oracle) it's at the end, and others (Informix) it's at the start.
Does vbr put a hold on file deletions while it's running in order that all files that are present at the start are still present at the end and are not missed while copycluster'ing or backing up ?

Answers

  • Bryan_HBryan_H Vertica Employee Administrator

    The backup process snapshots the catalog at the start of the backup transaction, so that is the point of consistency.

  • bmurrellbmurrell Community Edition User

    Thanks Bryan, and for the last question, does vbr put a hold on file deletions while it's running in order that all files that are present at the start are still present at the end and are not missed while copycluster'ing or backing up ?

  • Bryan_HBryan_H Vertica Employee Administrator

    There is transaction isolation during vbr: Internal task "Database Snapshot" holds a catalog lock while backup runs, which would block deletes during backup. Deletes and purges would not commit until after backup in this case.

Sign In or Register to comment.