OraFAQ Forum: Backup & Recovery » Datafile recovery

Home » RDBMS Server » Backup & Recovery » Datafile recovery (Solaris, oracle10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Datafile recovery [message #332854]

Wed, 09 July 2008 23:34

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 ??

Report message to a moderator

Re: Datafile recovery [message #332858 is a reply to message #332854]

Wed, 09 July 2008 23:41

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

restore <datafile>;
recover <datafeil>;

Regards
Michel

Report message to a moderator

Re: Datafile recovery [message #332868 is a reply to message #332858]

Thu, 10 July 2008 00:21

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

but how to determine the datafile is missing??

Report message to a moderator

Re: Datafile recovery [message #332869 is a reply to message #332868]

Thu, 10 July 2008 00:24

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: Datafile recovery [message #333249 is a reply to message #332869]

Fri, 11 July 2008 00:32

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

this question was asked in interview.that s y i clarified with u guys.

Report message to a moderator

Re: Datafile recovery [message #333250 is a reply to message #332854]

Fri, 11 July 2008 00:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It is not missing.
It is a figment of your imagination.
Please find it there.

Report message to a moderator

Re: Datafile recovery [message #333269 is a reply to message #333249]

Fri, 11 July 2008 01:38

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Don't use IM speak, you will fail your interview.

Regards
Michel

Report message to a moderator

Previous Topic:	RMAN USING CONTROL FILE
Next Topic:	Test backup/recovery

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 13:36:20 CST 2024