Posts

Showing posts from October, 2017

Data Guard / Far Sync Best Practice - control protection levels

I have just came across a meta parameter called DB_ULTRA_SAFE that sets the values for all of mentioned parameters in Far Sync Best Practice Recommendations (for Oracle 12.1).

When DB_ULTRA_SAFE=DATA_ONLY
  •DB_BLOCK_CHECKING => MEDIUM.
  •DB_LOST_WRITE_PROTECT => TYPICAL.
  •DB_BLOCK_CHECKSUM => FULL.

When DB_ULTRA_SAFE=DATA_AND_INDEX
  •DB_BLOCK_CHECKING => FULL.
  •DB_LOST_WRITE_PROTECT => TYPICAL.
  •DB_BLOCK_CHECKSUM => FULL.

When DB_ULTRA_SAFE=OFF
  •When any of DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM, or DB_LOST_WRITE_PROTECT are explicitly set, no changes are made.

Oracle open world 2017 short summary

Image
Hi, The main subject in this conference was Autonomous Database, it's engine is used by another buzzword called: Machine Learning. 
Oracle claim they are investing in autonomous to prevent data theft, but it seems as convenience for handling only one version in the cloud.
They will use the same "Machine Learning" engine that they used for the optimizer and memory management decisions (This engine is well known for bad decisions). 18c is an alias for 12.2.0.2 and planned to be available: Autonomous Database for Data Warehouses - by December 2017Autonomous Database for OLTP – by June 2018 A companion solution for the "Machine Learning" will be used via the OEM (Cloud Control) to gather: Infrastructure logs: Network, Server, Storage, VM, OSPlatform logs: Database, Java, Analytics, etc.Application logs: ERP, CX, HCM, Custom, etc. The logs will be gathered to detect and connect anomalous events. SLA Guarantees 99.995% reliability and availability (less than 30 minute…

Oracle 18c - New Features for Active Data Guard

Image
Hi,

At Oracle Open World 2017 I collected the main improvements and changes
 are going to be implemented in Oracle Database 18c:

RMAN
-Refresh a standby from primary/backup using single RECOVER command
Data Guard
-In Memory Column store works with multi-instance redo apply
-Multi-instance redo apply support with Block Change Tracking (BCT)
-Global Temporary Table support from Standby.
-DML operations on Standby – Redirection to Primary without ACID compromise.
-Preserve buffer cache during role-change.
-No logging enhancement - Performance mode and Availability mode.



Yossi Nixon