Author Topic: Backup and restore log useful for DB corruption  (Read 2154 times)

Offline pmhaynes

  • Global Moderator
  • Sr. Member
  • *****
  • Posts: 238
  • Country: gb
  • Karma: +11/-0
    • View Profile
Backup and restore log useful for DB corruption
« on: November 10, 2020, 12:02:30 PM »
I had a extension that i could not get rid of. Mitel recommeded a backup and restore to resolve
From what i could tell there was no visability of what was happening during this backup and restore
Did it find the issue and resolve it?
Was there more than one number with an issue?

I was told about this command and log file
It's probably in the manual somewhere but i didnt know about it
so i thought i would share it with the community

All sorted now

https://phonesystemhelp.info/mivb-database-corruption-logs/


Offline sunspark

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 984
  • Country: mx
  • Karma: +16/-1
    • View Profile
Re: Backup and restore log useful for DB corruption
« Reply #1 on: November 10, 2020, 12:38:43 PM »
you didn't have to do all that, (and especially the backup restore is the last last last solution)

If you have a problem with an extension:

1st suggestion (depending on the version of your Mivb)

Command: gdm check users / gdm repair

2nd solution: activate the hidden menu: sdsdebug on / sdsdebug off
then solve the problem of your extension

3rd solution: there is a hidden command that allows you to override database error, which allows you to solve the backup problem for example.

Offline pmhaynes

  • Global Moderator
  • Sr. Member
  • *****
  • Posts: 238
  • Country: gb
  • Karma: +11/-0
    • View Profile
Re: Backup and restore log useful for DB corruption
« Reply #2 on: November 11, 2020, 12:48:46 AM »
Thanks for the reply
I agree the backup restore was a last resort
I didn’t do it lightly and without trying sds debug
In this case it was recommended by mitel tech support
 :)

Offline august

  • Sr. Member
  • ****
  • Posts: 258
  • Country: ca
  • Karma: +9/-0
    • View Profile
Re: Backup and restore log useful for DB corruption
« Reply #3 on: November 11, 2020, 08:07:21 AM »
In maintenance command, after the restore:

type *.dr.logfile_1

press ok

If something did not restore properley, you will see it.

Offline sarond

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1402
  • Country: au
  • Karma: +73/-0
    • View Profile
Re: Backup and restore log useful for DB corruption
« Reply #4 on: November 11, 2020, 06:20:52 PM »
Hi pmhaynes,

I feel that most people are missing the point of your posts. You are already giving the solution to help others, I understand that and appreciate it as your blog is quite helpful.

Maybe some aren't following your link. Could I suggest also putting a TL;DR in the original post here so that others can see at a glance what you have achieved?

Offline sunspark

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 984
  • Country: mx
  • Karma: +16/-1
    • View Profile
Re: Backup and restore log useful for DB corruption
« Reply #5 on: November 12, 2020, 04:14:44 AM »
hi sarond,

I also appreciate the solution of pmhaynes. I just proposed another approach if it encounters the same problem, to avoid the backup / restore.


 

Sitemap 1 2 3 4 5 6 7 8 9 10