Database Backup and Recovery (MOSC)

MOSC Banner

Cannot recover tablespace

edited Jan 25, 2013 8:03AM in Database Backup and Recovery (MOSC) 19 commentsAnswered
I dropped one tablespace that contained a couple of tables.

drop tablespace TABLESPACE1 including contents and datafiles;

 Before dropping the tables, I backed up database while it was mounted, using

backup database; 

via RMAN.

Then I ran

RESTORE DATABASE;

RECOVER DATABASE;

followed by

ALTER DATABASE OPEN RESETLOGS;

Then I had to run

@?/sqlplus/admin/pupbld.sql

After that I logged in as my regular user and executed

SELECT TABLE_NAME FROM USER_TABLES;

and none of the tables from my dropped tablespace were retrieved. The tablespace itself also nowhere to be found.

What did I do wrong? Is there a way to recover my tablespace with all the tables in it?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center