howto tell RMAN to start from one archive log number

From: <dominica_at_gmail.com>
Date: 20 Sep 2005 17:16:24 -0700
Message-ID: <1127261784.949907.29100@g47g2000cwa.googlegroups.com>

Hi All,

I am running oracle 8.1.7.4 (32 bits oracle) on solaris 5.9 OS.

I am trying to use RMAN script (this script work in other machine, it has been doing backup every day in other production machine,which is working).

But there is a small instance (SS) which is running archive log mode, but never been backed-up by RMAN before.(I used to just use hotbackup).

I have a problem now. I got this error from RMAN:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command

RMAN-03013: command type: backup
RMAN-06089: archived log
/scard/s00/oradata/SCARD/arch/arch_1_0000064103.log not found or out of sync with catalog
(it fail in backing up the archive log part).

Basically, this 64103 is an archive log from april,21. Which has been deleted.

How could I tell "RMAN to start from one particular archive log number"??

I am not using catalog database, just using controlfile for RMAN's information. (RMAN's info stored in controlfile.)

Script is like this:

RUN {
#
# Backup all data files. Cycle the redo logs before and after the
# database backup.
#

ALLOCATE CHANNEL ch0 TYPE DISK;
SQL 'alter system archive log current';
BACKUP
    INCREMENTAL LEVEL=${rmanBackupLevel}     SKIP INACCESSIBLE
    SKIP OFFLINE
    TAG db_${ORACLE_SID}_bk_level_${rmanBackupLevel}     FILESPERSET 1
    FORMAT '${rmanBackupDataDir}/${ORACLE_SID}_bk_%t_%s_%p_%c'     DATABASE;
SQL 'alter system archive log current';
RELEASE CHANNEL ch0;
#
# Backup and delete all archived redo logs. We want these critical
# archive logs to be recorded in the control file in case we
# need to restore entirely from tape.
#

ALLOCATE CHANNEL ch0 TYPE DISK;
BACKUP
    FILESPERSET 10
    FORMAT '${rmanBackupArchDir}/${ORACLE_SID}_al_%t_%s_%p_%c'     ARCHIVELOG ALL
    DELETE INPUT
    ;
RELEASE CHANNEL ch0;

... and so on.

Any idea/suggestion.
I am still learning RMAN (not that good at it).

Thank you,

Dominica Received on Tue Sep 20 2005 - 19:16:24 CDT