linux sybase ase 数据库恢复

深藏阁楼爱情的钟 2022-08-09 06:55 313阅读 0赞

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 条评论，313人围观）

还没有评论，来说两句吧...

相关阅读