当前位置：首页 > news >正文

从 Oracle 集群到单节点环境（详细记录一次数据迁移过程）之一：生产环境与目标服务器详情

news 2025/7/14 0:46:45

从 Oracle 集群到单节点环境（详细记录一次数据迁移过程）之一：生产环境与目标服务器详情

从 Oracle 集群到单节点环境（详细记录一次数据迁移过程）之一：生产环境与目标服务器详情
- 一、操作系统环境
- 二、Oracle 数据库基本信息（节点1）
- 三、数据文件信息
- 四、日志文件信息
- 五、Oracle 数据库总数据量
- 六、数据文件总大小

用户有一个双节点 Oracle 集群，由于工作需要，需要对生产库中的数据进行测试。基于数据安全考虑，测试方提出把生产库中的数据导出，然后导入一个单机测试环境进行数据测试。

生产数据环境为 Oracle11g 双节点集群，服务器操作系统为 Centos7.3，目标服务器为单节点服务器，服务器操作系统为 Centos7.5，详细情况如下：

一、操作系统环境

# 1、生产服务器操作系统环境（节点1）[root@his01 bak0921]# cat /etc/redhat-release
CentOS Linux release 7.3.1611 (Core)# 2、目标服务器操作系统环境
[root@node1 oradata]# cat /etc/redhat-release
CentOS Linux release 7.5.1804 (Core)

二、Oracle 数据库基本信息（节点1）

SQL> show parameter name;NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
cell_offloadgroup_name		      string
db_file_name_convert		      string	   /oradata/dghisdb/, +DATA/hisdb/
db_name 			             string	      HISDB（数据库名）
db_unique_name			         string	      HISDB
global_names			         boolean	 FALSE
instance_name			         string	     hisdb1（节点1的实例名）
lock_name_space 		         string
log_file_name_convert		     string	     /oradata/dghisdb/onlinelog/, +DATA/hisdb/onlinelog/
processor_group_name		     string
service_names			         string	      HISDB

三、数据文件信息

SQL> select name from v$datafile;NAME
------------------------------------------------------------------------------------------------
+DATA/hisdb/datafile/system.413.1109379227
+DATA/hisdb/datafile/undotbs1.345.1109379195
+DATA/hisdb/datafile/sysaux.412.1109379225
+DATA/hisdb/datafile/users.423.1109379259
+DATA/hisdb/datafile/system.369.1109379199
+DATA/hisdb/datafile/sysaux.419.1109379239
+DATA/hisdb/datafile/users.347.1109379195
+DATA/hisdb/datafile/data_user.407.1109379221
+DATA/hisdb/datafile/data_com.386.1109379201
+DATA/hisdb/datafile/data_fin.318.1109379187
+DATA/hisdb/datafile/data_met.313.1109379185
+DATA/hisdb/datafile/data_log.418.1109379233
+DATA/hisdb/datafile/data_goa.422.1109379259
+DATA/hisdb/datafile/data_aqu.420.1109379239
+DATA/hisdb/datafile/data_sem.400.1109379213
+DATA/hisdb/datafile/data_emr.416.1109379229
+DATA/hisdb/datafile/data_lis.409.1109379223
+DATA/hisdb/datafile/data_cas.408.1109379221
+DATA/hisdb/datafile/data_ais.410.1109379223
+DATA/hisdb/datafile/data_other.406.1109379217
+DATA/hisdb/datafile/data_pha.292.1109379173
+DATA/hisdb/datafile/data_itemlist.281.1109379159
+DATA/hisdb/datafile/data_medicinelist.282.1109379161
+DATA/hisdb/datafile/data_feeinfo.291.1109379171
+DATA/hisdb/datafile/data_feedetail.354.1109379197
+DATA/hisdb/datafile/data_applyout.275.1109379159
+DATA/hisdb/datafile/data_output.286.1109379169
+DATA/hisdb/datafile/data_record.293.1109379173
+DATA/hisdb/datafile/data_execdrug.272.1109379159
+DATA/hisdb/datafile/data_execundrug.314.1109379185
+DATA/hisdb/datafile/data_order.274.1109379159
+DATA/hisdb/datafile/data_recipedetail.389.1109379203
+DATA/hisdb/datafile/index_user.404.1109379215
+DATA/hisdb/datafile/index_com.392.1109379203
+DATA/hisdb/datafile/index_fin.312.1109379183
+DATA/hisdb/datafile/index_pha.288.1109379171
+DATA/hisdb/datafile/index_met.311.1109379181
+DATA/hisdb/datafile/index_log.394.1109379203
+DATA/hisdb/datafile/index_goa.398.1109379211
+DATA/hisdb/datafile/index_aqu.405.1109379217
+DATA/hisdb/datafile/index_sem.414.1109379227
+DATA/hisdb/datafile/index_emr.395.1109379203
+DATA/hisdb/datafile/index_lis.399.1109379213
+DATA/hisdb/datafile/index_cas.393.1109379203
+DATA/hisdb/datafile/index_ais.421.1109379243
+DATA/hisdb/datafile/index_other.396.1109379209
+DATA/hisdb/datafile/index_itemlist.271.1109379159
+DATA/hisdb/datafile/index_medicinelist.279.1109379159
+DATA/hisdb/datafile/index_feeinfo.273.1109379159
+DATA/hisdb/datafile/index_feedetail.320.1109379187
+DATA/hisdb/datafile/index_applyout.284.1109379161
+DATA/hisdb/datafile/index_output.298.1109379173
+DATA/hisdb/datafile/index_record.391.1109379203
+DATA/hisdb/datafile/index_execdrug.343.1109379195
+DATA/hisdb/datafile/index_execundrug.351.1109379197
+DATA/hisdb/datafile/index_order.325.1109379189
+DATA/hisdb/datafile/index_recipedetail.397.1109379209
+DATA/hisdb/datafile/data_user.401.1109379215
+DATA/hisdb/datafile/data_com.350.1109379197
+DATA/hisdb/datafile/data_fin.339.1109379193
+DATA/hisdb/datafile/data_met.340.1109379193
+DATA/hisdb/datafile/data_log.349.1109379197
+DATA/hisdb/datafile/data_goa.352.1109379197
+DATA/hisdb/datafile/data_aqu.348.1109379195
+DATA/hisdb/datafile/data_sem.355.1109379197
+DATA/hisdb/datafile/data_emr.358.1109379197
+DATA/hisdb/datafile/data_lis.368.1109379199
+DATA/hisdb/datafile/data_cas.342.1109379193
+DATA/hisdb/datafile/data_ais.361.1109379199
+DATA/hisdb/datafile/data_other.356.1109379197
+DATA/hisdb/datafile/data_pha.336.1109379193
+DATA/hisdb/datafile/data_itemlist.278.1109379159
+DATA/hisdb/datafile/data_medicinelist.294.1109379173
+DATA/hisdb/datafile/data_feeinfo.321.1109379187
+DATA/hisdb/datafile/data_feedetail.364.1109379199
+DATA/hisdb/datafile/data_applyout.295.1109379173
+DATA/hisdb/datafile/data_output.299.1109379177
+DATA/hisdb/datafile/data_record.297.1109379173
+DATA/hisdb/datafile/data_execdrug.289.1109379171
+DATA/hisdb/datafile/data_execundrug.327.1109379189
+DATA/hisdb/datafile/data_order.307.1109379181
+DATA/hisdb/datafile/data_recipedetail.387.1109379203
+DATA/hisdb/datafile/index_user.417.1109379231
+DATA/hisdb/datafile/index_com.402.1109379215
+DATA/hisdb/datafile/index_fin.331.1109379191
+DATA/hisdb/datafile/index_pha.330.1109379191
+DATA/hisdb/datafile/index_met.328.1109379189
+DATA/hisdb/datafile/index_log.334.1109379193
+DATA/hisdb/datafile/index_goa.366.1109379199
+DATA/hisdb/datafile/index_aqu.363.1109379199
+DATA/hisdb/datafile/index_sem.365.1109379199
+DATA/hisdb/datafile/index_emr.360.1109379197
+DATA/hisdb/datafile/index_lis.359.1109379197
+DATA/hisdb/datafile/index_cas.367.1109379199
+DATA/hisdb/datafile/index_ais.371.1109379199
+DATA/hisdb/datafile/index_other.332.1109379193
+DATA/hisdb/datafile/index_itemlist.280.1109379159
+DATA/hisdb/datafile/index_medicinelist.310.1109379181
+DATA/hisdb/datafile/index_feeinfo.362.1109379199
+DATA/hisdb/datafile/index_feedetail.376.1109379201
+DATA/hisdb/datafile/index_applyout.357.1109379197
+DATA/hisdb/datafile/index_output.374.1109379201
+DATA/hisdb/datafile/index_record.381.1109379201
+DATA/hisdb/datafile/index_execdrug.378.1109379201
+DATA/hisdb/datafile/index_execundrug.384.1109379201
+DATA/hisdb/datafile/index_order.373.1109379199
+DATA/hisdb/datafile/index_recipedetail.380.1109379201
+DATA/hisdb/datafile/index_applyout.301.1109379179
+DATA/hisdb/datafile/index_feeinfo.296.1109379173
+DATA/hisdb/datafile/index_feedetail.306.1109379181
+DATA/hisdb/datafile/data_pha.323.1109379187
+DATA/hisdb/datafile/data_feeinfo.303.1109379179
+DATA/hisdb/datafile/data_feedetail.316.1109379187
+DATA/hisdb/datafile/index_applyout.300.1109379179
+DATA/hisdb/datafile/data_execdrug.322.1109379187
+DATA/hisdb/datafile/data_execundrug.338.1109379193
+DATA/hisdb/datafile/data_fin.324.1109379187
+DATA/hisdb/datafile/index_com.390.1109379203
+DATA/hisdb/datafile/index_order.305.1109379181
+DATA/hisdb/datafile/index_met.315.1109379185
+DATA/hisdb/datafile/data_met.302.1109379179
+DATA/hisdb/datafile/index_pha.319.1109379187
+DATA/hisdb/datafile/index_medicinelist.304.1109379179
+DATA/hisdb/datafile/data_medicinelist.290.1109379171
+DATA/hisdb/datafile/data_order.308.1109379181
+DATA/hisdb/datafile/data_applyout.287.1109379169
+DATA/hisdb/datafile/index_fin.329.1109379191
+DATA/hisdb/datafile/index_execdrug.326.1109379189
+DATA/hisdb/datafile/index_feeinfo.337.1109379193
+DATA/hisdb/datafile/index_output.309.1109379181
+DATA/hisdb/datafile/data_execdrug.317.1109379187
+DATA/hisdb/datafile/data_execundrug.335.1109379193
+DATA/hisdb/datafile/data_feeinfo.382.1109379201
+DATA/hisdb/datafile/data_feedetail.377.1109379201
+DATA/hisdb/datafile/data_itemlist.379.1109379201
+DATA/hisdb/datafile/data_medicinelist.372.1109379199
+DATA/hisdb/datafile/data_output.370.1109379199
+DATA/hisdb/datafile/data_pha.411.1109379225
+DATA/hisdb/datafile/data_recipedetail.283.1109379161
+DATA/hisdb/datafile/data_record.383.1109379201
+DATA/hisdb/datafile/index_applyout.341.1109379193
+DATA/hisdb/datafile/index_execundrug.333.1109379193
+DATA/hisdb/datafile/index_feeinfo.385.1109379201
+DATA/hisdb/datafile/index_itemlist.346.1109379195
+DATA/hisdb/datafile/index_medicinelist.344.1109379195
+DATA/hisdb/datafile/index_output.375.1109379201
+DATA/hisdb/datafile/data_fin.388.1109379203
+DATA/hisdb/datafile/data_output.353.1109379197
+DATA/hisdb/datafile/data_user.415.1109379229
+DATA/hisdb/datafile/data_order.285.1109379161
+DATA/hisdb/datafile/emr5.403.1109379215
+DATA/hisdb/datafile/data_order.277.1109379159
+DATA/hisdb/datafile/data_order.270.1109379159
+DATA/hisdb/datafile/data_user.276.1109379159
+DATA/hisdb/datafile/undotbs2.429.1109386101
+DATA/hisdb/datafile/nfemr.dbf
+DATA/hisdb/datafile/emr52012.dbf
+DATA/hisdb/datafile/emr52013.dbf
+DATA/hisdb/datafile/emr52014.dbf
+DATA/hisdb/datafile/emr52015.dbf
+DATA/hisdb/datafile/emr52016.dbf
+DATA/hisdb/datafile/emr52017.dbf
+DATA/hisdb/datafile/emr52018.dbf
+DATA/hisdb/datafile/mr52019.dbf
+DATA/hisdb/datafile/emr52020.dbf
+DATA/hisdb/datafile/emr52021.dbf
+DATA/hisdb/datafile/emr52022.dbf
+DATA/hisdb/datafile/emr5.403.1109379326.dbf
+DATA/hisdb/datafile/emr5202301.dbf
+DATA/hisdb/datafile/emr5202302.dbf
+DATA/hisdb/datafile/emr5202303.dbf
+DATA/hisdb/datafile/neuodts.dbf
+DATA/hisdb/datafile/neucbus.dbf
+DATA/hisdb/datafile/emr5202305.dbf
+DATA/hisdb/datafile/emr5202401.dbf
+DATA/hisdb/datafile/emr52022_data41801.dbf
+DATA/hisdb/datafile/emr52022_data41802.dbf
+DATA/hisdb/datafile/emr52022_data41803.dbf
+DATA/hisdb/datafile/emr52022_data41804.dbf
+DATA/hisdb/datafile/emr52023_data41801.dbf
+DATA/hisdb/datafile/emr52023_data41802.dbf
+DATA/hisdb/datafile/emr52023_data41803.dbf
+DATA/hisdb/datafile/emr52023_data41804.dbf
+DATA/hisdb/datafile/emr52024_data41801.dbf
+DATA/hisdb/datafile/emr52024_data41802.dbf
+DATA/hisdb/datafile/emr52024_data41803.dbf
+DATA/hisdb/datafile/emr52024_data41804.dbf
+DATA/hisdb/datafile/emr52024_data01.dbf
+DATA/hisdb/datafile/emr52024_data02.dbf
+DATA/hisdb/datafile/emr52024_data03.dbf
+DATA/hisdb/datafile/emr52024_data04.dbf
+DATA/hisdb/datafile/emr52024_data05.dbf
+DATA/hisdb/datafile/emr52024_data06.dbf193 rows selected.

四、日志文件信息

SQL> select member from v$logfile;MEMBER
-------------------------------------------------------------------------------------------------------
+DATA/hisdb/onlinelog/redo01.log
+DATA/hisdb/onlinelog/redo02.log
+DATA/hisdb/onlinelog/redo04.log
+DATA/hisdb/onlinelog/redo05.log
+DATA/hisdb/onlinelog/redo06.log
+DATA/hisdb/onlinelog/redo03.log
+DATA/hisdb/onlinelog/group_7.446.1121009477
+DATA/hisdb/onlinelog/group_8.447.1121009483
+DATA/hisdb/onlinelog/group_9.448.1121009489
+DATA/hisdb/onlinelog/group_10.449.1121009493
+DATA/hisdb/onlinelog/group_11.450.1121009499
+DATA/hisdb/onlinelog/group_12.451.1121009507
+DATA/hisdb/onlinelog/group_13.452.1121009507
+DATA/hisdb/onlinelog/group_14.453.112100950714 rows selected.

五、Oracle 数据库总数据量

SELECT ds.owner,SUM(ds.BYTES)/1024/1024/1024 AS TOTAL_SPACE_GB,COUNT(dt.TABLE_NAME) AS TABLE_COUNT
FROM  DBA_SEGMENTS ds JOIN  
( select * from DBA_TABLES WHERE owner NOT IN ('SYS', 'SYSTEM')AND table_name NOT LIKE 'KU$%'
)dt 
ON ds.OWNER = dt.OWNER
AND ds.SEGMENT_NAME = dt.TABLE_NAME
AND ds.SEGMENT_TYPE = 'TABLE'13  GROUP BY ds.OWNER,ds.TABLESPACE_NAME;OWNER			       TOTAL_SPACE_GB TABLE_COUNT
------------------------------ -------------- -----------
CTXSYS				   .002197266	       34
LYHIS				   11.7423706	      546
LYHIS				   3.45562744	       38
LYHIS				   .280273438	       24
LYHIS				   .000305176		2
LYHIS				   .135742188	      179
APPQOSSYS			   .000244141		4
OUTLN				   .000183105		3
LYHIS				   .271484375	       24
LYHIS				   11.1086426	      148
LYHIS				   4.84649658	      237
LYHIS				   .145263672	       51
LYHIS				   .005004883	       62
LYHIS				   .000488281		7
NEUCBUS 			   .911254883	       32
NEUODCBS			   5.32043457	      133
DMSYS				    .00012207		2
LYHIS				   .090820313		8
LYHIS				   .126953125	       10
LYHIS				   .090820313		8
LYHIS				     .2734375	       24
XDB				   .002075195	       27
MDSYS				   .018737793	      106
LYHIS				   .789428711	      125
LYHIS				       .28125	       24
INF_PLAT0			   .010375977		7
ORDDATA 			   .003540039	       52
WMSYS				   .002380371	       39
EXFSYS				   .001220703	       20
LYHIS				   .241210938	       24
LYHIS				   .290039063	       26
LYHIS				   .268676758	       26
LYHIS				   47.2315063	       27
LYHIS				   4.95300293	       97
LYHIS				   1.14849854	       37
HCB50				   .500427246	       27
NEUODBIP			    .00012207		1
NEUHDS				   .068481445	       85
NEUHDSREPORT		   .001220703	       11
SYSMAN				   .046020508	      657
SCOTT				   .000244141		4
LYHIS				    5.6416626	      232
LYHIS				   .295898438	       22
LYHIS				    .25390625	       22
LYHIS				   .000732422	       12
DBSNMP				    .00189209	       22
LYHIS				   .085632324	      109
ORDSYS				   .000305176		5
OLAPSYS 			   .006958008	      114
LYHIS				   .018371582	       27
LYHIS				   .008728027	       31
LOGMNR				   .002990723		552 rows selected.

六、数据文件总大小

SQL> select sum(bytes)/1024/1024/1024  size_GB from v$datafile;SIZE_GB
----------
747.445313

查看全文

http://www.lryc.cn/news/445401.html

【软件测试】详解测试中常用的几种测试方法

开始学习深度学习-前言

Liveweb视频汇聚平台支持GB28181转RTMP、HLS、RTSP、FLV格式播放方案

详解c++：new和delete

【深度学习】（5）--搭建卷积神经网络

边学英语边学 Java｜Synchronization in java

k8s StorageClass 存储类

3D Slicer医学图像全自动AI分割组合拳-MONAIAuto3DSeg扩展

分布式光伏的发电监控

微信小程序----日期时间选择器（自定义时间精确到分秒）

3D生成技术再创新高：VAST发布Tripo 2.0，提升AI 3D生成新高度

ONNX Runtime学习之InferenceSession模块

【TS】TypeScript内置条件类型-ReturnType

【c语言数据结构】超详细！模拟实现双向链表(初始化、销毁、头删、尾删、头插、尾插、指定位置插入与删除、查找数据、判断链表是否为空)

第十四届蓝桥杯嵌入式国赛

（k8s）kubernetes集群基于Containerd部署

python内置模块pathlib.Path类操作目录和文件

react开发环境搭建

python 逻辑语句简记

8.进销存系统（基于springboot的进销存系统）

深入理解主键回显：提升数据操作效率与准确性

springboot+阿里云物联网教程

QT Creator cmake 自定义项目结构，编译输出目录指定

lunar无第三方依赖的公历、农历、法定节假日...日历工具库

（全网最细）ELF文件详解

Leetcode面试经典150题-39.组合总和

海外云市场分析

显示和隐藏图片【JavaScript】

Java调用数据库笔记06 （修改篇）

virtualbox中的网络模式，网络设置，固定IP

从 Oracle 集群到单节点环境（详细记录一次数据迁移过程）之一：生产环境与目标服务器详情

目录

一、操作系统环境

二、Oracle 数据库基本信息（节点1）

三、数据文件信息

四、日志文件信息

五、Oracle 数据库总数据量

六、数据文件总大小

相关文章：