I want to clarify something on replication.
When is it actually needed?
If we want a cold DR site for our production database or even hot, do we really need replication?
my understanding this is needed for real-time failover or DR site only and that oracle uses Data guard for it.
however, i beleive we can always restore from nightly backups for last night snapshot or apply redo logs to get point in time recovery.
can you explain/cnfirm?