With the availability of Active Data Guard, what role does SQL Apply (logical standby) continue to play?
Use SQL Apply for the following requirements: (a) when you require read-write access to a synchronized standby database but do not modify primary data, (b) when you wish to add local tables to the standby database that can also be updated, or (c) when you wish to create additional indexes to optimize read performance. The ability to handle local writes makes SQL Apply better suited to packaged reporting applications that often require write access to local tables that exist only at the target database. SQL Apply also provides rolling upgrade capability for patchsets and major database releases. This rolling upgrade functionality can also be used by physical standby databases beginning with Oracle 11g using Transient Logical Standby.
Related Questions
- Im a Reserve Component or Guard member who regularly or repeatedly comes on, and leaves, active duty. Am I eligible to receive a DLA on any of those moves to or from active duty?
- Must I purchase Active Data Guard if I am not using Real-time Query or RMAN block change tracking on my standby database?
- Why can I not send email when the Protexx Data Guard Dog is active?
