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

Report message to a moderator

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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 16 09:03:05 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.