Jira server time vs database backup time

Question

Hi. Our servers are on the Azure cloud.

We are interested in backing up our Jira instance onto a backup server and also its underlying database (Oracle) server onto another backup Oracle server. The plan is it start the backup Jira and backup Oracle servers and use those moving forwards.

The backups will not be created at the same time so the Oracle backup may be created a few hours before the Jira sever is backed up. Will this time difference cause any problems when using the backup Jira and Oracle instances together?

We need to do the same for Confluence so does this also apply to Confluence?

Thank you for your help.

ttse_landg · Answer

Hi @Jamie Rogers, thanks for your help. If we ever had to recover from this situation our users would (have to) accept that some recent additions would be missing.

I'm talking about Azure Site Recovery and as I'm trying to understand this it might be better (for me at least) if I describe it as cloning rather than backup. So if the Oracle server was cloned at a different time to the Jira server, the original Servers go down and then both clones deployed onto new servers and brought up would there be any problems or considerations when starting the new Jira service?

Thanks again.

Jamie Rogers · Answer

Hi @ttse_landg

I don't see any issue with this if Jira is not running when the backups are occurring i.e. you shutdown Jira first then backup server and database.

If Jira is running and users are using it then likely data may change on the server and this could lead to inconsistencies or data loss.

In our case our database takes longer to backup than the server and we typically take an outage during our weekly maintenance window to ensure we don't have any data loss as a result.

Jamie