重启服务器后,sybase无法online
虎扑羊总 2014-02-08 11:11:39
00:00000:00001:2014/02/08 10:28:03.14 server Recovery has tuned the size of '64K' pool in 'default data cache' to benefit recovery performance. The original configuration will be restored at the end of recovery.
00:00000:00001:2014/02/08 10:28:03.14 server Recovery has tuned the size of '8K' pool in 'default data cache' to benefit recovery performance. The original configuration will be restored at the end of recovery.
00:00000:00001:2014/02/08 10:28:03.14 server Recovery has tuned the '64K' pool in 'default data cache' by changing its 'local async prefetch limit' from 10 to 80. The original configuration will be restored at the end of recovery.
00:00000:00001:2014/02/08 10:28:03.14 server Recovery has tuned the '8K' pool in 'default data cache' by changing its 'local async prefetch limit' from 10 to 80. The original configuration will be restored at the end of recovery.
00:00000:00017:2014/02/08 10:28:03.18 server Recovering database 'xtbg'.
00:00000:00017:2014/02/08 10:28:03.18 server Started estimating recovery log boundaries for database 'xtbg'.
00:00000:00017:2014/02/08 10:28:04.64 server Database 'xtbg', checkpoint=(411751, 63), first=(463148, 48), last=(445597, 143).
00:00000:00017:2014/02/08 10:28:04.64 server Completed estimating recovery log boundaries for database 'xtbg'.
00:00000:00017:2014/02/08 10:28:04.64 server Started ANALYSIS pass for database 'xtbg'.
00:00000:00018:2014/02/08 10:28:05.21 server Error: 840, Severity: 17, State: 2
00:00000:00018:2014/02/08 10:28:05.21 server Device 'controlcenter' (with physical name 'D:\sybase\dataxtbg\controlcenter.dat', and virtual device number 6) has not been correctly activated at startup time. Please contact a user with System Administrator (SA) role.
00:00000:00018:2014/02/08 10:28:05.39 server Continuing recovery with the next database.
00:00000:00001:2014/02/08 10:28:06.26 server The optimal number of recovery processes is 2.
00:00000:00017:2014/02/08 10:28:18.31 server Completed ANALYSIS pass for database 'xtbg'.
00:00000:00017:2014/02/08 10:28:18.31 server Started REDO pass for database 'xtbg'. The total number of log records to process is 22316787.
01:00000:00017:2014/02/08 10:28:37.42 server Redo pass for database 'xtbg': 1119915 records done (5%); 21196872 records left.
01:00000:00017:2014/02/08 10:28:52.37 server Redo pass for database 'xtbg': 2239295 records done (10%); 20077492 records left.
01:00000:00017:2014/02/08 10:29:12.32 server Redo pass for database 'xtbg': 3355754 records done (15%); 18961033 records left.
01:00000:00017:2014/02/08 10:29:19.82 server Redo pass for database 'xtbg': 4471593 records done (20%); 17845194 records left.
01:00000:00017:2014/02/08 10:29:26.67 server Redo pass for database 'xtbg': 5587432 records done (25%); 16729355 records left.
01:00000:00017:2014/02/08 10:29:29.96 server Redo pass for database 'xtbg': 6703271 records done (30%); 15613516 records left.
01:00000:00017:2014/02/08 10:29:33.87 server Redo pass for database 'xtbg': 7819110 records done (35%); 14497677 records left.
01:00000:00017:2014/02/08 10:29:40.01 server Redo pass for database 'xtbg': 8934949 records done (40%); 13381838 records left.
01:00000:00017:2014/02/08 10:29:51.43 server Redo pass for database 'xtbg': 10050788 records done (45%); 12265999 records left.
01:00000:00017:2014/02/08 10:30:12.75 server Redo pass for database 'xtbg': 11166627 records done (50%); 11150160 records left.
01:00000:00017:2014/02/08 10:31:12.82 server Redo pass for database 'xtbg': 12282466 records done (55%); 10034321 records left.
********************************************************************************
什么情况会出现这个REDO的百分比过程?