| Prashant |
Posted: Mar 15, 2008 05:17:56 AM |
Total Post: 9
Joined: Oct, 2007
|
What do I need to do if my undo tablespace needs media recovery???
Pls help me. |
|
|
 raj |
| Posted: Mar 15, 2008 05:21:50 AM |  |
|
Total Post: 2
Joined: Feb, 2008
|
Hai;
first ur database in atrchivelog mode then shutdown ur database restore ur datafile of undo tablespace then give the command recover tablespace uno or recover database datafile 'path of undo datafile'.
|
|
|
|
|
| Prashant |
| Posted: Mar 15, 2008 05:29:04 AM | |
|
Total Post: 9
Joined: Oct, 2007
|
And if the database is in non archive log mode then what do i do ???
|
|
|
|
|
| Mohammed Taj |
| Posted: Mar 15, 2008 08:07:24 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
Restore full recent cold backup and recover your database.
Regards
Taj
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
