Re: Recovering Oracle 7 database via Arcserve

Karlheinz

Two possibilities exist:

1. If the article table is static and you have an up to date export, you MAY be lucky enough to be able to simply import it. The obvious issues here are any changes since the export are lost, and you need to ensure you don't cause integrity problems with other data.
2. If you are running in ARCHIVELOG mode, you can restore the database (except the controlfiles) from backup and recover to a point in time prior to the update statement.

HTH. Pete

Karlheinz Wodzinski wrote:

> I 've managed to blank all the article desciptions in a table by using an
> update statement with replace in SQL plus.
> The update statement now in my minor problem.
> I have stored the open (running, but not in use) database before and should
> like to retrieve the table with the articles.
> I now have done a complete dump and a storage with closed database
> 1. Is there a chance to recover the database from tape at all ?
> 2. What do I have to recover at least?
> 3. What problems do I have to face?
>
> Talking about 1.250 articles it could be a stressing weekend for me, please
> help.

Received on Fri Sep 24 1999 - 17:48:01 CDT