Re: Restore Table

As soon as you know you are trying to do an incomplete recovery (which is indeed what you are trying to do), you have to restore ALL datafiles, not just the one you think is affected. Failure to do so notoriously produces the extremely unhelpful error message about 'system needs more recovery to be consistent'.

So, restore all datafiles, recover until time 'xx:xx:xx', then open database resetlogs, then shutdown immediate, and take a new closed database backup (because you've just rendered all previous backups and archives useless for future recoveries).

Regards
HJR

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


"Steve James" <stevejames73_at_hotmail.com> wrote in message
news:lrj%7.9700$X87.1540288_at_news2-win.server.ntlworld.com...


> Hi,

>

> A little problem I am having on a test system.

>

> I am running the system in archive log mode.

>

> I make a hot backup of all the data files at 1:00pm.

> After backing up all the data files I issue an alter system switch

logfile.


>

> At 4pm, I drop a table which I didn't want to do, so I want to do a

recover


> until time to five mins before I dropped the table.

>

> Is the correct process for this as follows?:

>

> Shutdown the database

> replace the backup data file which would of contained the dropped table.

> (the backup I took at 1pm).

> startup mount

> recover database until time '2001-01-10:15:55:00'

>

> I am getting a series of error messages regarding the system tablespace

> needing more recovery but this doesn't make much sense. I have been over

the


> Oracle documentation , which seems to go along with the process I have

> written above.

>

> Can anyone verify whether what I am doing is correct?

>

>

> Thanks

>

> Steve

>

>

>

>

>