Moved Backup Files now can't do Incremental backup.

[Former Member]

Hi All:

I have sucessfully backed up (full) the DB. I have then moved the 120GB file over to a NAS.

I then changed the FULL and Incremental mediums to refer to the NAS.

Now when I am trying to do an incremental, it says I should perform a full backup first. I really would like to refer to the full (successful) moved backup file and do incrementals based on this.

Any ideas how to fix this to detect the Full backup on the the NAS?

Tony.

[Former Member]

Where can I get this from? Advantages?

Tony.

[markus_doehr2]

Check the Download section here

--> MaxDB Downloads

--> Community Editions

--> MaxDB Database Studio (for Windows)

It's a new tool - eclipse based - to do the same as you do with dbmgui - but nicer - and will sooner or later replace dbmgui.

Check it out - it's really worth it.

--

Markus

[Former Member]

Markus:

The DB Studio youy mentioned....I have installed it on 3 different machines but it does not run...a configuration error on startup. Is this a stand alone tool (installtion package)....because it seems to want something that does not exist (Eclipse?)?

Tony

[markus_doehr2]

Usually it installs everything it needs. You need to have a Java JDK installed though...

--

Markus

[Former Member]

I am using the latest DBMgui (7.6.02.10) and latest MaxDB software. If I look in the mentioned .knl and .mbf file all is ok and the history is good. If I "Read Label" for full backup it reads well.

If I try to use the dbm gui backup wizard it says it can find any full backups and hence I must do a full backup. The file (full backup) is local to the windows machine (E:\full_backup) and there are no permission issues. kernel.err has no errors.

Incremental WORKS well if I do : backup_start incremental.

Why can't I do an incremental with DBMGUI?

Tony.

[markus_doehr2]

This must be a bug in DBMGUI...

Did you try the new MaxDB database studio?

--

Markus

[Former Member]

Hello Tony,

could you execute the DBM command "backup_history_list -a SAVE" using the command line of DBMGUI (Instance -> Command Line) and copy the output into this thread? The output of this command is used by DBMGUI to detect the initial data backup or the absence thereof.

Best regards,

Tilo Heinrich

[Former Member]

Tilo:

It has no problems with the history and finds all.

the problem comes in using the DBMGui to do the backup.

It works from command line.

Tony.

[Former Member]

Hello Tony,

what is the output of command "backup_history_list -a SAVE" using the command line of DBMGUI (Instance -> Command Line)?

Best regards,

Tilo Heinrich

[Former Member]

Tilo:

As requested...

<Local>:BID> backup_history_list -a SAVE

OK

END

46D41FDD0002| |HISTLOST |2007-08-28 08:15:09| |2007-08-28 08:15:09| | | | | | | | 0| |

46D41FDD0003| |HISTLOST |2007-08-28 08:15:09| |2007-08-28 08:15:09| | | | | | | | 0| |

46D420380002| |HISTLOST |2007-08-28 08:16:40| |2007-08-28 08:16:40| | | | | | | | 0| |

46D5047C0004| |HISTLOST |2007-08-29 00:30:36| |2007-08-29 00:30:36| | | | | | | | 0| |

46D50AB40002| |HISTLOST |2007-08-29 00:57:08| |2007-08-29 00:57:08| | | | | | | | 0| |

46D9BF950003| |HISTLOST |2007-09-01 14:37:57| |2007-09-01 14:37:57| | | | | | | | 0| |

46DB57840002| |HISTLOST |2007-09-02 19:38:28| |2007-09-02 19:38:28| | | | | | | | 0| |

46DB0D500001|DAT_000000001|SAVE COLD|2007-09-02 14:19:45|2007-09-02 14:19:45|2007-09-02 14:22:39|2007-09-02 19:38:28| 1836839| |NO |Full_Backup | 14340784| 1| 0| |

46DB69ED0003|LOG_000000000|SAVE COLD|? ? |? ? |2007-09-02 20:57:02|2007-09-02 20:57:02| | | | | 0| 0| -128| |

