| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to OPEN RESETLOGS when not recovering?
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!
> > ========================================
--
 |
 |