Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<5rvnjvc6j9k1t57ks46kd13k7jh8h2kbnd_at_4ax.com>...
> On 14 Aug 2003 13:49:27 -0700, m_j127_at_hotmail.com wrote:
>
> >Hi again. Please could you help me on the following:
> >
> >BACKUP ARCHIVELOG ALL DELETE ALL INPUT;
> >
> >I know that as a result:
> >
> >a) all the archived redo logs are archived
> >b) once successfully copied, the original archived redo log that was
> >just copied is deleted
> >
> >What I need to know is what happens to the Distinct Log Sequence
> >Number of the archived redo log. Is there any time when this Log
> >Sequence number may be reset due to activity performed by dba
> >personnel? i.e open the database after recovery with resetlogs option
> >
> >Thanks in advance
>
> - The logsequence number is NOT reset during backup archivelog
> - of course is you open the database with resetlogs the log sequence
> number is reset. Oracle does just what you ask it to do.
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Thanks for that clarification Sybrand, Much appreciated
Received on Fri Aug 15 2003 - 08:23:23 CDT
