Database Blog

• Tales of Business Continuity and Disaster Recovery Planning

  Oct 2, 2017

  Planning for Disaster As we think about the enormous cleanup effort taking place in the wake of Harvey, Irma, and Maria, we are reminded of the importance of planning to keep your business up and running when disaster strikes.  In this blog post I share the thoughts of an expert in the field of Business … Continue reading Tales of Business Continuity and Disaster Recovery Planning

  Read more Add new comment

• Database Backups and Gasoline Leaks

  Sep 5, 2017

  How is a database backup like a portable generator with a gasoline leak? And why should you care on a beautiful sunny September morning? How does any of this relate to Business Disaster Recovery and Business Continuity planning and testing?  Read On! Lack of Preparation Until Superstorm Sandy in 2012, we had lived in our NJ town for … Continue reading Database Backups and Gasoline Leaks

  Read more Add new comment

• Architect Your Oracle Database for Efficient Backup and Recovery

  Aug 3, 2017

  Architecting for Backup and Recovery Efficiency with Oracle RMAN Database architecture is critical to achieving many business objectives. These include application performance, business continuity, security, and geographic distribution.  This article will explore another often overlooked objective that can be influenced by the database architecture: backup and recovery efficiency. Very large databases are common in today’s business … Continue reading Architect Your Oracle Database for Efficient Backup and Recovery

  Read more Add new comment

• Duplicating and Recovering Oracle Databases with RMAN

  Jul 5, 2017

  Oracle Recovery Manager Purpose and History Oracle Recovery Manager (RMAN) was developed essentially as a way to more effectively backup and recover Oracle databases, as an automation mechanism for the same, and as a way to keep track of and managing backup sets. It was introduced in version 8 of the Oracle database, so it … Continue reading Duplicating and Recovering Oracle Databases with RMAN

  Read more Add new comment

• Time to Validate Your Database Backup

  Jul 8, 2016

  Another new client, Another bad backup I originally wrote this post in July but I am updating it today because it is so important.  Yesterday we did an initial Oracle Database Health Check for another new client and found yet again that their backups are useless. This time the client was taking backups regularly, but … Continue reading Time to Validate Your Database Backup

  Read more Add new comment

• Architecting to Maximize Recovery Options in Oracle

  Apr 21, 2016

  I recently received a frantic call from a client that believed they have been hacked and had to quickly recover data. They said that data belonging to two or more of their customers had been lost. Our customer functions essentially as an application service provider (ASP). Their customers’ data is in an Oracle database that … Continue reading Architecting to Maximize Recovery Options in Oracle

  Read more Add new comment

• Do You Know If Your Data Backup and Recovery Strategy Is Working… Or Not?

  Feb 1, 2016

  To mitigate the business impacts of downtime and data loss, every Oracle database must be recoverable. This means every Oracle shop needs a strong backup and recovery strategy—one that takes into account the probabilities of hardware, software, network or procedural failure(s) in your current environment.

  Read more Add new comment

• Compliance 101 for Oracle DBAs

  Nov 25, 2014

  Regulatory compliance issues are top-of-mind for today’s senior executives. New laws and industry regulations are changing how organizations acquire, store, manage, retain and dispose of data. Every Oracle DBA should be aware of these changes because of their sweeping impacts on the DBA job role. Compliance goes hand-in-hand with security because regulations often mandate that … Continue reading Compliance 101 for Oracle DBAs

  Read more Add new comment

• Privileges missing after Oracle full import

  Mar 12, 2014

  While performing a migration from Oracle 10g to Oracle 11g (on new hardware) recently,  we encountered a familiar frustration that I am surprised is not resolved yet.  There are multiple ways to migrate a database from one version to another. One of the oldest and easiest ways is to create your database in the target … Continue reading Privileges missing after Oracle full import

  Read more Add new comment

• Critical Oracle Security and Stability Flaw Discovered

  Jun 17, 2013

  Infoworld today announced that they have been researching a flaw in oracle that can result in the inability to restore your database. Large oracle shops with interconnected databases are most at risk. The problem revolves around oracle’s SCN (system change number). The number has a limit that if exceeded, can render a database unusable, even … Continue reading Critical Oracle Security and Stability Flaw Discovered

  Read more Add new comment