I am in the following situation: We have a JIRA instance running on a dedicated server machine (Windows Server). It uses Oracle XE to store all the data. The JIRA instance and a Oracle XE install for the data are both running on this one server box. JIRA does support doing cyclic export to XML, and we export this "XML dump" to a network share twice a day. But due to performance implications, we would like to replace this no-brainer solution with a (hopefully) no-brainer database backup.
Now, this question is not about the technical details, I can look them up easily enough. This question is about cutting through the blabla and hopefully getting to the point :-)
So I have this very simple one-user database on a single server and single harddisk, and want to do a backup to a network share:
- What do I need to back up so that the database is recoverable if the machine breaks.
- Is an "export" enough, do I need some setting files, etc?
- Essentially, what does constitute a "full" backup, so that the database + instance can be reconstructed by a fairly inexperienced Oracle user, even if the instance saw some undocumented tweaking.
- How do I backup, as in:
- Which tools should I use to do the backup.
- Should I try to get a live/continuous backup, or just do periodic "exports".
- Should the backup be "initiated" by the DB or by an external script?
So basically, I have a simple setup. The database was simple to install. How do I backup this so that it'll be simple to maintain and simple to restore?
Hope this is not too generic or noobish for this site.