Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: resore a database at a specific daytime
Hi,
The solution is OK, that's what we did. But we didn't experience a probleme with our database ( no drop, no delete, no crash...). That's the reason why Oracle doesn't want to recover!!! There is no problem for it. Anyhow we would like to restore the database in that way.
Thanks.
Jim Kennedy a écrit dans le message ...
>Did you put the files back where the table existed? You need to put the
>last backup before the drop occurred and then issue the recover to a point
>in time.
>Jim
>"Filipe" <fil.dar_at_wanadoo.fr> wrote in message
>news:9t3c6b$m4j$1_at_wanadoo.fr...
>> Hi,
>>
>> Is it possible to restore a database at a precise moment of the daytime?
>> For instance: After a 'Drop Table', I would like to restore the database
>> just before that 'Drop Table'. The mean is 'recover database until time',
>I
>> know. But Oracle says "Media Recovery Not required". Can we pass through
>> that message anyway?
>> The database is in the Archive Log Mode state.
>>
>> Trully yours.
>>
>>
>
>
Received on Fri Nov 16 2001 - 10:27:01 CST