Open database with delay

Posted by oraclue on December 14, 2009 · 3 Comments 

The event db_open_begin delay (opening database with delay)  is undocumented event ( read unsupported ) and it will do exactly what is says e.g. open database with delay .Although alter database open command is executed it will wait for specified interval before opening database. So here is scenario: SQL> startup mount; ORACLE instance started. Total System Global Area 2973003776 … Read more

Filed under Internals

High Availability – Oracle GoldenGate

Posted by oraclue on December 7, 2009 · 1 Comment 

The GoldenGate ( now owned by Oracle Corporation ) for Active-Active solution provides  real-time bidirectional data movement between heterogeneous dual-active or multi-master databases. GoldenGate’s Active-Active solution also offers advanced features for data conflict detection and resolution. KEY FEATURES: Allows application transactions to be distributed across multiple databases Provides full bi-directional data movement without distance constraints … Read more

Filed under HA