PhixFlow Help

Backup

Data Held on PhixFlow

The PhixFlow system comprises various types of data / systems files stored as follows:

Database

Configuration and system state data

Analysis results

Alarm and task status

File system

PhixFlow software

Files transferred to PhixFlow for processing

Files exported by PhixFlow

Archive data exported by PhixFlow

Backup Options

Backup requirements depend on the level of risk that is acceptable and the role that PhixFlow fulfils:

Snapshot

In a “standalone” role in which PhixFlow does not update other business systems then a simple daily snapshot backup of the database may be sufficient. The risk associated with this approach is that in the case of a catastrophic machine failure PhixFlow will lose all new configuration data entered that day plus state information and any new analysis results. To recover from this case after a database restore, the new configuration data would need to be re-entered manually and the analysis tasks re-rerun (this is possible provided source data is still available and import files are still in their import directories).

Hot Backup

More typically PhixFlow is used to update other business systems either directly (e.g. by calling APIs or updating / inserting data via SQL) or indirectly (e.g. by passing files or creating jobs on external work queues). In this case the impact of losing a day’s worth of data would require remedial action on other systems and the risk of a simple backup is too great, PhixFlow recommend that in this case a hot backup mechanism is put in place and redo logs and archived redo logs are maintained for sufficient time to recover completely from a catastrophic machine failure. When doing a hot backup, remember to place the database into backup mode to ensure complete blocks are written to redo.

Backup Volumes

The total backup storage requirements for one week for the hot backup approach on a standard sized system (i.e. tablespace size is 100 GB) is given below:

Item

Volume

Weekly Volume

Full backup

100 GB

100 GB

Daily Redo log archive

20 GB

140 GB

 

Total

240 GB

A recommended backup strategy is to retain data as follows:

Item

Volume

Current week archive logs

140 GB

Current week full backup

100 GB

Prior week (week -1) archive logs

140 GB

Prior week (week -1) full backup

100 GB

Week -2 full backup

100 GB

Week -3 full backup

100 GB

Total

680 GB

This strategy enables the administrator to reset the database to any point within at least the last week and provide restore points for the previous 4 weeks. For larger systems, these values should be provided by the sizing process.

 

Please let us know if we could improve this page feedback@phixflow.com