maxdb backup incrementale

[Former Member]

hello

i ve tried to make backup incremental on maxdb 7.7.07 database and it fails i use

medium_put inc /home1/SAPDB/sapdb_backup/KRLIVE/inc FILE PAGES

db_admin

db_connect

backup_start inc

the backup finish with success but the restore print me -111 error incompatible medium and when i disable the logging the restore finish with success and nothing happen.

[Former Member · Accepted solution]

HELLO

its fine i read the maxdb tutorials i missed the role of LOG files and what i understand that when i want to make recover_start complet i have to recover the log also and then i recover the incremental.

i did not test the case where the log is automatic the recover_start complete ..recover_start inc work or not

thank you any way if you have any information about migrating database instance from 7.6 to 7.7 please show me a link i use

./SDBUPD -d KRLIVE -u dba,dba -o sdb -g sdba

and it doesnot work because KRLIVE its ascii and he tells me that ASCII catalog not allowed. Please perform the unicode migration of the database catalog first

thank

[former_member229109 · Accepted solution]

Hello,

1.

You recovery the databackup, then incremental databackup and continue the recovery of the log backups if itu2019s needed.

More details see in the MAXDB library.

Some variations could be dependent on the disaster situation with your database.

2.

See the documents in SAP MaxDB Library

http://maxdb.sap.com/doc/7_6/default.htm

a) You have migrated the database catalog to UNICODE before to run the upgrade to 7.7 version.

b) Use the dbm command db_migratecatalog to migrate the database version 7.6 catalog to UNICODE.

c) Create the complete databackup first, then bring the database to offline, connect as dbm user &

run dbm command db_migratecatalog. Wait until it will be finished!

A migrate the database catalog to UNICODE before to run the upgrade to 7.7 version topic was also discussed in the forum in the past.

3.

If you have another MAXDB issue/questions, which are not related to this thread,

I recommend to post then in new thread & close this one.

Thank you and best regards, Natalia Khlopina

[Former Member]

hello,

the error it appears when i make recover_start complete and the i make recover_start inc like this :

db_admin

db_connect

recover_start complete

recover_start inc

finish with success

the problem with the restoring of inc is log incompatible, i dont use log or autolog the log is set off

for that i used db_activate recover complete and it works and i have succeeded to restore the inc i dont know why recover_start complete create problem for the incremental restore in this case

please i need a script to create and restore complete backup for maxdb 7.7

thanks

[former_member229109]

Hello,

1.

If you are not planning to run the recovery of the log backups after you finish with the recovery of the incremental backups,

Then run dbm commands:

db_admin

db_connect

db_activate RECOVER complete DATA

recover_start inc

...

2.

You could create the backup templates when you run the database recovery with initialization using DBMGUI or Database Studio.

3.

Did you review the recommended document u201CRestoring Databasesu201D in MAXDB library?

Regards, Natalia Khlopina

[Former Member]

hello thank you for the attention, ok i have 7.6 database from the first and then i upgrade to 7.7 using SAP 7.7 i download it from the website and then i unpack it ..

./SDBUPD u2013d KRLIVE -u dba,dba -o sdb -g sdba

so my database running now with 7.7 kern version. my backup plan is one full backup every weekend and the other days incremental backup so i tested the incrementale backup using those commands :

i run an incremental backup

medium_put inc /home1/SAPDB/sapdb_backup/KRLIVE/inc FILE PAGES

db_connect

backup_start inc

from the first it doesnt work only when i stop the logging

then

i run a complete restore

db_admin

db_connect

recover_start complete

db_online

db_connect

recover_start inc

i have tried to make an incremental backup script you can take a look

#!/bin/sh

SAPDB_HOME=/opt/sdb
DBROOT=${SAPDB_HOME}/programs
SAPDBROOT=${DBROOT}

# For the server
PATH=${PATH}:${SAPDBROOT}/bin

# For the clients
PATH=${PATH}:${SAPDB_HOME}/programs/bin


DBM_USER=dbm
DBM_PASSWD=dbm

DBA_USER=dba
DBA_PASSWD=dba

ADMIN_USER=admin
ADMIN_PASSWD=admin

# path to database files
SAPDB_DATA=/home2/SAPDB/sapdb_data
SAPDB_LOG=/home1/SAPDB/sapdb_log
SAPDB_BACKUP=/home1/SAPDB/sapdb_backup


# Backup a database instance.

export PATH=/opt/sdb/programs/bin:${PATH}

test -z "$1" && {
    echo "Usage: `basename $0` <dbname> [host]"
    echo
    echo "Defaults:     host            localhost"
    exit
}

# name of the database
DB_NAME=$1

# host of the database
DB_HOST=${2:-localhost}

if [ !  -f ${SAPDB_BACKUP}/${DB_NAME}/inc.log ]; then
MEDIUM="0"
echo "0" > ${SAPDB_BACKUP}/${DB_NAME}/inc.log
else
MEDIUM=$(sort -n ${SAPDB_BACKUP}/${DB_NAME}/inc.log | tail -n 1)
MEDIUM=$((MEDIUM + 1))
echo ${MEDIUM} >> ${SAPDB_BACKUP}/${DB_NAME}/inc.log
fi
echo "create medium ${MEDIUM} for backup ..."

_o=`dbmcli  -uUTL -n ${DB_HOST} -d ${DB_NAME} -u ${DBA_USER},${DBA_PASSWD} medium_put incremental.${MEDIUM} ${SAPDB_BACKUP}/${DB_NAME}/incremental.${MEDIUM} FILE PAGES   2>&1`
_test=`echo ${_o} | grep OK`
if [ -z "${_test}" ]; then
        echo "creating medium ${MEDIUM} failed: ${_o}"
        exit 1
else
        echo "OK"
fi
exit 0

i'd like to have a script for backup and other for restore

thank you

[former_member229109]

Hello,

1. It's not clear what error did you get when you start the inc databackup.

2. Don't start the database to online after you run the recovery of the complete databackup in admin mode.

Run dbm commands:

db_admin

db_connect

recover_start complete

recover_start inc

...

3. You could create the backup templates when you run the database backup using DBMGUI or Database Studio.

Regards, NK

[former_member229109]

Hello,

Database error:: -111: Incompatible incremental backup

Explanation:

The database version to be loaded is not the follow-up version of the

current database state.

User Action:

Choose the correct database version.

MAXDB library at http://maxdb.sap.com/doc/7_7/default.htm

->Database Administration

->Restoring Databases

< review this document >

-> Section u201CProcedureu201D:

Database Manager CLI Tutorial, Evaluating the Restart Information and Backup History for Importing Backups

****

Please update with additional information:

Did you run the restore of the complete databackup before to restore the incremental databackup?

What are you planning to reach in your backup/restore scenario?

Thank you and best regards, Natalia Khlopina

PS: You could register for session u201C2010-08-03, 7:00 PM CET - SAP MaxDB: Backup & Recoveryu201D

At http://www.sdn.sap.com/irj/sdn/maxdb ->

u201CREGISTER NOW FOR NEXT ROUND OF SAP MAXDB ONLINE TRAINING SESSIONSu201D

Edited by: Natalia Khlopina on Jul 26, 2010 11:24 AM