Monthly Archives: January 2011

Oracleasm disks not listed in v$asm_disk

Recently I’ve seen a strange issue with oracleasm disks. Disks were listed in oracleasm but were missing from v$asm_disk view. It was a RAC environment & this was happening only on one node. node-2:~ # oracleasm listdisks DK65_1 DK65_10 DK65_11 … Continue reading

Posted in Oracle Automatic Storage Management | Tagged | 6 Comments

Enabling Redo Log Transport Compression

Redo Log Transport Compression feature was added in Oracle 11gR1 primarily for quickly resolving the archive log gap. Seeing the scope of setting this parameter, Oracle has documented hidden parameter _REDO_TRANSPORT_COMPRESS_ALL, which can be used to enable compression for ASYNC/MaxPerformance … Continue reading

Posted in Oracle Data Guard | Tagged | 4 Comments

Implementing Active Data Guard

Active Data Guard is another extension of physical standby, which is open in read-only mode, but applying the logs in the background. This keeps the database up-to-date and allows Real-Time Queries During Managed Recovery process. a) Current physical standby database … Continue reading

Posted in Active Data Guard, Oracle Data Guard | Tagged , | 2 Comments

Implementing Snapshot Standby

What is a Snapshot Standby database? In simple words, it is an updatable copy of physical standby database. To configure snapshot standby, we need to configure physical standby, which can be converted to snapshot standby and vice versa. This is … Continue reading

Posted in Oracle Data Guard, Oracle Snapshot Standby | Tagged | Leave a comment

2010 in review

The stats helper monkeys at WordPress.com mulled over how this blog did in 2010, and here’s a high level summary of its overall blog health: The Blog-Health-o-Meter™ reads Wow. Crunchy numbers A Boeing 747-400 passenger jet can hold 416 passengers. … Continue reading

Posted in Uncategorized | Tagged | Leave a comment