Is there any kernel or database release version is there before start configure oracle data guard on oracle 10.2.0.4. System kenerl release is as below.
from my experience everything greater than 10.2.0.4 is pretty good. Oracle 11g R2 has some nice (hidden) surprises for us as well (e.g. "_deferred_log_dest_is_valid").
What about Oracle 12c? Anybody else exploring it as well? It is a pretty nice one, hopefully SAP will use several features now and do not strip it down to its minimum.
I have heard that you can now commit on the standby side when the redo data is in memory (instead of writing it to disk first) -> sync configurations will have a smaller performance impact then. The example on a customer test database showed 17ms commit time versus and 9ms.
Cheers Michael
PS: i cannot identify a real killer feature on 12c so far, they seem to have just steadily improved what was there in 11g. Multitenant databases, ADO sound nice, but probably not for the SAP world. I look forward to the RMAN single table restore though
> I have heard that you can now commit on the standby side when the redo data is in memory (instead of writing it to disk first)
Yes this is true and called "Fast Sync" nowadays. Official 12c R1 Documentation "1.5.6.3 Fast Sync":
Data Guard maximum availability supports the use of the NOAFFIRM redo transport attribute. A standby database returns receipt acknowledgment to its primary database as soon as redo is received in memory. The standby database does not wait for the Remote File Server (RFS) to write to a standby redo log file.
However this attribute was also available (and working) in the previous Oracle releases, but you needed to set it manually. Oracle 11g R2 Documentation: AFFIRM and NOAFFIRM
> I cannot identify a real killer feature on 12c so far, they seem to have just steadily improved what was there in 11g
In my opinion there are two "killer features" in the Data Guard section. Cascading standby database support for DGMGRL and Oracle "Active Data Guard Far Sync" (in combination). Now you are able to build up SYNC DG scenarios over long distances without a huge performance impact and manual interaction (like the need of a "full cascading standby database") or third party (WAN-)accelerators.
Multitenant databases can be very useful in SAP environments (just think about the time for Oracle upgrade cycles in large SAP system landscapes), but as always it depends on SAP and their will to use all of that stuff. I totally trust in Dr. Christian Graf and his team to identify such benefits and use that features in the future.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.