Hi,
For whatever reason I had to restart my mac yesterday without being able to quit the db’s.
It looks like 2 log files are corrupt, at least sybase complains they are too short.
In the 9 days I could simply take them out and they were rebuilt.
Not with 10 so it seems…
Is anybody aware of a solution to this issue?
Another thing is that with a missing db Sybase 9 would still start.
Again, not with 10
Thanks
If that happens your database crashed in the middle of a transaction and then (on purpose) it will not start until you decided what you want to do with the transaction that was going on during the crash.
You can use the log translation function to translate the log to what was going on and the force the system to ignore that last transaction by starting once with the -f option:
dbsrv9 -f dbname
then launch normally
Thanks for the answer Jan!!!
Sybase refused to recover with the log file present. Basically the error message was the same as before.
After removing the log files recovery went as expected.
Makes me think again if I should implement backup scripts again
Although nothing critical is in these databases I would not have liked to spend (too much) time to rebuild them.