Is it possible to have a late replication of primary database to secondary database using data gaurd?
Say for example, my primary database get refreshed every 3 days i.e drops all the tables and recreates them and repopulates them.
This takes roughly another 2 days.
During this time I need the secondary stand by database to be up and running so that reports can be generated from the previous data.
Its ok to have a 2-3 days lag.
As soon as the refresh process in primary database is complete, we can start the data gaurd and the secondary database also gets refreshed with the primary database i.e. the all tables get dropped and recreated and re-populated.