Re: database recovery HELP

You *have* to use the resetlogs, it *will* reset the log sequence number, and that's why you need to *restore* the database *a second time*, in order to perform recovery until 'now'

Hth,

Sybrand Bakker, Oracle DBA

"Steve" <schen_at_prodigy.net> wrote in message news:9ee5re$850g$1_at_newssvr06-en0.news.prodigy.com...
> Sybrand ,
>
> That's exactly what my question is: can I do it, after 1st time using
> resetlog, meaning log sequence will be changed? In this case, would 2nd
> recovery work? What command for 2nd recovery?
>
> Thanks a million.
>
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:tgl5udg1m39udd_at_beta-news.demon.nl...
> >
> > "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 - 14:25:00 CDT