RE: rman question

From: Mercadante, Thomas F (LABOR) <"Mercadante,>
Date: Tue, 26 Jul 2011 14:36:05 -0400
Message-ID: <AD4532B304E00C4F9AEFA0D338DF7DD1011A9B9800_at_excnysm95banp.nysemail.nyenet>


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?


From: [] 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 listed?


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.

Received on Tue Jul 26 2011 - 13:36:05 CDT

Original text of this message