Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Ransom ware recovery plan question

rjsosiMay 10 2022

Hi,
We're using Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 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.
Thanks!

Comments

Scott Wesley
Answer

The native Popup Lov facilitates multi-value selection (from 19.x), or the Select2 plugin can do the same. This would be from a known set of values.
They will store the values in a delimited string for that field, which you than then use apex_string.split to break it up as necessary.
If you need to dynamically add tags, then you may consider the United Codes List Extension plugin

Marked as Answer by SteveQuinlivan · Apr 21 2021
SteveQuinlivan

Thanks @scott-wesley, the Popup Lov will give me what i need

Regards

1 - 2

Post Details

Added on May 10 2022
3 comments
187 views