Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: database recovery HELP
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 - 12:02:01 CDT