877343 wrote:- If you need Disaster Recovery Solution ->
I need to setup the same schema in a DR site and replicate the whole data continuously so that if there is an issue in primary site, I can switch to the DR site.
3. Move this application (schema) to a new database with Physical Standby Dataguard configuration.Oracle Data Guard provides the management, monitoring, and automation software
1. Set up Materialized View in both Primary and DR database schema so that the schema gets refreshed continuously- Streams -> complicated for beginners.
2. Implement streams and replicate the data across the schema's (Both from Primary db to DR and viceversa)+