Restoration of MaxDB online backup on other server for creating Standby DB

[Former Member]

Hi,

I had taken MaxDB online database backup through Data Protector 6.11. Now i want to restore this backup on other server. So that i can configure this as a standby database. I selected config and data for restoration but it was giving me an error as below,

[Critical] From: OB2BAR_SAPDBBAR@ttcsolma "BE1" Time: 01/11/11 01:19:05

Error: SAPDB responded with: -24988,ERR_SQL: SQL error

-9407,System error: unexpected error

3,Database state: OFFLINE

Internal errorcode, Error code 9050 "disk_not_accessible"

So I created the database but with default values and then tried restoration but getting error as below,

Error: Unable to read the configuration value `All' for SAPDB instance `SID'.

If anybody is having any document or steps for confguring the Standby MaxDB database through Data Protector backup/restore method.

Thanks,

Narendra

[Former Member · Accepted solution]

Hi,

Please check if the DB online backup is complete and valid.

Next you can use the DBM GUI in the MaxDB itself to perform a Recovery with Initialization. This would be the easiest method.

More details: http://maxdb.sap.com/doc/7_6/30/5ada2c596211d4aa83006094b92fad/frameset.htm

Regards,

Srikishan

[Former Member · Accepted solution]

Hi Srikishan,

Thanks for the reply I am having no problem to restore the backup taken on same instance i.e. same server from backup taken. The only problem is when I am trying to recover this backup on other server. But I have created the same instance name with default values on other server and tried restoring the data but then gives an error as below,

Critical From: OB2BAR_SAPDBBAR@ttcsolma "BE1" Time: 01/11/11 01:19:05

Error: SAPDB responded with: -24988,ERR_SQL: SQL error

-9407,System error: unexpected error

3,Database state: OFFLINE

Internal errorcode, Error code 9050 "disk_not_accessible"

But before I start restoration the database is in admin state, but after this above error database goes to offline. I am suspecting that why this database goes to offline state when I start the restoration if it wonu2019t goes offline I guess restoration will start.

Please also let me know whether I need to copy the /sapdb/data and /sapdb/programs folder from source system to destination system. So that restoration can happen? I had also checked disk is accessible and have write permission.

I am looking to configure the other system as standby database from restoring the primary maxdb online database through data protector 6.11.

Thanks,

Narendra

[Former Member · Accepted solution]

Hi Narendra,

Could you check the KnlMsg file for errors? It usually gives info if there was any problem while loading/creating the data and log volume file.

There could be many reasons for the disk_not_accessible error.

- Not enough space on disk

- Antivirus software block the disk access sometimes especially Sophos

- Wrong permissions for user and group for the data and log volume files

and more.

Also, you would need to instal Maxdb afresh on the target host. No need to copy /sapdb from the source server.

Regards,

Srikishan

[Former Member · Accepted solution]

Hi Srikishan,

I have installed fresh MaxDB on target system. But before restoration need to create empty/blank database. So I created the blank database with default parameter values. Why I was saying copying /sapdb/data and /sapdb/programs directory from the source server to target server because I am able to restore the maxdb backup on source server. So I thought if I copy those files could have some system information which will help to restore on target server.

I tried restoring through MaxDB Database Manager GUI but I am getting different error as below,

