Skip to Content
avatar image
Former Member

SAP MAXDB backup problem

Hello All,

I have a question regarding MAXDB backup.

Our configuration of MaxDB is: all Maxdb executables are on disk d: and all data files are on disk e:.

We created the following backup templates:

dbmcli.exe -d CSD -u superdba,<PASSWORD> -uUTL -c medium_put CSD_DATA E:\sapdb\BACKUP\CSD\DATA\DAT0001 FILE DATA

(for full online backup)

dbmcli.exe -d CSD -u superdba,<PASSWORD> -uUTL -c medium_put CSD_LOG E:\sapdb\BACKUP\CSD\LOG\LOG0001 FILE LOG

(for log backups)

We also backed up our database with the following commands:

dbmcli.exe -d CSD -u superdba,<PASSWORD> -uUTL -c backup_start CSD_DATA

dbmcli.exe -d CSD -u superdba,<PASSWORD> -uUTL -c backup_start CSD_LOG

The operation was successful.

Now we want to simulate data loss and recovery operation. We deleted all data/log files on disk e: (just to simulate the loss of the disk).

During the recovery process the transition to state "ADMIN" is successful. But when i click the button "NEXT" i have the following error:

Command 'db_restartinfo' has ended and failed with return code -24988.

4944 ERR -24988 DBMSrv ERR_SQL: SQL error

4944 ERR -24778 DBMSrv -902,I/O error

Can You kindly point me to right recover process? Should I restore my data-files from cold backup before recover database from online full backup?

Thanks

ERROR.jpg (38.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 09, 2012 at 04:46 PM

    Hello Aleksey,

    Since you deleted the Log Volumes and data volumes, the the database is no longer restartable. The recovery process is trying to check if the database is restartable using the "db_restartinfo" command.

    With this command it can determine the restart information of the database and also which data pages are in the log area and whether a restart of the database is possible. You need this information, during the normal recovery to make sure the database can be restarted to a consistent state.

    If you are trying to simulate a disk loss/ disk failure situation, In this case you need to perform the recovery process with initialization. So what is "RECOVERY WITH INITIALIZATION" ??

    It will initialize the data and log volumes of the current database, and import the data backed up in a complete data backup into the database.

    This is also used to create a copy of a database, such as is required for the creation of a standby database.

    Refer to http://maxdb.sap.com/doc/7_8/44/ed5673c85b67d6e10000000a155369/content.htm

    Also refer to this WIKI page for more information about RECOVERY process.

    http://wiki.sdn.sap.com/wiki/display/MaxDB/HowTo+-+SAP+MaxDB+recovery+with+Database+Manager+CLI

    Let me know if you have any quesitons.

    Regards,

    Yashwanth

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello,

      if the first log file takes all disk space (300 GB) you can add another one on another disk.

      If the first log file is deleted you can restore it from backup (if it possible).

      If restore is not possible and you had a clean shutdown than, from my point of view, you can try to create a new log file with the help of button "New..." in the log file section.

      Make a cold file system backup, before any actions performed over production system.