howto tell RMAN to start from one archive log number

[domi...@gmail.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

[Ronald Rood]

On Wed, 21 Sep 2005 02:16:24 +0200, domi...@gmail.com wrote
(in article <1127261784....@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).

change archivelog all crosscheck;

With kind regards / met vriendelijke groeten,
Ronald

http://ciber.nl
http://homepage.mac.com/ik_zelf/oracle

[domi...@gmail.com]

Hi Ronald,

thank you ,
let me give it a try.

Dominica

[domi...@gmail.com]

Thanks a lot , it
is working.

I just tested the backup.

Dominica