How to recover rollback segment???

[mingichu]

I got error messages when opening the database
ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: 'H:\RBLARGEFILE.ROL'

I removed this rollback segment from init.ora, mounted oracle, and used "Alter database datafile datafile 'H:\RBLARGEFILE.rol' offline drop". After opening oracle, I backed up the control file to trace. Then, the following problems occured when I tried to take it offline and drop it:
1. alter rollback segment RBLARGE offline --> error msg: this rollback segment is not noline.
2. Drop rollback segment RBLARGE --> ORA-01548: active rollback segment "RBLARGE" found, terminate dropping tablespace

Does anyone know how to solve it? Thanks in advance!!!!!

 

[karluk]

I think you should have recovered your datafile instead of trying to drop it. You may still be able to do so. Do you have a backup that you can use for recovery?

 

[mingichu]

Yes, we have it. Actually, we are restoring the backup from the tape, then we will reprocess today's job.

Our Oracle is in non-archivelog mode. I guess I can't recover datafile after Oracle is restored, can I?
Do I need to recover this rollback seg after Oracle is restored?

Thanks again!

 

[karluk]

If you aren't running in archivelog mode, you most likely will be restoring a cold backup. If that's the case, no recovery will be needed after the restore. Of course you will lose all updates that happened after the time of the backup.