暂无图片
暂无图片
3
暂无图片
暂无图片
暂无图片
某医院_数据库迁移升级_实施方案
3286
21页
176次
2020-02-10
5墨值下载
云和恩墨 成就所托 www.enmo tech .com
某医院
数据库迁移升级方案
(1.1
)
云和恩墨
北京
信息技术有限公司

http://www.enmo tech .com 实力成就稳健 技术创造价值
1
云和恩墨 成就所托 www.enmo tech .com
目 录
1. 项目目标
.............................................................................................................................................................................5
2. 项目计划
.......................... ...................................................................................................................... ................ 6
3. 数据库基本环境检查
.......................... .................................................................................................................... 7
4. 环境搭建
.......................... ...................................................................................................................... ................ 8
4.1. 安装目标端操作系统
.................................................................................................................................... ............8
4.2. 搭建目标端 11.2.0.4 RAC 环境,安装最新 PSU 11.2.0.4.160119
....................... .... ............... ............... ........8
4.3. 调整数据库参数
.................................................................... ............... .............................. ............... .... ............... .. 8
5. 迁移测试
.......................... ...................................................................................................................... ................ 9
5.1. 生产库数据导出
.................................................................... ............... .............................. ............... .... ............... .. 9
5.2. DUMP 文件传输
................................................................................. ............... .............................. ............... .... ... 10
5.3. 创建部分无数据未导出的用户
.......................................................... .... ............... ............... .............................. ..10
5.4. 创建 PUBLIC DBLINK
..................................................................................... ............... .............................. ..........10
5.5. 数据导入
....................................................................... ............... ............... .... ............... ............... ........................ 11
5.6. 索引、对象、视图、存储过程等对比调整
.................................... .... ............... ............... .............................. .... 12
5.7. 用户权限
....................................................................... ............... ............... .... ............... ............... ........................ 16
5.8. SPA 测试
................................................................... ............... .............................. ............... .............................. .. 16
6. 正式割接实施
.......................... ............................................................................................................................. 19
6.1. 测试环境清理
......................................................... ............... ............... .............................. .............................. .... 19
6.2. 生产库操作
............................................................................. ............... .............................. .............................. ... 19
6.3. 目标库操作
............................................................................. ............... .............................. .............................. ... 20
6.4. RAC 修改 SCAN IP 地址
....................................................................... ............... ............... .... ............... ............... . 20
7. 回退方案
...................................................................................................................................................................... .... .22
http://www.enmo tech .com 实力成就稳健 技术创造价值
2
of 21
5墨值下载
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文档的来源(墨天轮),文档链接,文档作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。
关注
最新上传
暂无内容,敬请期待...
下载排行榜
Top250 周榜 月榜