I have an Oracle database over which I have full control. What I am doing is performing load testing on our application, which uses Oracle as a database. To do this, I initially set the database up with some dummy data. I'm calling this "Point A".
The load testing will consume this data, and I will have to restore the data so it looks exactly like it was in Point A before I can re-run them. The hard way to do this is using Data Pump, which takes a long time and seeing how I need to backup several schemas it's rather complex.
I was wondering if it was possible just to issue a
BACKUP DATABASE on RMAN after I have the data set up. Then I would run my tests, and restore it using something like
RESTORE DATABASE FROM TAG <somedate>, and that would be all I need to get my tests going again. There should be no changes to the control file or anything like that.
Is this a safe way to go about doing this?