Getting error while bringing standby MaxDB to online mode.

[Former Member]

Hi,

I am getting error as below while bringing standby MaxDB to online mode...I have transfered the last log from production database to standby database and put the production to admin mode.

I have applied the last log to standby MaxDB and tried bringing the database to online but getting error...

-24580 DBMSrv ERR_COMMAND_FAILED: Command 'db_online' has ended and failed with return code -24622.

-24622 DBMSrv ERR_AUTOLOADSYSTAB: Automatic loading of the System Tables failed

-24909 DBMSrv ERR_DBAUNKNOWN: Database system administrator unknown

But when i check the standby database state through db_state command it shows database in online mode...

Thanks,

Narendra

[former_member229109 · Accepted solution]

Hello Narendra,

What is the version of your database?

In some cases as of Version 7.7, db_online automatically restarts load_systab.

So before db_online, you have to use the following command to declare the SYSDBA on standby MaxDB server:

dbmcli -d <database_ standby_name> -u <dbm_ standby_user>,<password> user_sysdba <sysdba_production_DB_user>,<sysdba_user_password>

Please see more details in the SAP Note 1090087.

Thank you and best regards, Natalia Khlopina

[Former Member · Accepted solution]

Hi,

Thanks both of you problem resolved.

Thanks,

Narendra

[markus_doehr2]

Did you use Database Studio do bring the DB online? That's a common "error". All you have to do is loading the system tables now:

dbmcli -U c load_systab -u <dba>,<dbapasswd> -ud domain

Then you'Re done.

Markus