database recovery HELP

From: Steve <schen_at_prodigy.net>
Date: Tue, 22 May 2001 12:06:31 -0400
Message-ID: <9ee2l0$4ids$1@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 Received on Tue May 22 2001 - 11:06:31 CDT