z***y 发帖数: 7151 | 1 今天4点多被pager叫起来, 一个做reporting 的数据库, snapshot database was
not available.
There's job to create snapshot every 6 hours. However, the last two jobs are
all failed. The fail message are different:
1. The database is not online and cannot do snapshot
2. The database exists and cannot be dropped,
大家猜想一下, 这都可能是什么问题引起的?
The job first to check if there's database called *_snapshot, if there was,
then dropped it.
then it will create new snapshot database. | s**********o 发帖数: 14359 | 2 为什么要DROP DATABASE?是不是有一个SNAPSHOT DATABASE?
原则上TABLE都应该在REPORTDB里 |
|