目录
1 修改记录........................................................................................................................................3
2 简介................................................................................................................................................3
3． 数据库的物理环境....................................................................................................................4
3.1 网络环境.............................................................................................................................4
3.2 目录设置.............................................................................................................................5
3.3 文件设置.............................................................................................................................5
4． 数据库账户管理........................................................................................................................5
5． 数据库备份和恢复....................................................................................................................6
5.1 开发测试环境.....................................................................................................................8
5.2 生产环境.............................................................................................................................8
5.2.1 用户数据库..............................................................................................................8
5.2.2 系统数据库..............................................................................................................9
5.2.3 异地备份..................................................................................................................9
5.2.4 恢复计划..................................................................................................................9
6． 数据库监控................................................................................................................................9
7． 数据库维护..............................................................................................................................11
7.1 性能优化...........................................................................................................................11
7.2 恢复或者切换演练...........................................................................................................11
附录 1 数据库备份，验证备份脚本.............................................................................................12
附录 2 数据库恢复脚本.................................................................................................................14
附录 3 清除备份文件脚本.............................................................................................................15
附录 4 事件通知例子.....................................................................................................................16
附录 5 数据库账户申请表格.........................................................................................................17
