Re: rman question

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Tue, 26 Jul 2011 13:48:56 -0500
Message-ID: <CAJvnOJZDautGJ4mdYtPYCCRrKMm0o1qjFoqnT5NLaHVkkEqoww_at_mail.gmail.com>



Brian-
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) < Thomas.Mercadante_at_labor.ny.gov> wrote:

> Brian,****
>
>
> 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?****
>
> ** **
>
> Tom****
>
> ** **
>
> ** **
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Zelli, Brian
> *Sent:* Tuesday, July 26, 2011 2:21 PM
> *To:* 'oracle-l_at_freelists.org'
> *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
> listed?****
>
> ****
>
> ciao,****
>
> Brian****
>
> ****
>
>
> 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.'

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 26 2011 - 13:48:56 CDT

Original text of this message