cancel
Showing results for 
Search instead for 
Did you mean: 

Sybase 12.0.1.3750 Database Recovery Time Issue

JimDiaz
Participant
0 Kudos
3,437

This is not a question, rather I wanted to bring attention to some issues we are seeing with database recovery times in Sybase 12.0.1.3750

Below is a snippet of the recovery log file and the output of dblog. which indicates a log file with 5434 4K pages took > 30 days to apply to a back up database. The hardware is not the issue here.

Regards,

Jim

SQL Anywhere Network Server Version 12.0.1.3750

I. 05/03 10:27:27. Database recovery in progress
I. 05/03 10:27:27.     Last checkpoint at Sat May 03 2014 10:27
I. 05/03 10:27:27.     Transaction log: D:\\Database Recovery\\Production\\Database Log Files Temp\\140502AD.LOG...
I. 05/03 10:27:33.     ... recovery 0% complete
~~~
I. 05/03 16:58:44.     ... recovery 60% complete
I. 05/11 03:53:37.     ... recovery 61% complete
I. 05/23 23:23:48.     ... recovery 62% complete
I. 05/30 14:52:20.     ... recovery 63% complete
I. 06/05 17:25:34.     ... recovery 66% complete
I. 06/05 17:25:40.     ... recovery 72% complete
~~~
I. 06/05 17:27:00.     ... recovery 100% complete
I. 06/05 17:27:09. Starting checkpoint of "Production" (Production.db) at Thu Jun 05 2014 17:27
I. 06/05 17:27:45. Finished checkpoint of "Production" (Production.db) at Thu Jun 05 2014 17:27
I. 06/05 17:27:46.     Checkpointing...
I. 06/05 17:27:46. Starting checkpoint of "Production" (Production.db) at Thu Jun 05 2014 17:27
I. 06/05 17:27:49. Finished checkpoint of "Production" (Production.db) at Thu Jun 05 2014 17:27
I. 06/05 17:27:49. Recovery complete
I. 06/05 17:28:01. Database server shutdown automatically after log applied
I. 06/05 17:28:02. Database server stopped at Thu Jun 05 2014 17:28

SQL Anywhere Transaction Log Utility Version 12.0.1.3750 File "D:\\Database Archive\\Production\\Database Log Files\\140502AD.LOG" is a transaction log file File version is 41 Log starts at offset 0568161348507 Log ends at offset 0568183604459 Log contains 5434 pages with a page size of 4096 bytes 22255952 bytes in use (99.99%), 1712 bytes free (0.01%)

Accepted Solutions (0)

Answers (0)