Way to recover a database without backup?

We have just lost a tablespace on our live database (looks like someone ran the command "drop tablespace $$$ including contents"). The tablespace (GSIF) is gone! But we can see the datafile (e:oradatagsifgsifm01.dbf). Is there a way of recovering the tablespace with its original contents (schemas, etc.) without going to the backup?

    Requires Free Membership to View

    Login

Unfortunately, you will have to recover from your backup and perform a tablespace point-in-time restore (TSPITR). Restore right up until the time the tablespace was dropped. You can get this time from your alert log as it will contain the DROP TABLESPACE command.

This was first published in November 2005

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top