System asks for new backup tape every time DB13

[Former Member]

Hi,

As per our backup policy we need to take backup as per following schedule:

Archive log backup twice in a day - 12:00 and 17:00 hrs

Online databse full backup - Monday to Friday at 19:30

Offline database full backup - Saturday at 19:30

Now problem is this when I schedule archive log backup 2nd time at 17:00 hrs in DB13 system asks for next tape but I want to take archive log backup in same tape for a day.

System gives message like below:

Wrong volume PRDA05 found in device /dev/nmt0, expected: PRDA06

Checking label on volume in device /dev/nmt0 failed

Below are the details of our parameter file (initPRD.sap)

volume_archive = (PRDA01, PRDA02, PRDA03, PRDA04, PRDA05,

PRDA06)

1. volumes for brbackup

2. [<volume_name> | (<volume_name_list>) | SCRATCH]

3. no default

volume_backup = (PRDB01, PRDB02, PRDB03, PRDB04, PRDB05,

PRDB06)

Please advise me to achieve the backup plan.

Thanks

Lokendra

[lbreddemann · Accepted solution]

> As per our backup policy we need to take backup as per following schedule:

>

> Archive log backup twice in a day - 12:00 and 17:00 hrs

> Online databse full backup - Monday to Friday at 19:30

> Offline database full backup - Saturday at 19:30

>

> Now problem is this when I schedule archive log backup 2nd time at 17:00 hrs in DB13 system asks for next tape but I want to take archive log backup in same tape for a day.

And precisely that is not supported!

[Volume Management (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))|http://help.sap.com/erp2005_ehp_04/helpdata/EN/fc/e186a3a23d8743abad8a4cc2957e1e/content.htm]

...The tape volumes for the Oracle database are overwritten again at each backup or archive by BRBACKUP or BRARCHIVE. These tools never use the space remaining on the tapes after a backup has finished. New tapes have to be inserted each time you make a backup....

And really: you shouldn't want to do this.

Take the backup to tape and store the tape at a safe location.

Instead you may choose to save a second copy of the archive log files to the second tape to increase data safety.

Regards,

Lars

[Former Member · Accepted solution]

Lars,

Thank you very much for informartion.

Regards

Lokendra

[former_member524429 · Accepted solution]

Hi,

I think If you use Third Party Backup Software (e.g. HP Data Protector, etc, etc,) for Backup Operations, you can have that option of performing Archive Log Backup on the same Tape Media.

I have seen such frequent Archive log backup operations (4 times in a Day) for PRD Server at one of our client , where the same Archive Log Backup is performed on the same Tape Media within a Day , using HP Tape Media Library ML6000.

Some configuration you will have to do at Backup Jobs level at Backup Software side.

Regards,

Bhavik G. Shroff

[Former Member · Accepted solution]

Hi,

You can also do the workaround like. Take the archive log backups on Disk twice a day i.e 12:30 & 17:00. Push these backups in tape after completion 17:00 Hrs backup.

Thanks,

Sachin Sable

[Former Member]

Hi,

Case is solved after doing the changing the parameter VOLUME_ARCHIVE, VOLUME_BACKUP = SCRATCH

Thanks

LK