trying to drop tablespace RBS getting error

[supermega]

I am trying to drop tablespace RBS (my rollback tablespace)
It is offline and so are the datafiles associated with it. When I issue the "drop tablespace RBS including contents" command it gives me an error saying "ora-01548 Active rollback segment 'RBS1' found, terminate dropping tablespace"

How can that RBS1 be active if the tablespace is offline?
How do I make it not active so I can drop it?

Thanks TONS,
SM

[tamilselvan]

FIrst, issue the following command:
ALTER ROLLBACK SEGMENT RBS01 OFFLINE;

Then, drop the tablespace.

[supermega]

well I did and it gives me "ora-01598 : rollback segment 'RBS1' is not online"

[supermega]

I think the problem is...
The underlying datafile needs recovery so the status of all of the rollback segs is needs recovery.
I cannot recover the datfile ( im runnin 7.2.2.4 on Novell and I am having tons of problems trying to recover, Sooo im just going to drop the tablespace and recreate it, but It doesnt seem to want to let me drop it)

[Halo]

Try this:
0. take cold backup
1. comment out all rbs in init.ora
2. startup mount
3. drop/recreate rbs ts; delete dbf at OS level
4. create the rbs in the ts
5. uncomment the rbs in init.ora
6. startup the db.