Home » RDBMS Server » Backup & Recovery » Datafile recovery concept (Oracle, 10.2.0.2.0 , unix)
Datafile recovery concept [message #480811] Wed, 27 October 2010 06:46 Go to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member


Hi,


One datafile got corrupted.I found the corrupted file using v$recover_file.Immediately i execute the following commands.


Shutdown immediate
startup mount
alter database recover datafile '
alter database open.

finally the datafile recovered.

My question here is how the data file recovered?

Thanks
Re: Datafile recovery concept [message #480836 is a reply to message #480811] Wed, 27 October 2010 08:26 Go to previous message
Michel Cadot
Messages: 59142
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you didn't drop the file, RECOVER did not fix block corruption.
Oracle saw the datafile is up to date and so immediatly ended the recovery.

This is just an assumption: always copy and paste your session, the WHOLE session, do not try to explain something you don't understand.
Before, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel
Previous Topic: dB can't produce archived log files
Next Topic: Control file errors, ORA-00214
Goto Forum:
  


Current Time: Fri Sep 19 02:50:22 CDT 2014

Total time taken to generate the page: 0.25957 seconds