104,DBM command impossible at this time

[Former Member]

Hi,

I try to recover from a Full and an incremental backup an d I receive : 104,DBM command impossible at this time

dbmcli.exe on MAXDB4>db_activate RECOVER DemoDataCompl_recover
OK
Returncode              0
Date                    20111107
Time                    00133125
Server                  optim65-win.com
Database                MAXDB2
Kernel Version          Kernel    7.6.06   Build 010-123-229-880
Pages Transferred       618
Pages Left              0
Volumes                 1
Medianame               DemoDataCompl_recover
Location                E:\sdb\data\wrk\MAXDB2\completeDataJan
Errortext
Label                   DAT_000000004
Is Consistent           true
First LOG Page          30536
Last LOG Page
DB Stamp 1 Date         20111104
DB Stamp 1 Time         00094855
DB Stamp 2 Date
DB Stamp 2 Time
Page Count              606
Devices Used            1
Database ID             optim65-win.com:MAXDB2_20111104_094855
Max Used Data Page      0
Converter Page Count    8
 
---
dbmcli.exe on MAXDB4>RECOVER_replace DemoDataINC_RECOVER
ERR
-24988,ERR_SQL: SQL error
-104,DBM command impossible at this time

Thank for help.

[markus_doehr2]

> dbmcli.exe on MAXDB4>RECOVER_replace DemoDataINC_RECOVER

> ERR

> -24988,ERR_SQL: SQL error

> -104,DBM command impossible at this time

try

recover_start DemoDataINC_RECOVER

Markus

[Former Member]

yes Markus, it worked fine.Thank you.

Thanks to all.

[Former Member]

Hi,

You can execute recover_replace, when the recovery starts with recover_start command.

Read the document for the detailed information, below;

http://maxdb.sap.com/doc/7_7/44/ed5673c85b67d6e10000000a155369/content.htm

To perform recovery, follow the steps, below;

dbmcli -d <DBSID> -u <DBM>,<PASS>

db_admin

db_connect

recover_start <FullBackup> DATA

recover_start <LogBackup> LOG 001

recover_replace <LogBackup> LOG 002

You can check the article, below;

http://wiki.sdn.sap.com/wiki/display/MaxDB/HowTo-StandbyDBlog+shipping

Best regards,

Orkun Gedik

[markus_doehr2]

> dbmcli -d <DBSID> -u <DBM>,<PASS>

> db_admin

> db_connect

> recover_start <FullBackup> DATA

> recover_start <LogBackup> LOG 001

> recover_replace <LogBackup> LOG 002

If this is done then the log is not formatted an the database will not start. A database recover on an existing database should be started with dbactivate_recover.

Markus