RE: rman question

Since we don't archive log on this database, I believe a restore will do it.  I 
just took the Oracle 11g admin class part II which dealt with rman but a lot 
from the em standpoint.  Plus we were on windows and the manual was unix.  My 
db's are on unix so I was ok with it.  In the past I did mostly unix scripted 
backups so I am familiar with all things oracle, just not as versed on rman as 
I wish.  Hence the class.........  We did practice recovery and restore.

________________________________
From: Niall Litchfield [niall.litchfield@xxxxxxxxx]
Sent: Tuesday, July 26, 2011 4:40 PM
To: Zelli, Brian
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: rman question


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@xxxxxxxxxxxxxxx<mailto:Brian.Zelli@xxxxxxxxxxxxxxx>> 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.


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

Other related posts: