RE: rman question
- From: "Zelli, Brian" <Brian.Zelli@xxxxxxxxxxxxxxx>
- To: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- Date: Tue, 26 Jul 2011 17:40:55 -0400
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.--
//www.freelists.org/webpage/oracle-l
Other related posts:
