MaxDB going offline after log recover

[Former Member]

Hello,

I've got a problem with my standby instance. I would like to import data into standby instance from autolog files generated by master instance. I am trying to use dbmcli tool + its utility session.

My problem is, that after data recovery my database instance going offline. Is it normal behavior of MaxDB 7.5?

[former_member229109]

Hello Konrad ,

Please update with additional information:

-> What are the versions of the source & target database instances?

-> Please update with outputs of the following commands:

dbmcli -s db_enum

Dbmcli -s inst_enum

-> Are you SAP customer?

-> "My problem is, that after data recovery my database instance going offline. Is it normal behavior of MaxDB 7.5?"

I think that there are some problems with the procedure steps you was running…

Please update with your script or dbmcli commands you was executed.

Please check the errors in knldiag file in the target database Rundirectory.

->Did you try?

Create the databackup medium DataCompl_recover pointed to the databackup of the source database.

Transfer the database instance to the ADMIN operational state:

Dbmcli -d <TargetDB> -u <DBM>,<dbm>

dbmcli on <TargetDB> >db_admin

OK

dbmcli on <TargetDB> >db_connect

OK

<Import the complete data backup from source to <TargetDB> (initializing <TargetDB> using the

backup medium DataCompl_recover created for <TargetDB> >

dbmcli on <TargetDB> >db_activate RECOVER DataCompl_recover

…

dbmcli on <TargetDB> >db_state

…

**********

Please review the documetation with examples at

< "Replication and High Availability" -> Standby Database ::

http://maxdb.sap.com/currentdoc/72/7ed43fb9490c65e10000000a114b1d/content.htm

db_activate ::

http://maxdb.sap.com/currentdoc/91/1a74d35cad11d4aa1500a0c9430730/content.htm

db_activate RECOVER ::

http://maxdb.sap.com/currentdoc/2f/40d93fac0fec06e10000000a1550b0/content.htm >

• If you are using DBMGUI tool, please update the DBMGUI as pro SAP note 386714.

• If you are using dbmcli tool, please review information at link:

http://maxdb.sap.com/currentdoc/87/dba841c0dae234e10000000a1550b0/content.htm

>

Thank you and best regards, Natalia Khlopina