Recovering a tablespace

Hi Fellow DBA's

I had the dubious pleasure of recovering a tablespace. Here is the = scenario. One of my staff members was doing the job of cleanup and = 'accidently' deleted a user that was the owner of all the production = tables in a tablespace. I have full exports, I have on-line archive = backups. I thought this would be a piece of cake. I have done several = recoveries before. The only difference, this was not a media recovery. = =20

Well, I brought on the last full snapshot, did a full import and started = the recovery command on the tablespace, not database. It would not let me = do an incomplete recovery. Every time I tried to bring everything on = line, it would complain there was recovery to do. =20

My question is, does the incomplete recovery only work on a recover = database command and not recover tablespace?? I have done an incomplete = on the database before when I lost several data files, but I have not done = a recovery of just a tablespace. Bear in mind that the system thought = everything was ok. The person had done a commit and the other tablespaces = were still going. So, I had archives beyond that point in time. I did not = want them because it would have deleted all of the tables again! Any = suggestions?

By the way, I recovered with the import and just told the users they lost = 3 hours of work.

Victoria DeVore
Linn-Benton Community College
Systems & Application Programming Manager 6500 Pacific Blvd. SW
Albany, OR 97321
(541)917-4355
(541)917-4379 FAX
Received on Mon Sep 25 2000 - 13:48:56 CDT