Can we recover from Lost Rollback tablespace
hi all ,
this is just a test Scenario. We have a test database and we had taken a backup leaving the RBS tablespace together with the controlfile. Now the database is crashed , i.e someone by mistake replace the current files with the old backup. So the controlfile and datafiles are all in sync without the RBS datfile cos it an newer version than the others.
Now can we so something about it .By droping this tablespace or is there a method to recover it. Cos when i tried to take the datafile offline drop and open the database then i try ot create another rollbacksegment it does not allow. Cos it needs an online rollback segment.
I dont think so the database can be recovered,
Is there any method :confused: