Uploaded image for project: 'Confluence Cloud'
  1. Confluence Cloud
  2. CONFCLOUD-20279

Modify default retention strategy of confluence db schema on Oracle.

    XMLWordPrintable

Details

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

    Description

      NOTE: This suggestion is for Confluence Cloud. Using Confluence Server? 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

          is related to

          Suggestion - CONFSERVER-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:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: