We are using oracle 19c on windows with a web software.
we hosted it ourselves.
We will have a year end process that takes 2 days that will be run on production.
But we plan to do a dry run on test enviroment. below are all on test environment.
For one of the steps it is to create a guaranteed restore point, then do some data entries and test then after that we revert back to guranteed restore point.
My question is on our current test environment we don't have archive mode turn on, so I need to be at startup mount mode to turn on archive mode after I refresh test environment from production.
Or I can wait till the second day that we test that part in the early morning to turn on archive mode.
Do i need to shutdown the web application first before I shut down database to turn on the archive mode?
Or I don't need to shut down the application, it will reconnect the database without problem after db is open ?
Also since we have limited space on the test server, do I have to do RMAN backup in order for restore guaranteed restore point to work and since it takes only two days the test process will be done, I thought maybe I don't need to do a backup to save space or maybe just do a backup at night when it is refreshed from prod.
Also when this is all done, I found I have to drop guranteed restorepoint.
Then disble archive log. So for turn off archive log I don't need to in mount mode, but in database open mode should be OK, correct?
Thank you