You probably have a cold backup to start with I reckon.
Try with:
recover database USING BACKUP CONTROLFILE until time ...
--
Syltrem
http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
To reply to myself directly, remove .spammenot from my address
"Filipe" <fil.dar_at_wanadoo.fr> a écrit dans le message news:
9t3em6$o83$1_at_wanadoo.fr...
> 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 - 15:10:39 CST