-24920 backup operation was unsuccessful [db_activate RECOVER "BACKDB-Data[8]" The database was unable to fulfill a request (-9407,System error: unexpected error).

Thanks,

Narendra

[Former Member]

Hi Narendra,

You can also try by increasing the value of the SAP DB/MaxDB MAXBACKUPDEVS parameter to a value that is greater than or equal to the value of the Data Protector Parallelism option, or reduce the value of the Data Protector parallelism option.

Please try and let me know the results.

Thanks.

Regards,

Siva.

[Former Member]

Hi Srikishan,

Thanks for the reply and sap noteu2026I followed the sap note and found that on the target server which I am trying to restore is not able to find the status as available it is showing as below,

./dbmcli on BE1>backup_ext_ids_list

OK

END

UNAVAILABLE|BE1 1101106:1 /var/opt/omni/tmp/BE1.BACKDP-Data[8].1|DATA MIGRATION|2011-01-10 02:22:52|

UNAVAILABLE|BE1 1101106:2 /var/opt/omni/tmp/BE1.BACKDP-Data[8].2|DATA MIGRATION|2011-01-10 02:22:52|

UNAVAILABLE|BE1 1101106:3 /var/opt/omni/tmp/BE1.BACKDP-Data[8].3|DATA MIGRATION|2011-01-10 02:22:52|

UNAVAILABLE|BE1 1101106:4 /var/opt/omni/tmp/BE1.BACKDP-Data[8].4|DATA MIGRATION|2011-01-10 02:22:52|

UNAVAILABLE|BE1 1101106:5 /var/opt/omni/tmp/BE1.BACKDP-Data[8].5|DATA MIGRATION|2011-01-10 02:22:52|

UNAVAILABLE|BE1 1101106:6 /var/opt/omni/tmp/BE1.BACKDP-Data[8].6|DATA MIGRATION|2011-01-10 02:22:52|

UNAVAILABLE|BE1 1101106:7 /var/opt/omni/tmp/BE1.BACKDP-Data[8].7|DATA MIGRATION|2011-01-10 02:22:52|

UNAVAILABLE|BE1 1101106:8 /var/opt/omni/tmp/BE1.BACKDP-Data[8].8|DATA MIGRATION|2011-01-10 02:22:52|

But when I check the status on the source server from which I have taken backup it is showing available as below,

./dbmcli on BE1>backup_ext_ids_list

OK

END

AVAILABLE|BE1 1101106:1 /var/opt/omni/tmp/BE1.BACKDP-Data[8].1|DATA MIGRATION|2011-01-10 02:22:52|

AVAILABLE|BE1 1101106:2 /var/opt/omni/tmp/BE1.BACKDP-Data[8].2|DATA MIGRATION|2011-01-10 02:22:52|

AVAILABLE|BE1 1101106:3 /var/opt/omni/tmp/BE1.BACKDP-Data[8].3|DATA MIGRATION|2011-01-10 02:22:52|

AVAILABLE|BE1 1101106:4 /var/opt/omni/tmp/BE1.BACKDP-Data[8].4|DATA MIGRATION|2011-01-10 02:22:52|

AVAILABLE|BE1 1101106:5 /var/opt/omni/tmp/BE1.BACKDP-Data[8].5|DATA MIGRATION|2011-01-10 02:22:52|

AVAILABLE|BE1 1101106:6 /var/opt/omni/tmp/BE1.BACKDP-Data[8].6|DATA MIGRATION|2011-01-10 02:22:52|

AVAILABLE|BE1 1101106:7 /var/opt/omni/tmp/BE1.BACKDP-Data[8].7|DATA MIGRATION|2011-01-10 02:22:52|

AVAILABLE|BE1 1101106:8 /var/opt/omni/tmp/BE1.BACKDP-Data[8].8|DATA MIGRATION|2011-01-10 02:22:52|

I also copied the dbm.ebf, dbm.mdf, dbm.knl & dbm.ebp files from the source server to target server but the status is same UNAVAILABLE.

And also I am not able to take a backup from DBM GUI calling the external backup Data Protector I started the backup from DBM GUI getting error as below, I created the pipe for external backup tool but same problem.

-24920 backup operation was unsuccessful [backup_save "BACKDP-Data[8]" DATA RECOVERY]; The backup tool failed with 2 as sum of exit codes. The database request was canceled and ended with error -903

But I am able to take backup through data protector GUI. I want to know how DBM GUI will come to know about the data protector backup specification as it is not creating the backup sessions in data protector. And data protector backup parameters are available in /var/opt/omni/tmp/ BE1.bsi_env

maxdbdr:[/var/opt/omni/tmp]# cat BE1.bsi_env

BACKINT "/opt/omni/lbin/sapdb_backint"

INPUT /var/opt/omni/tmp/BE1.bsi_in

OUTPUT /var/opt/omni/tmp/BE1.bsi_out

ERROROUTPUT /var/opt/omni/tmp/BE1.bsi_err

PARAMETERFILE SAPDB.28191.1295326588.par

TIMEOUT_SUCCESS 900

TIMEOUT_FAILURE 30

And also I am getting error while applying logs to standby database as below,

./dbmcli on BE1>recover_start Log /sapdb/BE1/sapdata5/saparch/BE1_LOG.002

ERR

-24988,ERR_SQL: SQL error

-903,Host file I/O error

k38headmaster, Error code 3700 "hostfile_error"

RestoreLog, Error code 3700 "hostfile_error"

Thanks,

Narendra

[Former Member]

Hi Narendra,

Is the problem resolved?

Just wanted to confirm whether you have copied the dbm.ebf, dbm.mdf dbm.knl files from the source server to target server.

Is the backup files visible in the target server? You may also consider using the "recovery with initialization" option from DBM GUI.

Have you created the Data / LOg volumes as equal to the source server?

Thanks.

Regards,

Siva.

[Former Member]

Hi Siva,

Thanks for the replyu2026Yes I had copied the dbm.ebf, dbm.mdf dbm.knl files from the source server to target server. And also backup is visible in target server. And also I created Data /Log volumes size as equal to source server.

I tried restoring through DBM GUI with "recovery with initialization" option but I am getting error message as below and also I am getting same error message when I restore from Data Protector GUI. But I donu2019t have any problem restoring the backup on same server the problem occurs only when restoring it on target server.

Now for testing I have taken backup on file system through DBM GUI of source system and started restoring on target system. No problem while restoring from file system backup on target server. I am suspecting there is some problem with PIPE as I am using third party backup tool i.e. DP 6.11. I want to resolve the problem with third party backup tool as we will take all MaxDB database backup on tapes through DP 6.11.

Through DBM GUI error message:

Error: SAPDB responded with: -24925,ERR_PREPARE: preparation of backup operation failed

The list of external backup ID's contains less than 16 ID's.

Through Data Protector GUI error message:

[Normal] From: RSM@bkupsvr "" Time: 1/18/11 8:49:16 AM

Restore session 2011/01/18-12 started.

[Normal] From: OB2BAR_SAPDBBAR@tstmaxdb "SID" Time: 01/18/11 08:50:58

Executing the dbmcli command: `user_logon'.

[Normal] From: OB2BAR_SAPDBBAR@tstmaxdb "SID" Time: 01/18/11 08:51:00

Executing the dbmcli command: `dbm_configset -raw BSI_ENV /var/opt/omni/tmp/SID.bsi_env'.

[Normal] From: OB2BAR_SAPDBBAR@tstmaxdb "SID" Time: 01/18/11 08:51:03

Executing the dbmcli command: `db_admin'.

[Normal] From: OB2BAR_SAPDBBAR@tstmaxdb "SID" Time: 01/18/11 08:51:03

Executing the dbmcli command: `util_execute clear log'.

[Normal] From: OB2BAR_SAPDBBAR@tstmaxdb "SID" Time: 01/18/11 08:51:22

Executing the dbmcli command: `dbm_configset -raw set_variable_10 OB2BACKUPAPPNAME=SID'.

[Normal] From: OB2BAR_SAPDBBAR@tstmaxdb "SID" Time: 01/18/11 08:51:22

Executing the dbmcli command: `dbm_configset -raw set_variable_11 OB2BACKUPHOSTNAME=ttcmaxdr'.

[Normal] From: OB2BAR_SAPDBBAR@tstmaxdb "SID" Time: 01/18/11 08:51:23

Executing the dbmcli command: `util_connect'.

[Normal] From: OB2BAR_SAPDBBAR@tstmaxdb "SID" Time: 01/18/11 08:51:24

Restoring backup 2011/01/17 0061.

[Normal] From: OB2BAR_SAPDBBAR@tstmaxdb "SID" Time: 01/18/11 08:51:24

Executing the dbmcli command: `medium_put BACKDP-Data[8]/1 /var/opt/omni/tmp/SID.BACKDP-Data[8].1 PIPE DATA 0 8 NO NO \"\" BACK'.

[Normal] From: OB2BAR_SAPDBBAR@tstmaxdb "SID" Time: 01/18/11 08:51:24

Executing the dbmcli command: `medium_put BACKDP-Data[8]/2 /var/opt/omni/tmp/SID.BACKDP-Data[8].2 PIPE DATA 0 8 NO NO \"\" BACK'.

[Normal] From: OB2BAR_SAPDBBAR@tstmaxdb "SID" Time: 01/18/11 08:51:25

Executing the dbmcli command: `medium_put BACKDP-Data[8]/3 /var/opt/omni/tmp/SID.BACKDP-Data[8].3 PIPE DATA 0 8 NO NO \"\" BACK'.

[Normal] From: OB2BAR_SAPDBBAR@tstmaxdb "SID" Time: 01/18/11 08:51:25

Executing the dbmcli command: `medium_put BACKDP-Data[8]/4 /var/opt/omni/tmp/SID.BACKDP-Data[8].4 PIPE DATA 0 8 NO NO \"\" BACK'.

[Normal] From: OB2BAR_SAPDBBAR@tstmaxdb "SID" Time: 01/18/11 08:51:26

Executing the dbmcli command: `medium_put BACKDP-Data[8]/5 /var/opt/omni/tmp/SID.BACKDP-Data[8].5 PIPE DATA 0 8 NO NO \"\" BACK'.

[Normal] From: OB2BAR_SAPDBBAR@tstmaxdb "SID" Time: 01/18/11 08:51:27

Executing the dbmcli command: `medium_put BACKDP-Data[8]/6 /var/opt/omni/tmp/SID.BACKDP-Data[8].6 PIPE DATA 0 8 NO NO \"\" BACK'.

[Normal] From: OB2BAR_SAPDBBAR@tstmaxdb "SID" Time: 01/18/11 08:51:27

Executing the dbmcli command: `medium_put BACKDP-Data[8]/7 /var/opt/omni/tmp/SID.BACKDP-Data[8].7 PIPE DATA 0 8 NO NO \"\" BACK'.

[Normal] From: OB2BAR_SAPDBBAR@tstmaxdb "SID" Time: 01/18/11 08:51:28

Executing the dbmcli command: `medium_put BACKDP-Data[8]/8 /var/opt/omni/tmp/SID.BACKDP-Data[8].8 PIPE DATA 0 8 NO NO \"\" BACK'.

[Normal] From: OB2BAR_SAPDBBAR@tstmaxdb "SID" Time: 01/18/11 08:51:28

Executing the dbmcli command: `recover_start BACKDP-Data[8] DATA ExternalBackupID "SID 11011761:1 Stream,SID 11011761:2 Stream,SID 11011761:3 Stream,SID 11011761:4 Stream,SID 11011761:5 Stream,SID 11011761:6 Stream,SID 11011761:7 Stream,SID 11011761:8 Stream"'.

[Critical] From: OB2BAR_SAPDBBAR@tstmaxdb "SID" Time: 01/18/11 08:51:30

Error: SAPDB responded with: -24925,ERR_PREPARE: preparation of backup operation failed

The list of external backup ID's contains less than 16 ID's.

.

[Normal] From: OB2BAR_SAPDBBAR@tstmaxdb "SID" Time: 01/18/11 08:51:30

Executing the dbmcli command: `exit'.

[Normal] From: RSM@bkupsvr "" Time: 1/18/11 8:49:59 AM

OB2BAR application on "tstmaxdb" disconnected.

Thanks,

Narendra

[Former Member]

Hi Narendra,

It looks like the problem exists while retrieving the backup ID for restore.

Usually the dbm.ebp file will have the restoration commands while performing the restore. Please check if the correct external backup identifier is being used. Note 387583 could be more helpful.

Regards,

Srikishan