Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: File needs media recovery - no can do!
First, you modify parameter file(maybe init.ora) which contains
" rollback_segments=(r01,r02,r03,r40...)" statement.
You delete the corrupted rollback segment name(e.g r03) in the lists.
Second, you shutdown your database.
Third, you startup your database file using modified parameter file.
Fourth, you create a new rollback segment in the tablespace.
It may help you.
S.R.LEE Received on Tue Feb 23 1999 - 23:52:04 CST