Re: rman question

From: Robert Freeman <>
Date: Tue, 26 Jul 2011 16:12:48 -0700 (PDT)
Message-ID: <>


I can provide case after case after case where people did not understand and 
properly configure their backup and recovery architecture.... and disaster 
resulted. It is, job #1. If there is no data, there is no need for a database, 
tuning, replication, PL/SQL or any of that other cool stuff people love to do.



 Robert G. Freeman
Master Principal Consultant, Oracle Corporation, Oracle ACE
Author of various books on RMAN, New Features and this shorter signature line.

opinion of one Oracle employee. I can be wrong, have been wrong in the past and 
will be wrong in the future. If your problem is a critical production problem, 
you should always contact Oracle support for assistance. Statements in this 
email in no way represent Oracle Corporation or any subsidiaries and reflect 
only the opinion of the author of this email.

From: Andrew Kerber <>
Cc: "" <>; 
"" <>
Sent: Tue, July 26, 2011 12:48:56 PM
Subject: Re: rman question

If you work, or plan to work, as a professional DBA, I strongly recommend you be 
familiar with all the scenarios that Thomas describes.  At various times I have 
run into all those scenarios.

As others have noted in the past, backup and recovery is where DBA's earn their 
pay (and can lose their job for that matter).

On Tue, Jul 26, 2011 at 1:36 PM, Mercadante, Thomas F (LABOR) 
<> wrote:

>Essentially yes.
>It knows about all the backups.  It knows the state of the current database.  
>You are not describing your test case well enough to give a fuller answer.
>Did you lose a data file?  A couple of data files?  The entire database 
>including control files?
>If I were you ( and I’ve done this), I would create a test database and go 
>through recovery scenarious.
>Delete a data file and write the Rman script to restore and recover it.
>Delete a couple of data files and do the same.
>Delete the entire database including control files.
>Perform an incomplete (point in time) recovery of one tablespace.
>Roll a database back to a prior point in time.
>Get the idea?
> [] On 
>Behalf Of Zelli, Brian
>Sent: Tuesday, July 26, 2011 2:21 PM
>To: ''
>Subject: rman question
>So I've been putzing around with rman and now I have a list of backups.  If I 
>want to restore the very last copy of the db, all I have to do is issue a: 
>RMAN> recover database;
>that's it?  And it will take that last copy even though I have about 7 or 8 
>This email message may contain legally privileged and/or confidential 
>information. If you are not the intended recipient(s), or the employee or agent 
>responsible for the delivery of this message to the intended recipient(s), you 
>are hereby notified that any disclosure, copying, distribution, or use of this 
>email message is prohibited. If you have received this message in error, please 
>notify the sender immediately by e-mail and delete this email message from your 
>computer. Thank you. 

Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

Received on Tue Jul 26 2011 - 18:12:48 CDT

Original text of this message