Re: database recovery HELP

The final word:

You have to do the recovery twice. Take a cold backup of the database at it's "now" state, restore the previous backup, use time-based recovery + open resetlogs, take your export, restore to the previous backup, start normal recovery (RECOVER DATABASE) until it's complete, then import the data that you exported.

Good luck!
Dave

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
>
>
Received on Tue May 22 2001 - 19:49:36 CDT