Re: RMAN BACKUPS

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 14 Aug 2003 23:31:43 +0200
Message-ID: <5rvnjvc6j9k1t57ks46kd13k7jh8h2kbnd@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 Received on Thu Aug 14 2003 - 16:31:43 CDT