Re: How to OPEN RESETLOGS when not recovering?

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!
> ========================================
Received on Tue Mar 28 2000 - 08:26:11 CST