Monday, January 5, 2015

Recovering datafile from backup RMAN

I have lost or corrupt one of my datafile and  have backup of that datafile.
Lets see how we can do it.
assume that i missed datafile 5.

RMAN>  sql'alter database datafile 5 offline';

RMAN> restore datafile 5;

RMAN> recover datafile 5;

RAMN> sql'alter database datafile 5 online';

That's it!!
Thanks!

No comments:

Post a Comment