Oracle recommends standard backup routines occur on the Primavera Data Warehouse instance. As a general rule, at a minimum, Oracle recommends that you schedule backups of the Primavera Data Warehouse instance to occur at least at the same frequency as the lowest level of History interval (daily, weekly, monthly) for all the projects in your P6 EPPM database. For example, if one project in P6 EPPM is set to capture history daily, set up daily backups of your Primavera Data Warehouse database. Establishing this rule with the Primavera Data Warehouse instance ensures the integrity of Primavera Data Warehouse historical data.
Note: For Primavera Unifier, the lowest level of History interval is weekly.