Wednesday Jan 30, 2013

Taking the Black Magic Out Of Oracle Database Recovery

Backup_Recovery_Image

Introduction:

One of the biggest issues seen today with an Oracle database recovery is human error. More damage is done by administrators executing commands without a true understanding or an appreciation of the real condition of the existing Oracle database. Since the release of 11g it is interesting to question, how many administrators are actually using the RMAN recovery advisor which is now a tool built into the database?

The aim of this attached paper is to show that database recovery is not black magic. If a deep breath is taken at the point of failure and time is taken to properly diagnose the real condition of the database, whilst forming a firm action plan from what is available, and then the recovery becomes a simple straight forward process. That is providing any required backups are actually available of course!

Experience has shown that the main issue at the time of any fault is an administrator that jumps straight to the recovery phase with little or no analysis of the actual situation, potentially causing a bad situation to suddenly become worse.

The views expressed on this blog are those of the author and do not necessarily reflect the views of Oracle.  Please download the full paper for a detailed discussion as well as some recovery tricks you may not have come across.

Download The Full PDF hereMagic_Backup_Recovery.pdf

What Is Baker's Byte?

Hi, I’m Andy Baker and this blog is my attempt to give the Oracle production database administrators view of life. I hope to provide some interesting updates covering general items of interest, the issues I face as well as some I have previously solved. This is all based on my experiences at real client sites and will cover the Oracle RDBMS, RAC, Exadata and general administration Oracle DBA tasks as well as tips and tricks.

Although I am currently based in Oracle Consulting Services (OCS) my previous experience within Oracle has also been with Oracle Support Services (OSS) as a senior backup and recovery engineer. I have been working with Oracle databases for over 18 years and have experience in a wide range of industries and roles. This covers Banking, Oil and Gas, Insurance and Telecoms for many major global organizations. I have worked in software development but mainly focus in production support dealing with management and staff at varying levels, whilst having to meet rigorous performance and demanding time schedules.

About

About Me Image
Andy Baker, Senior Principal Consultant for Oracle Consulting Services (@Bakers_byte), shares his news, views and ideas about the Oracle Database with a focus on innovation and emerging technologies.

Search

Archives
January 2013 »
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
31
  
       
Today