Home » RDBMS Server » Backup & Recovery » Datafile recovery ( Oracle 10g)
Datafile recovery [message #322941] Mon, 26 May 2008 22:16 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

hi all,

we take increemental backup at weekdays and full backup at the weekend.If suppose my datafile is corrupted .how to recover the corrupted file using RMAN ?



Kindly revert me with the steps.

[Updated on: Mon, 26 May 2008 22:17]

Report message to a moderator

Re: Datafile recovery [message #322943 is a reply to message #322941] Mon, 26 May 2008 22:22 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Kindly revert me with the steps.

Read The Fine Manual below to find the answer you desire.

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/toc.htm

Re: Datafile recovery [message #322949 is a reply to message #322941] Mon, 26 May 2008 22:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
restore datafile '...';
recover datafile '...';

Regards
Michel
Re: Datafile recovery [message #322952 is a reply to message #322949] Mon, 26 May 2008 23:11 Go to previous message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

thanks
Previous Topic: how to recreate confil without any bkp
Next Topic: Cannot open the database
Goto Forum:
  


Current Time: Mon Nov 25 21:51:33 CST 2024