Skip to Main Content

Oracle Database Discussions

Ransom ware recovery plan question

rjsosiMay 10 2022

We're using Oracle Database 12c Enterprise Edition Release - 64bit Production.
We're developing a Ransom Ware recovery plan for our databases. The data we're protecting is financial data. The very rough overall plan is to back the data up into a vault and restore it after an attack.
One item we're discussing is the time between the last backup and the time before the next backup.
During that time period after the DB back up, transactions are still happening, like Trades or loans granted at specific rates. How would you save that information until the next full DB back-up?
The trick with information like that is you can't redo those transactions because those transactions happened at specific times where the stock prices or the loan rates were at a specific value. So how would you save that information? Has anyone ever done this type of thing before?
What-ever the process is, it would run and store data between the latest time a DB backup was taken and the next time a DB backup was taken. We've got the DB backups being taken about every hour for this specific critical database. So you could refer to the interim time between database backups as the interim back-up. Then that interim-back-up data would be overwritten by the interim back up for the next time period between DB backups, so we're only storing about an hours worth of financial transactional information.
I know some people would just say use RMAN at an incremental level but it sounds like they want a solution where the data is saved outside of Oracle.
Are there any backup solutions in Oracle where you can save data directory to flat files? I'm thinking there is the possibility of using External tables and storing that data in an outside flat file.
I'm looking for a precedent we can at least study to get some ideas.

Post Details
Added on May 10 2022