Jim Czuprynski

Synopsis. Oracle Database 11g Release 2 makes it much simpler to configure and incorporate many of the grid computing features that were only available in a Real Application Clusters (RAC) clustered database environment in previous releases for a single-instance Oracle database. This article – the first in this series – will demonstrate how to install […]

Synopsis. Oracle Data Guard still offers support for the venerable logical standby database in Oracle Database 11g. This article – the eighth in this ongoing series on Oracle Data Guard – investigates how data warehouse and data mart environments can effectively leverage logical standby database features, but simultaneously provide a final destination when failover from […]

Oracle Database 11g Release 2 New Features Summary, Part 2 Synopsis. After what seemed an eternity, Oracle finally released the long-awaited Oracle Database 11g Release 2 (11gR2) in September 2009. This final article in this two-part series completes a high-level evaluation of Oracle 11gR2’s plethora of new features so that Oracle DBAs can decide whether […]

Synopsis. While Oracle 11g’s Data Guard definitely protects a database when the entire production site is lost via its failover capabilities, it’s still necessary for an Oracle DBA to intervene to complete the failover process. This article – the seventh in this ongoing series – shows how to set up and control automatic failover using […]

Synopsis. Oracle at last released the long-awaited next version of Oracle Database 11g Release 2 (11gR2) in September 2009. This article – the first in this series – summarizes some of oracle 11gR2’s more intriguing new features and discusses how those features might help enterprises to decide to upgrade their Oracle 9i, 10g, and 11gR1 […]

Synopsis. Data Guard’s capability to recover a mission-critical database upon the loss of the entire production site is at the heart of Oracle 11g’s disaster recovery features. This article – the sixth in this ongoing series – explores how to manually fail over a production database to its corresponding physical standby database, as well as […]

Synopsis. Oracle Database 11g expands dramatically the ability to leverage a physical standby database for simultaneous support of both disaster recovery as well as intensive query activity. This article – the fifth in this ongoing series – also illustrates how Oracle 11g’s new snapshot standby features leverage a physical standby database for application quality assurance […]

Synopsis. Oracle Data Guard makes it possible to back up a production database using a valid physical standby database as the target for the backups, and those same backups can be used to restore and recover a production database. This article – the fourth in this ongoing series – demonstrates how Oracle Database 11g expands […]

Synopsis. The Data Guard feature set has been expanded dramatically in Oracle Database 11g to make it even easier for an Oracle DBA to control and monitor any complex, multi-database disaster recovery environment. This article – the third in this ongoing series – demonstrates how to extend an existing Data Guard Broker configuration into an […]

Synopsis. Oracle Database 11g offers several enhancements to the Oracle Data Guard feature set that helps an Oracle DBA to manage a complex, multi-database disaster recovery environment. This article – the second in an ongoing series – explores how to set up Data Guard Broker for simpler configuration, monitoring and maintenance of Oracle 11g primary […]

Synopsis. Oracle Data Guard is a crucial part of the insurance policy that guarantees against unrecoverable disasters. Each new release of Oracle has augmented these disaster recovery features, and Oracle Database 11g expands them dramatically to include the capability to keep a standby database open for read-only queries while still accepting change vectors from the […]

Synopsis. A crucial reason for upgrading the storage capabilities of Large Objects (LOBs) is the ever-expanding requirements for data security within an Oracle 11g database. This article – the last in this three-part series – investigates how to extend Transparent Data Encryption (TDE) security features to LOBs and tablespaces to secure data, and explains how […]