| balaji |
Posted: May 27, 2008 01:15:54 AM |
Total Post: 163
Joined: May, 2008
|
hi all,
we take increemental backup at weekdays and full backup at weekends.If suppose my datafile is corrupted .how to recover the corrupted file using RMAN ?
Kindly revert me with the steps.
|
|
|
 MOH_DBA |
| Posted: May 27, 2008 02:55:05 PM |  |
|
Total Post: 161
Joined: Nov, 2007
|
You Can use the followings:
1)
restore tablespace tablespace_name;
recover tablespace tablespace_name;
2)
restore datafile [1] or [path];
recover datafile [1] or [path]
3)
BlockRecover command:
rman> blockrecover datafile 6 block 3;
|
|
|
|
|
| balaji |
| Posted: May 29, 2008 12:57:13 AM | |
|
Total Post: 163
Joined: May, 2008
|
|
|
|
|
| balaji |
| Posted: May 29, 2008 12:59:13 AM | |
|
Total Post: 163
Joined: May, 2008
|
|
|
|
|
| balaji |
| Posted: May 29, 2008 12:59:20 AM | |
|
Total Post: 163
Joined: May, 2008
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
