Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Restore Table
Howard,
Correct. This is what I am saying but you have put it in more a concise manner.
Paul.
In article <3c3e032f$0$4215$afc38c87_at_news.optusnet.com.au>, "Howard J. Rogers" <dba_at_hjrdba.com> wrote:
> 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
>>
>>
>>
>>
>>
>>
>
Received on Thu Jan 10 2002 - 18:08:43 CST