Highlighted
Absent Member.
Absent Member.
4383 views

Sybase DB Repair Tool

We had a power outage and since we have not been able to login to our ZCM11 install. We get the error "Unable to connect to the ZENworks database". Our backup may be lost on the server holding the backup. Is there a way to check the health of our ZCM DB and if possible repair or otherwise "fix" it should it be corrupt?

Labels (2)
0 Likes
3 Replies
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Sybase DB Repair Tool

There are some things that can be done, but I dont recall the exact
details on how to do them since I do them very rarely, but I can give
you a basic idea of the basic steps I would do.......

Stop all ZCM Services.

Backup current DB and Transaction log

Start the SybaseDB with a switch to load w/o the transaction log.
(A Corrupt Log is the most likely reason the DB will not load.)

Do a DB Rebuild which will export the current DB to a new DB.
(the NEW DB MUST be the SAME EXACT NAME, just ported to a new folder)

Then stop Sybase, and delete the old DB and transaction log after
confirming you have them backed up.

Then Copy the New DB and any log to the location of the old DB and
transaction log.

Restart all services including the DB.

I believe that ever step other than start the DB w/o the transaction log
is documented somewhere. When I find that I will let you know unless
you find it first.


On 1/11/2012 4:16 PM, technomoney wrote:
>
> We had a power outage and since we have not been able to login to our
> ZCM11 install. We get the error "Unable to connect to the ZENworks
> database". Our backup may be lost on the server holding the backup. Is
> there a way to check the health of our ZCM DB and if possible repair or
> otherwise "fix" it should it be corrupt?
>
>



--
Craig Wilson - MCNE, MCSE, CCNA
Novell Knowledge Partner

Novell does not officially monitor these forums.

Suggestions/Opinions/Statements made by me are solely my own.
These thoughts may not be shared by either Novell or any rational human.
--
Please give a hearty thumbs up to any post you find helpful!
To find articles by Craig Wilson simply follow the link: Craig Wilson's Tips!
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: Sybase DB Repair Tool

Hi Craig,
We almost had a Sybase DB go wonky on us today, it managed to recover by itself thankfully

You wouldn't happen to recall the steps or where this doc is to do a recovery at all?

As googling for sybase repair / recovery just leads to paid for online dodgy looking websites and 3rd party stuff, but I'd much rather have the proper docs on doing it if need be

0 Likes
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Sybase DB Repair Tool

There are not really many tools.

You can use the -f parameter to start the database w/o the Transaction
Log. If the transaction log is corrupt, it will prevent the db from
loading in many cases.

At that point, use the rebuild procedures in the docs to rebuild the
database.

If the database will still not load w/o the transaction log, the only
option that I know would be a Per Incident ticket with Sybase to see
what they can do.

If the database loads, but the rebuild process fails due to internal
issues with a database or index, you will need some SQL know now to get
things running. Manually rebuild indexes. Export tables one by one,
and export portions of tables before and after bad records, etc.. etc..

Backups are very important though.





On 4/19/2012 2:16 AM, gleach1 wrote:
>
> Hi Craig,
> We almost had a Sybase DB go wonky on us today, it managed to recover
> by itself thankfully
>
> You wouldn't happen to recall the steps or where this doc is to do a
> recovery at all?
>
> As googling for sybase repair / recovery just leads to paid for online
> dodgy looking websites and 3rd party stuff, but I'd much rather have the
> proper docs on doing it if need be
>
>



--
Craig Wilson - MCNE, MCSE, CCNA
Novell Knowledge Partner

Novell does not officially monitor these forums.

Suggestions/Opinions/Statements made by me are solely my own.
These thoughts may not be shared by either Novell or any rational human.
--
Please give a hearty thumbs up to any post you find helpful!
To find articles by Craig Wilson simply follow the link: Craig Wilson's Tips!
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.