-
Architect Your Oracle Database for Efficient Backup and Recovery
Aug 3, 2017Architecting 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, 2017Oracle 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, 2016Another 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, 2016I 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, 2016To 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, 2014Regulatory 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, 2014While 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, 2013Infoworld 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 -
Total System Failure: Why you should validate your database backup
Apr 23, 2013Every now and then things happen that make us realize how important double checking things can be. I had a recent experience in which four unrelated parties (including me) did the wrong thing regarding one business transaction. If any one of us had done the right thing, there would have been no problem. But all … Continue reading Total System Failure: Why you should validate your database backup
Read more Add new comment -
Database Downtime: Prepare For The Unexpected
Jan 21, 2013Test your Assumptions: Database Backup and Recovery Every now and then something happens that really drives home the need to test and validate the assumptions that we have about the availability of our IT assets. I had an experience this week that brought to mind the importance of testing backup and recovery and business continuity plans. … Continue reading Database Downtime: Prepare For The Unexpected
Read more Add new comment