linux sybase ase 数据库恢复

来源：互联网发布：python使用领域编辑：程序博客网时间：2024/04/29 09:35

1、步骤

isql -Usa -PXXX -Sxxx -X

1> disk init name ="msgdb" ,physname="/users/nweng/ASE/data/msgdb.dat" ,size='2G'

2> go

1> disk init name ="msgdb_log",physname="/users/nweng/ASE/data/msgdb_log.dat",size='1G'

2> go

1> Create database msgdb on msgdb='1500M' log on msgdb_log ='500M'

2> go

1> load database msgdb from "compress::/usr/u/msgdb.cmp"

2> go

1> online database msgdb

2> go

2、遇到的错误和处理

Started estimating recovery log boundaries for database 'msgdb'.

Database 'msgdb', checkpoint=(97416, 10), first=(97416, 10), last=(97416, 11).

Completed estimating recovery log boundaries for database 'msgdb'.

Started ANALYSIS pass for database 'msgdb'.

Completed ANALYSIS pass for database 'msgdb'.

Recovery of database 'msgdb' will undo incomplete nested top actions.

Database 'msgdb' cannot be brought online because it has replicated tables that

may not be completely transferred. After making sure that your replication is in

sync, use dbcc dbrepair to remove the secondary truncpt.

执行：

1> dbcc dbrepair(msgdb,ltmignore)

2> go

再

1> online database msgdb

2> go

0 0