Backup online Full overwrite label

[Former Member]

Hallo everybody.

we have a problem, cause we make everyday a backup of Maxdb directly on a Media.

We schedule it by using DB13, und the command in log file is for example:

22.10.2007 14:42:07

parameters:-d <SID> -n <server> -uUTL -tpi SID -tpp no_longer_used -tpc SID backup_start SAVE_TAPE RECOVERY DATA

and this is a log example:

• DBA Action starts:

Timestamp: 20071022144208 Function: sda Object: DATA

• SAVE/RESTORE request:

SAVE DATA QUICK TO '
.\Tape0' TAPE BLOCKSIZE 8 NO CHECKPOINT MEDIANAME 'SAVE_TAPE'

• SAVE/RESTORE request accepted:

OK

• SAVE/RESTORE result:

OK

Returncode 0

Date 20071022

Time 00144218

Server <server>

Database <SID>

Kernel Version Kernel 7.6.00 Build 035-123-139-084

Pages Transferred 2109056

Pages Left 0

Volumes 1

Medianame SAVE_TAPE

Location
.\Tape0

Errortext

Label DAT_000000002

Is Consistent true

First LOG Page 494470

Last LOG Page

DB Stamp 1 Date 20071022

DB Stamp 1 Time 00144211

DB Stamp 2 Date

DB Stamp 2 Time

Page Count 2109025

Devices Used 1

Database ID <server>:<SID>_20071022_144218

Max Used Data Page 0

Converter Page Count 1137

• DBA Action ends:

Timestamp: 20071022144845 State: Success

What i see in the check database diagnosis file, in the file Database Manager Media, is:

[SAVE_TAPE]

LOCATION=
.\Tape0

TYPE=TAPE

SAVETYPE=DATA

SIZE=0

BLOCKSIZE=8

<b>OVERWRITE=NO</b>

AUTOLOADER=NO

OSCOMMAND=

BACKUPTOOL=NONE

CREATED=20071018182427

MODIFIED=20071018182427

We would like that the backup can overwrite itselfs on Media SAVE_TAPE.

Have anybody ideas?

Thank you

Best Regards

Alberto D.F.

[Melanie · Accepted solution]

Hello Alberto,

the overwrite option of the media definition is not relevant if you create a backup on a tape. That means, even if the overwrite option is set to NO, an already existing backup is overwritten. This option is only checked for backups in files.

If you make sure that the tape is rewound after the backup, the next backup will overwrite the existing backup.

However, we strongly recommend to change the tapes after a backup and to keep a history of several complete backups before you start overwriting them. Otherwise you won't be able to recover your database in case of a tape error!

Kind regards,

Melanie Handreck

[Former Member]

ok.

Thank you!

Alberto