Home » RDBMS Server » Backup & Recovery » Datafile recovery (Solaris, oracle10g)
Datafile recovery [message #332854] Wed, 09 July 2008 23:34 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member


HI experts

How to determine datafile is corrupted or missing and how to recover the missing datafile using RMAN ??


Re: Datafile recovery [message #332858 is a reply to message #332854] Wed, 09 July 2008 23:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
restore <datafile>;
recover <datafeil>;

Regards
Michel
Re: Datafile recovery [message #332868 is a reply to message #332858] Thu, 10 July 2008 00:21 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

but how to determine the datafile is missing??
Re: Datafile recovery [message #332869 is a reply to message #332868] Thu, 10 July 2008 00:24 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
balaji1482 wrote on Wed, 09 July 2008 22:21
but how to determine the datafile is missing??


One clue would be some sort of error message.
Why do you think/know/suspect you have a datafile that is missing & needs to be fixed?
Re: Datafile recovery [message #333249 is a reply to message #332869] Fri, 11 July 2008 00:32 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

this question was asked in interview.that s y i clarified with u guys.
Re: Datafile recovery [message #333250 is a reply to message #332854] Fri, 11 July 2008 00:40 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
It is not missing.
It is a figment of your imagination.
Please find it there.
Re: Datafile recovery [message #333269 is a reply to message #333249] Fri, 11 July 2008 01:38 Go to previous message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't use IM speak, you will fail your interview.

Regards
Michel
Previous Topic: RMAN USING CONTROL FILE
Next Topic: Test backup/recovery
Goto Forum:
  


Current Time: Wed Dec 07 03:08:38 CST 2016

Total time taken to generate the page: 0.08600 seconds