Re: rman question

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 26 Jul 2011 21:40:42 +0100
Message-ID: <CABe10saaEnRQvdLQUG6prB_MYFUXxqcu35Oe=9H6QnbvOxe0FQ_at_mail.gmail.com>

Essentially yes. You *may* I doubt it in your case not have picked up on the distinction of restore (when you need to pull back files from the backups) and recovery (application of archived redo). RECOVER will not do the restore part - except where archive logs are not on disk, and RESTORE will not do the recover bit. So for complete restore and recovery you will need

RESTORE <DATABASE|DATAFILE>;

RECOVER <DATABASE|DATAFILE>;

These will use the most recent appropriate available backups (including incrementals) to attempt a complete recovery.

On 26 Jul 2011 19:23, "Zelli, Brian" <Brian.Zelli_at_roswellpark.org> wrote:

**

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.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 26 2011 - 15:40:42 CDT