RE: rman question
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxx>
- To: "Brian.Zelli@xxxxxxxxxxxxxxx" <Brian.Zelli@xxxxxxxxxxxxxxx>, "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 26 Jul 2011 14:36:05 -0400
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Zelli, Brian
Sent: Tuesday, July 26, 2011 2:21 PM
To: 'oracle-l@xxxxxxxxxxxxx'
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.
Other related posts:
