This content has been marked as final. Show 8 replies
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
infrastructure to create and maintain one or more standby databases to protect Oracle data from
failures, disasters, errors, and data corruptions. Data Guard is unique among Oracle replication
solutions in supporting both synchronous (zero data loss) and asynchronous (near-zero data loss)
configurations. Administrators can chose either manual or automatic failover of production to a
standby system if the primary system fails in order to maintain high availability for mission
- If you have good knowledges in "Materialized View"(More Developer Role than DBA).
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)+
Try Oracle Golden Gate!!!
Yes even I feel dataguard is a good option.
But I definitely want to try the streams too since its an 8G application and creating a new environment (dev/stage/prod and DR) for an 8G application is not something that I would want to proceed at this point.
Can you please help me with good pointers or notes for performing a schema level replication setup in streams?
Streams is complex and heavy performance-wise because works via AQ.
Also Oracle advocates to move from Streams to Golden Gates.
Golden Gates is fast but costly and does not have GUI for convenient management.
You can try some 3-rd party small footprint, easy to manage and inexpensive solutions like DataCurrents.
I know DC can work on schema level, even can pass DDLs like create/alter/drop table, partitions etc.