This content has been marked as final. Show 8 replies
1 person found this helpful
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!!!
Registered: Aug 4, 2011
Total Posts: 28
Total Questions: *17 (15 unresolved)*
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?
http://www.oracle.com/pls/db112/portal.portal_db?selected=15&frame=1 person found this helpful
Thanks Asif. Appreciate your help
i would add golden gate to the mix (it will cost you ) depending your SLA requirements.
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.