4729C8000001|DAT_000000002|SAVE COLD|2007-11-01 07:29:05|2007-11-01 07:29:05|2007-11-01 07:36:01|2007-11-01 08:30:30| 3367963| |NO |Full_Backup | 2652312| 0| -903|not enough space on the disk. [112] |

472C14830002| |HISTLOST |2007-11-03 01:26:11| |2007-11-03 01:26:11| | | | | | | | 0| |

472BBD7F0001|DAT_000000004|SAVE COLD|2007-11-02 17:58:23|2007-11-02 17:58:23|2007-11-02 19:15:17|2007-11-03 01:26:10| 3378131| |NO |Full_Backup | 14401400| 1| 0| |

472C365B0004| |HISTLOST |2007-11-03 03:50:35| |2007-11-03 03:50:35| | | | | | | | 0| |

472C365B0005| |HISTLOST |2007-11-03 03:50:35| |2007-11-03 03:50:35| | | | | | | | 0| |

472C36480003|PAG_000000005|SAVE COLD|2007-11-02 17:58:23|2007-11-02 17:58:23|2007-11-03 03:50:35|2007-11-03 03:50:35| 3378131| |NO |Incremental | 280| 1| 0| |

473C92E40001|DAT_000000006|SAVE COLD|2007-11-15 12:40:27|2007-11-15 12:40:27|2007-11-15 12:42:35|2007-11-16 01:26:53| 4433036| |NO |FULL_LOCAL | 14570720| 1| 0| |

473D463D0002| |HISTLOST |2007-11-16 01:26:53| |2007-11-16 01:26:53| | | | | | | | 0| |

473DC2C00003|PAG_000000007|SAVE COLD|2007-11-15 12:40:27|2007-11-15 12:40:27|2007-11-16 10:18:28|2007-11-16 10:18:28| 4433036| |NO |Incremental | 280| 1| 0| |

473DC2D40004| |HISTLOST |2007-11-16 10:18:28| |2007-11-16 10:18:28| | | | | | | | 0| |

47492EE40001|PAG_000000008|SAVE COLD|2007-11-25 02:10:17|2007-11-25 02:10:17|2007-11-25 02:14:46|2007-11-25 02:16:28| 4670984| |NO |Incremental | 43248| 1| 0| |

47492F5C0002| |HISTLOST |2007-11-25 02:16:28| |2007-11-25 02:16:28| | | | | | | | 0| |

475365050002|PAG_000000009|SAVE WARM|2007-12-02 20:08:05|2007-12-02 20:08:05|2007-12-02 20:08:06|2007-12-02 20:12:33| 5043147| |NO |Incremental | 95720| 1| 0| |

475366190003| |HISTLOST |2007-12-02 20:12:41| |2007-12-02 20:12:41| | | | | | | | 0| |

475369380004|LOG_000000000|SAVE WARM|? ? |? ? |2007-12-02 20:26:00|2007-12-02 20:26:00| | | | | 0| 0| -128| |

[Former Member]

Hello Tony,

Every data backup of yours is followed by a HISTLOST entry. This shows that you are running your database in the log mode OVERWRITE. As we could verify, there is a bug in DBMGUI and DB Studio, that prevents you from creating incremental data backups. Until this bug is resolved, you can create your incremental backups only by using the command line DBMCLI or by changing the log mode of your database to NORMAL.

Best regards,

Tilo Heinrich

[Former Member]

Thanks for the reply.

I am ruuning a windows system and I do have to map with user /pass to it. From the windows os I can see my full backup. i am not sure what you mean by "read label" ... please explain?

Thanks

Tony.

[Former Member]

Hi Tony,

we had similiar problems like this in a Linux-Enviroment.

Did you try to "read label" on the referenced backup-files on the nas?

perhaps it's just a silly permission-problem like we had where owner/group of the sdb-group wheren't avaible on the nas-system which lead to nasty effects.

Flo

[markus_doehr2]

MaxDB saves the backups in

/sapdb/data/wrk/.knl

Is your backup in those files?

--

Markus

Message was edited by:

Markus Döhr