See recovery status

[sumit.kd]

I am working on a sybase database whose status and status2
values in sysdatabases table are respectively 68 and 48.
This shows that the database in recovering and in offline
mode. The options shown with sp_helpdb are also "select
into/bulkcopy, offline". This is in this same state for
hours after the ASE server was rebooted. How can I know the
status or extent to which the database has recovered so that
I can estimate the time after which the database will be
fully recovered and online.

[Manish Negandhi [TeamSybase]]

What is the output of select @@recovery_state ? Is there any error in
the error log during recovering ? Recovery time usually depends on
the volume of transactions when you shutdown the server. Check
physical_io of the spid of the recovery process from
master..sysprocesses , is it moving ?

-HTH
Manish Negandhi
[TeamSybase]

[Derek Asirvadem]

> On 2009-02-17 17:58:16 +1100, "Manish Negandhi [TeamSybase]"
> <negandh...@gmail.com> said:

And the recovery progressing in the errorlog. If there is no progress,
the server went down while the db was being recovered and it never
finished: go backward in the errorlog and lokk for that event, and the
err msgs that accompanied it.

--
Cheers
Derek
Senior Sybase DBA / Information Architect
Copyright © 2008 Software Gems Pty Ltd
"Patient, normalise thyself"

[Bret Halford [Sybase]]

What version is this on?

Beginning in 12.5.3 and with some enhancements in 12.5.4 ESD #7 and
15.0.2 ESD #2, there is a DBCC SHOWRECOVERY command displays recovery
status; running it at intervals will give an indication of rate of progress.

Try

dbcc traceon(3604)
go
dbcc showrecovery(dbname)
go

Sample output:

1> dbcc traceon(3604)
2> go
1> dbcc showrecovery
2> go

Recovery Log Markers:
Checkpoint Log Record: (521145198, 21)
First Log Record: (516510375, 14)
Last Log Record: (521145198, 21)
Analysis Statistics:
Log I/O Size: 32768
Total records to scan: 149658428
Number of records in phase 1: 0 (0.0%)
Number of records to redo in phase 1: 3 (100.0%)
Number of records in phase 2: 149658428 (100.0%)
Number of records to redo in phase 2: 149658428
(100.0%)
Total number of log records to redo: 149658431 (100.0%)
Redo Statistics:
Total operations considered for redo: 5
Operations that did not need redo (PFTS check): 3 (60.0%)
Operations that might need redo (PFTS check): 0 (0.0%)
Operations that needed redo (timestamp check): 0 (0.0%)
Operations that did not need redo (timestamp check): 2
(40.0%)
Total number of log records to undo: 4