Re: database recovery HELP

"Steve" <schen_at_prodigy.net> wrote in message news:9ee2l0$4ids$1_at_newssvr05-en0.news.prodigy.com...
> Need urgent assistance on database recovery (Oracle 7.3):
>
> Thousands of rows were deleted accidentally last Friday. I have online
> archivelog in place. I can "recover database until
 '2001-05-18:12:30:00',
> then alter database open resetlog. Then I export that recovered table
 for
> later insertion.
>
> I want to recover database again back to the moment that I started the
> recovery for I need to have database back to the point that I started
> recovery, so that Monday, Tuesday data still there. I then just import
> back the table rows.
>
> I am not sure that resetlog command on the first recovery would post some
> problem on 2nd recovery, for the log sequence would be change after "alter
> database open resetlog". Right? Can I recover like these? Or do I
> have to put all database files back to that point to do 2nd recovery.
>
> I have not implement all recovery procedure yet.
>
> Need your timely assistance.
>
> Very appreciated.
>
> Steve
>
>

You need to restore the data a second time, for your recovery 'until now'

Hth,

Sybrand Bakker, Oracle DBA Received on Tue May 22 2001 - 11:48:15 CDT