Re: Logical Standby
- From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
- To: tim.evdbt@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 19 Jan 2023 21:34:07 -0500
On 1/19/23 17:14, Tim Gorman wrote:
Can you cite a reference stating that logical standby is being
deprecated or has been deprecated?
All I could find was references from the Oracle10g timeframe about
DataGuard Broker and failovers to Logical Standby, but nothing about
deprecation.
One big advantage of Logical Standby as opposed to GoldenGate is cost,
which is probably why the original poster is intending to try it in
the first place.
Here is the part from the deprecated features manual that has confused me:
Oracle Data Guard Logical Standby Properties Deprecated
Starting in Oracle Database 19c, Logical Standby properties of Oracle
Data Guard broker are deprecated.
The following Oracle Data Guard broker Properties that affect Logical
Standby are deprecated:
*
|LsbyMaxEventsRecorded|
*
|LsbyMaxServers|
*
|LsbyMaxSga|
*
|LsbyPreserveCommitOrder|
*
|LsbyRecordAppliedDdl|
*
|LsbyRecordSkippedDdl|
*
|LsbyRecordSkipErrors|
*
|LsbyParameter|
The manual can be found here:
https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/behavior-changes-deprecated-desupport-oracle-database.html#GUID-67D84AC9-4E9A-4F10-82C4-0FCF40AD16E1
Logical standby features in DGMGRL are deprecated, not logical standby
itself. That's what happens when I don't read carefully.
With respect to price, you are right, logical standby is much cheaper
than GG. However, managing a logical standby is a pain in the neck....or
lower, especially if the standby database is used to read and write.
Skipping transactions, fixing inconsistencies and using skip packages to
skip DDL operations (truncate) can be a lot of effort. I find GG much
easier to use, but that's my personal impression only. I confess that I
have much less experience with GG than with logical standby. With GG, I
was only replicating one relatively small set of around 250 tables from
an OLTP database to data warehouse and that was it. It wasn't making any
fuss at all and was easy to maintain. However, I am a development DBA
now and I leave configuration of both standby databases and GG to other
people. I also don't get called in the middle of the night when
log_archive_dest_1 gets filled up because storage team did some
maintenance and the archive log backup was turned off.
Again, I apologize for the misinformation. Please don't report me to the
DHS.
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
Other related posts:
