Re: Table Recovery

bluebody wrote:
>
> Is there a way to recover data that was deleted from a table and committed
> without using a database backup and applying redo log files? Some of my
> archived log files are no longer available since my last backup so I can't
> go that route. I do have archived logs that go back to the time that the
> data was deleted.

It is possible to recover from this situation but you have to be VERY CAREFUL and know what you are doing.

Essentially what you will have to do is create a new instance + database using your old backup files. There are quite a few ways of doing this , the differences largely depend whether you will be using the same server or not.
Once the new instance has been created you can use the archive logs to recover that database to the required point ( only until your missing ones I'm afraid ) and then use export and import to transfer the individual table data from the new database back to the live one.

As I said you need to pretty au fait with recovery techniques but I may be able to give some more detailed advice if you wish.

Ian Cary Received on Fri Jul 25 1997 - 00:00:00 CDT