How to recover the file from the Tablespace?

If we had a tablespace, TEST_TABLESPACE, which consists of three files: TEST1.dbf, TEST2.dbf and TEST3.dbf, and someone accidentally used the Unix command "rm" to delte the file TEST2.dbf, what else would you need inorder to recover all the data that was present in TEST_TABLESPACE at the time that TEST2.dbf was deleted ? Thank you in advance.

more ▼

asked Jan 06, 2010 at 10:30 AM in Default

OraLearner gravatar image

1.3k 78 86 88

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

That would put you in a recovery situation.

The first thing you would do is fire the person who removed the file :)

What you would do next would be based on your backup/recovery plan. Do you have one?

Do you take weekly offline backups, or do you take daily incremental ones?

Hopefully you're running in ARCHIVE LOG mode, if not, you're going to lose all of the changes made to that file since your last backup.

more ▼

answered Jan 06, 2010 at 11:08 AM

HillbillyToad gravatar image

1k 2

(comments are locked)
10|1200 characters needed characters left

You may restore tablespace thanks to recovery software.
Next one must be suitable here [http://www.dbf.fixtoolbox.com][1]

[1]: http://www.dbf.fixtoolbox.com
more ▼

answered May 26, 2012 at 07:01 PM

philconnors26 gravatar image


(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 06, 2010 at 10:30 AM

Seen: 897 times

Last Updated: May 26, 2012 at 07:01 PM