Brtools can't find last full backup after deleting older ones

[wolfgang_ullmann]

Hello,

excuse my bad english.

We are using brtools 7.20 (12) on an Solaris (with Zones) environment.

Every Sunday a fullbackup is planed, an incremental one the rest of the week.

We do store on disk. If I delete older fullbackups via brtools, i get an error message after the next planed incremental backup :""Last full database backup (level 0) not found"

Although the newest Fullbackup still exists.

I checked it via dbacockpit and in the logs of the machine. The actual Fullbackup is on disk.

the detail log for the incremental Backup

BR0051I BRBACKUP 7.20 (12)

BR0169I Value 'rman_set' of parameter/option 'disk_copy_cmd' ignored for 'backup_mode/-m incr' - 'rman' assumed

BR0055I Start of database backup: begskose.ind 2011-09-07 04.30.24

BR0484I BRBACKUP log file: /oracle/PE1/sapbackup/begskose.ind

BR0477I Oracle pfile /oracle/PE1/102_64/dbs/initPE1.ora created from spfile /oracle/PE1/102_64/dbs/spfilePE1.ora

BR0515E Last full database backup (level 0) not found

BR0520I Please start a full database backup (level 0) first

BR0314E Collection of information on database files failed

BR0056I End of database backup: begskose.ind 2011-09-07 04.30.29

BR0280I BRBACKUP time stamp: 2011-09-07 04.30.29

BR0054I BRBACKUP terminated with errors

BR0280I BRBACKUP time stamp: 2011-09-07 04.30.29

BR0291I BRARCHIVE will be started with options '+begskose.ind -U -jid INLOG20110824043000 -c force -p initPE1.sap -s'

BR0280I BRBACKUP time stamp: 2011-09-07 04.33.10

BR0292I Execution of BRARCHIVE finished with return code 0

Maybe someone had the same problem and could help me?

Thanks a lot.

[JPReyes]

If I delete older fullbackups via brtools, i get an error message after the next planed incremental backup :""Last full database backup (level 0) not found" 

Have you tried deleting the backup manually and leaving the .afd file in the sapbackup directory?...

Regards

Juan

[wolfgang_ullmann]

Hello,

i allways delete it with the brtools. But i have a ffd file not an afd. I Thought incremental backups need a ffd Backup?

The latest backup ffd is still there, just checked it.

I'll try to delete it manually by tomorrow, after the next full backup.

[wolfgang_ullmann]

I've tried to delete the backup manually , works just fine.

But i just can't find the mistake when i am using Brtools fot the deletion of older Backups.

Edited by: Wolfgang Ullmann on Sep 9, 2011 7:31 AM

[Former Member]

In sapbackup directory there will also be a file back<SID>.log

Is this file by any chance deleted by Brtools?.

[wolfgang_ullmann]

The file backSID.log is still there.

[wolfgang_ullmann]

-

Edited by: Wolfgang Ullmann on Sep 13, 2011 12:21 PM

[Former Member]

Here I think brbackup is not able to find the last backup status because you might be moved and replaced the latest one and tried for incremental backup.

Just re-execute a full DB backup and then try for incremental, update the status then.

*Just search SDN/Google with the error to find the bug fix (if) before starting a full DB backup

Regards,

Nick Loy

[wolfgang_ullmann]

Thanks for the quick answer,

i've already done that before. If I reexecute a new full Backup and start a incrementel one afterwards everything is fine.

But i don't understand why brtools isn't able to find the last one. Do i need to configure anything else?

I need to find a way deleting old full Backups without running into that error message.

We don't store the older backups on tape only on disk.

I've already search for that error message but i could not find an answer.