Re: resore a database at a specific daytime

There's absolutely no reason to use 'backup controlfile' unless you are actually restoring a binary version of the control file.

A 'recover until time', as for any incomplete recovery, requires that you restore all data files, and do NOT resotre any of the online logs (which shouldn't be being backed up anyway), nor the controlfile.

If data files are restored, but not controlfiles, then there is an inconsistency which *must* require recovery. Only if you are restoring *everything* will you not be prompted for recovery. It is impossible, if you are doing everything correctly, NOT to be asked for logs to be applied.

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"Syltrem" <syltrem_at_videotron.spammenot.ca> wrote in message
news:qcfJ7.4083$qb4.31090_at_tor-nn1.netcom.ca...


> 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.

> > >>

> > >>

> > >

> > >

> >

> >

>

>