MBA from Offenburg university or MBA&E from HTW berlin. which better. Moreover, living experience in Gengenbach or berlin is better.

Search the board first and let us know your goals. Why not take an MBA with international accreditation.?

MBA from international accreditation need alot of money and GMAT or GRE.
Inaddition that it may need german lanaguage. While this two collage is easy to get accepted and not very expensive. I think that also both are accredited

I think this really depends on your goals. Internationally-accredited schools in Germany include state universities, where the MSc is basically free, like Muenster, Mannheim and the TU Munich. If you just want to spend a year in Germany, then why not study an MSc for free? A 'freshers' MBA without international accreditation will not be better, and will simply be more costly.

What do you want to do with the degree?

I want to stay in germany after I finish and find a work. This is simply what I want from the degree

Degree in germany is my residency there and will help me stay there for a long time until I adjust my situation

In that case I suggest you learn German and then take an MSc taught in German.

Degree in germany is my residency there and will help me stay there for a long time until I adjust my situation

Typically after your master's program you would be able to get an 18-month visa to find work in the country:

https://www.international.hu-berlin.de/en/studierende/aus-dem-ausland/wegweiser/10/10_01_02

... during which time you could work or do freelance jobs, etc. A more permanent residency permit would be sponsored by an employer, if you get a job.