Keep Jazz servers online when backing up Oracle repository
Hello,
Technote # 1454793 states that when using Jazz v.3.x with an oracle database, it is important to stop the Jazz server before backing up the oracle repository if using the datapump without "flashback_scn" method. Stopping the server is recommended because performing a backup when the Jazz server "is still up and running might result in inconsistent, corrupted, or out of sync, hence unusable repository database backups".
We are currently using datapump without "flashback_scn" to backup our production Jazz v.4.0.4 Oracle database repository. We stop our Jazz servers every night to let the scheduled nightly datapump backups run uninterrupted. Does this technote also apply to Jazz v.4.0.4 or higher?
We would like to keep our servers on-line all the time...so my question is if we decide to use the datapump method with parameter "flashback_scn", can the Jazz v.4.0.4 servers remain on-line while the oracle repository backup is being executed in the background? By using datapump-flashback_scn, are there any risks similar to those described in the technote or other potential risks that we should be aware of before taking this route.
Thank you,
Pierre
One answer
I have seen problems with online backup using datapump at customers. Especially when the database grew bigger. I am by no means an expert in these matters.
In Other DB's you can backup transactions which is less likely to produce issues. Enterprise databases also allow for redundant storage.