Home » RDBMS Server » Backup & Recovery » Recover database (Oracle 10g)
Recover database [message #354282] Fri, 17 October 2008 06:04 Go to next message
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 #354287 is a reply to message #354282] Fri, 17 October 2008 06:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1. No, have to first restore the file before recovering it.
2. No difference.

Regards
Michel
Re: Recover database [message #354504 is a reply to message #354282] Mon, 20 October 2008 01:20 Go to previous messageGo to next message
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 #354505 is a reply to message #354504] Mon, 20 October 2008 01:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Yes you are right
2/ The current location by default

Regards
Michel
Re: Recover database [message #354507 is a reply to message #354282] Mon, 20 October 2008 01:37 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
One more question please Smile

Quote:
The current location by default


1. Then will it overwrite the current data file?

2. And if we RESTORE the data file then it will come from latest backup suppose, Incremental Level 1?

When i execute RECOVER Datafile 1 command then it will apply all necessory ARCHIVE Log files and redo log files.

Does my assumption is correct?

Thanks,
Re: Recover database [message #354509 is a reply to message #354507] Mon, 20 October 2008 01:55 Go to previous message
Michel Cadot
Messages: 64152
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
Previous Topic: Datafile Corrupted
Next Topic: sql to oracle transfer using full convert
Goto Forum:
  


Current Time: Sat Dec 10 22:26:50 CST 2016

Total time taken to generate the page: 0.14319 seconds