In this Blog post I will share another short video demonstrating how storage data services can be used to perform many common data management and CDM (Copy Data Management) tasks using simply scripting, DevOPS automation tools and Pure Storage REST API’s .
Oracle 12c Point-in-Time-Recovery
This video starts the same as a Part 1: Oracle 12c database reset by refreshing an Oracle 12c database, and then simulates a typical development workflow process, where development databases are refreshed from production and then updated with:
- New application configuration and setup
- Additional synthetic and manufactured data supplement production data sets
- Data masking and cleansing scripts.
- Housekeeping routines e.g. clean-up workflow / staging tables
The video shows me taking a crash-consistent snapshot using a python script I have developed (available at code.purestorage.com) using the Pure Storage REST API’s.
The video then proceeds to perform further updates and changes, before simulating a the loss of datafile.
I then use another python script to determine the last snapshot before shutting the database down and rolling-back to the recovery point. Once the datafiles have been restored RMAN is used to roll-forward the database using the database log files performing a PITR (Point-in-Time-Recovery) with no data-loss.