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

北京网站建设公司网站优化什么软件做网站最好

news 2025/9/16 19:15:26
北京网站建设公司网站优化,什么软件做网站最好,wordpress编辑留言板,做综合医院网站从 Oracle 集群到单节点环境（详细记录一次数据迁移过程）之一：生产环境与目标服务器详情 目录 从 Oracle 集群到单节点环境（详细记录一次数据迁移过程）之一：生产环境与目标服务器详情一、操作系统环境二、Or…

从 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.yayakq.cn/news/327944/

相关文章：

  • 大连网站开发培训wordpress chinese-username插件
  • 网络编辑网站seo优化是什么意思
  • 福田网站 建设深圳信科晋城做网站
  • 舟山普陀区建设信息网站wordpress无法添加媒体
  • 网站每年多少钱网站服务器租用
  • 武威做网站的工业设计手绘
  • 西安seo站内优化高铁建设官方网站
  • 网站做第三方登录界面wordpress增加访问量
  • 网站受到攻击怎么办佛山抖音seo
  • 深圳网站制作小说网站做编辑器
  • 科学数据分析网站html5仪征市建设工程网站
  • 别人公司网站进不去百度搜索引擎优化指南最新版
  • 成都 网站个人网站怎么命名
  • 如何选择免费网站建设1 高端品牌网站定制
  • 佛山网站建设运营政协网站建设功能
  • 哪里有建设网站wordpress去掉顶部空白
  • 专业网站建设电话wordpress 如何升级
  • 宁夏电力建设工程公司门户网站设计本科
  • 如何用word做简单的网站少儿编程课网课免费
  • 网站建设要注意个人网站收款问题
  • 天成信息网站建设自助建站平台网页制作自学
  • 需要企业网站建设莆田有哪几家做网站设计
  • wordpress h1标签外贸工厂网站做seo多吗
  • 项目网站如何做到精准客户推广
  • 网址导航网站怎样做flash 网站模板
  • 艾纳网站建设上海自贸区注册公司优惠政策
  • 网站的域名分为哪些手机做任务网站有哪些
  • 上海网站排名提升杭州网站维护公司
  • 网站地图 wordpresswordpress全端美化
  • 互联网站建设中国中小企业网官方网站