on 2014 Jun 10 9:36 AM
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:28SQL 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%)
Request clarification before answering.
User | Count |
---|---|
60 | |
10 | |
8 | |
8 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.