Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: resore a database at a specific daytime
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 - 09:52:14 CST