Database Software

Hi everyone!

Our environment is:

Oracle 10g R2 Bundle patch 34 installed on a Windows Server 2003 Ent SP2

A full online backup is created on every Saturday night (started at 20h) with RMAN (no recovery catalog is used, backup information stored in controlfile).

Backup script for full backup
RUN{
BACKUP AS COMPRESSED BACKUPSET DATABASE FORMAT '<some directory>' FILESPERSET = 1 PLUS ARCHIVELOG;
BACKUP CURRENT CONTROLFILE FORMAT '<some directory>';
BACKUP SPFILE FORMAT '<some directory>';
}

A full archivelog backup is created on every day (except Saturday) at 18h with RMAN.

Backup script for archivelog backup
RUN{
backup as compressed backupset format '<some directory>' archivelog all;
BACKUP CURRENT CONTROLFILE FORMAT '<some directory>';
BACKUP SPFILE FORMAT '<some directory>';
}

The RMAN retention policy configured to 1.

At every Monday the following script has been executed:

run{
allocate channel d1 type disk;
crosscheck backup;
crosscheck archivelog all;
delete obsolete;
}

Every time everything looked good, but yesterday (and today) I have tried to test my backup: I have created an identical system and issued the following commands:

rman target /
startup nomount
run{
allocate channel d1 type disk;
restore controlfile from '<the last controlfile backup from my archivelog backup>';
}

alter database mount;

run{
allocate channel d1 type disk;
restore database;
recover database;
}

and I have got the following message after recover (sorry, hungarian system, if you need, I will try to translate it, but I think the ORA and RMAN numbers are important, not the messages):

Oracle Error:
ORA-01547: figyelmeztetÚs: RECOVER sikerŘlt, de OPEN RESETLOGS az alßbbi hibßt eredmÚnyezheti(k):
ORA-01152: a(z) 1 fßjl nem lett visszat÷ltve egy elÚg rÚgi mentÚsb§l
ORA-01110: adatfßjl 1 : '+EVA6400/umft/datafile/system.860.726798339'

felszabadÝtott csatorna: d1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: hiba a(z) recover parancsban a(z) 08/12/2010 11:57:09 helyen
RMAN-06053: lehetetlen a adathordozˇ-helyreßllÝtßs, mert hißnyzik a naplˇ
RMAN-06025: A visszaßllÝtani kÝvßnt 1 naplˇszßl 123653 seq 7740196040 lowscn biztonsßgi mentÚse nem talßlhatˇ.
***
***
***
RMAN-06025: A visszaßllÝtani kÝvßnt 1 naplˇszßl 123613 seq 7728732643 lowscn biztonsßgi mentÚse nem talßlhatˇ.
MAN-06025: A visszaßllÝtani kÝvßnt 1 naplˇszßl 123612 seq 7728674197 lowscn biztonsß
RMAN>


So I have run the following after this:

crosscheck archivelog from logseq=123612 until logseq=123652;

but it does not find anything. So I have gone to my productive database and checked all archive logs:
crosscheck archivelog all;

I have found the following archive logs: from 123707 to 124513.

So, I have missing archivelogs for a full recovery from 123612 to 123653. These logs have been created approximatly a day ago when my full backup has been taken.

So, what am I doing wrong althrough I have a full backup, every archivelog taken from that fullbackup, and I still needed some logs before the full backup has been taken, and these logs has been deleted by the rman...

Thanks for the answer...

Tamas Taller