Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: resore a database at a specific daytime

Re: resore a database at a specific daytime

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Fri, 16 Nov 2001 15:52:14 GMT
Message-ID: <OCaJ7.35953$XJ4.20510437@news1.sttln1.wa.home.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US