Re: How to OPEN RESETLOGS when not recovering?

Ok, it makes no much sense doing resetlogs without real recovery (joust for re-set redo sequence to 1) however it helps to open a database in case all database online redo logs are lost or corrupted.

Eugene.

Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote in message news:38E20C3F.C5A2C1BD_at_edcmail.cr.usgs.gov...
> Eugene,
>
> I'm still not sure why one wants to reset the archive redo sequence
> in this case. I'm very familiar with the RESETLOGS concept. But what I
> haven't seen is a good reason to open the database with RESETLOGS
> without having performed recovery first. If you've just done a cold
> backup, why open with RESETLOGS? What does resetting the archive redo
> sequence have to do with opening a database after a cold backup? To me,
> it seems like an unnecessary step. Is there some reason that I'm
> missing?
>
> Thanks,
> Brian
>
>
> Eugene Firyago wrote:
> >
> > You can make offline backup of a database running in archivelog mode if
you
> > brought it down normally. It works for recovery as any online backup set
> > does (to apply redo). Sometimes that trick with RESETLOGS is used to
re-set
> > archive redo sequence to 1.
> >
> > Eugene.
> >
> > Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote in message
> > news:38E0BD4A.767EDC87_at_edcmail.cr.usgs.gov...
> > > Why do you want to do this? I'm not sure what you meant by "whack all
> > > the archived redo information". After a cold backup, the old archived
> > > redo logs are no longer necessary. You do not need to tell the Oracle
db
> > > anything about this. During recovery, you restore from your full
backup
> > > and then apply only those redo logs since that backup. Can you explain
> > > why you want to open the database with RESETLOGS?
> > >
> > > Thanks,
> > > Brian
> > >
> > >
> > > argosy22_at_my-deja.com wrote:
> > > >
> > > > Hi all,
> > > >
> > > > We are using Oracle 7.3.4.
> > > >
> > > > I shutdown the database and did a full backup
> > > > of all the files.
> > > >
> > > > I wanted to OPEN RESETLOGS and whack all the
> > > > archived redo information.
> > > >
> > > > In svrmgrl, I did:
> > > >
> > > > connect internal
> > > > alter database open resetlogs
> > > >
> > > > but got the error:
> > > > ORA-01139: RESETLOGS option only valid after an incomplete database
> > > > recovery
> > > >
> > > > Trying the command:
> > > > alter database recover database
> > > >
> > > > gave:
> > > >
> > > > ORA-00283: Recovery session canceled due to errors
> > > > ORA-00264: no recovery required
> > > >
> > > > What do I need to do, to reset the archiving to the beginning?
> > > >
> > > > Thanks,
> > > >
> > > > Argosy
> > > >
> > > > Sent via Deja.com http://www.deja.com/
> > > > Before you buy.
> > >
> > > --
> > > ========================================
> > > Brian Peasland
> > > Raytheons Systems at
> > > USGS EROS Data Center
> > > These opinions are my own and do not
> > > necessarily reflect the opinions of my
> > > company!
> > > ========================================
>
> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================
Received on Wed Mar 29 2000 - 10:28:57 CST