Recover DB from hot backup & roll forward.
Hi all,
I'm trying to recover a DB from a storage snapshot and roll forward to a certain time. We're trying this on a test server before applying to production systems.
Our procedure is the following :
1/ put the DB into "begin backup".
2/ taking a storage copy all the data (datafiles, controlfiles etc.) with PureStorage mechanism.
3/ Continuing normal activity...
4/ Recovery stage:
a) shutdown the DB and the copy back the PuregStorage backup
b) startup mount, alter database end backup & recover database until time '2021-06-01:01:00:00' (my begin backup was 31/5 at 15:00)
Recover applies all the archivelogs and at the end we get the following message.