Recover database [message #354282] |
Fri, 17 October 2008 06:04 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
Hi,
I have question ragarding the Recover database command.
I do backup my database everyday at TAPE through RMAN.
1. Suppose one of my data file is currupted. And in MOUNT mode if i will execute the RECOVER DATABASE command then will it recover my database file from the latest backup which is located on TAPE?
2. And if only 1 datafile is currupted then what is difference between both the command because both will recover only datafile 1
RECOVER DATAFILE 1;
RECOVER DATABASE
Thanks,
[Updated on: Fri, 17 October 2008 06:13] Report message to a moderator
|
|
|
|
Re: Recover database [message #354504 is a reply to message #354282] |
Mon, 20 October 2008 01:20 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
Thanks Michel,
Quote: | No, have to first restore the file before recovering it
|
Do you mean to say I need to execute
RMAN > RESTORE DATAFILE 1; (If datafile 1 is currupted)
command to get the required datafile from TAPE to server location then need to execute RECOVER DATAFILE 1;
Am i right?
If yes, then what will be location of the RESTORED datafile?
Thanks,
[Updated on: Mon, 20 October 2008 01:21] Report message to a moderator
|
|
|
|
|
Re: Recover database [message #354509 is a reply to message #354507] |
Mon, 20 October 2008 01:55 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Yes all correct but for the backup source of datafile, the file comes from the latest backup that contains it (by default).
Regards
Michel
|
|
|