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 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