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