|
Home > Archive > SQL Anywhere database > April 2005 > Recovery Problem...
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Recovery Problem...
|
|
| Troy Coombs 2005-04-13, 7:23 am |
| I'm doing a recovery where I've applied 4 log files fine, but the 5th log
file simply won't work using the 'a' switch I get an error, "Database
cannot be started - C:\recovery\dealer6.log is an invalid transaction log.".
So I converted the log file to an sql file and applied and it worked fine.
No errors!
However I think it probably threw the checkpoints out of whack because now
I can not apply the next log file using the 'a' switch. I guess it was
because I had to start the database without a log file in order to allow
ISQL to READ the sql file.
Any ideas on what I should or can do to get those other log files applied?
Don't say convert to sql as it would take about a week to apply the
remainder of the log files.
Troy
| |
| Chris Keating \(iAnywhere Solutions\) 2005-04-13, 9:23 am |
| Once you stop applying transaction logs using -a (i.e., the problem log) and
manually execute the sql from the log, you cannot apply any other logs that
follow using -a.
It is not checkpoints that are at issue.
I think that you should consider calling tech support and working with
someone to first understand the problem of recovery using the logs that you
have.
/ck
"Troy Coombs" <coombst@quorumis.com> wrote in message
news:425d0a6f$1@foru
ms-1-dub...
> I'm doing a recovery where I've applied 4 log files fine, but the 5th log
> file simply won't work using the 'a' switch I get an error, "Database
> cannot be started - C:\recovery\dealer6.log is an invalid transaction
> log.".
> So I converted the log file to an sql file and applied and it worked fine.
> No errors!
>
> However I think it probably threw the checkpoints out of whack because now
> I can not apply the next log file using the 'a' switch. I guess it was
> because I had to start the database without a log file in order to allow
> ISQL to READ the sql file.
>
> Any ideas on what I should or can do to get those other log files applied?
> Don't say convert to sql as it would take about a week to apply the
> remainder of the log files.
>
> Troy
>
>
|
|
|
|
|