Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-20279

Modify default retention strategy of confluence db schema on Oracle.

    XMLWordPrintable

Details

    • We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      NOTE: This suggestion is for Confluence Server. Using Confluence Cloud? See the corresponding suggestion.

      Confluence instances that are constantly being used (high load) can cause: Oracle datapump backups of Confluence data to fail due to combination of the the issues noted in Oracle Support note id 563470.1. The Confluence schema does not retain changed rows long enough for the Oracle datapump mechanism to get a consistent snapshot of the application (especially for tables that contain LOB columns) for instances that change frequently.

      A way around this is to set RETENTION on the column data : 

      alter table bodycontent modify clob(body)(retention);

      This makes old versions of LOB data for a period of time, instead of using a percentage of the table space (PCTVERSION).

      Can this be supported and merged in future versions of Confluence?

      Existing workarounds is to use confluence XML backup strategy

      Attachments

        Issue Links

          relates to

          Suggestion - CONFCLOUD-20279 Modify default retention strategy of confluence db schema on Oracle.

          • Closed

          Activity

            People

              Unassigned Unassigned
              vchoy Vincent Choy (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: