I have two main questions when it comes to refreshing a database:
1) How often should a snapshot be performed prior to a refresh? Say we will do a database refresh at 12a. Are there recommendations for the frequency and time frame for snapshots prior to this time (8p, 10p, etc)? At what point is too many snapshots a bad idea?
2) Prior to refreshing a database, we run ALTER SYSTEM ARCHIVE LOG CURRENT on the source database. After this command is run:
a) Can a VDB refresh be started immediately for refreshing to LATEST?
b) Can a VDB refresh be started from LATEST and at the same time, new activity be written to the source database? For example:
i) 11:50 - database activity is stopped
ii) 11:51 - system archive logs are flushed via above command
iii) After above is complete: start VDB refresh
iv) Can new activity be written to source DB while above refresh is still ongoing? Or would that new activity conflict with the refresh?
Hope that is clear! Thank you!