Ask the Expert

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

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: