| Recover database [message #354282] |
Fri, 17 October 2008 06:04  |
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  |
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 |
 |
Michel Cadot
Messages: 68647
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
