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

想要学做网站需要什么数据指数

news 2026/4/6 20:47:52
想要学做网站需要什么,数据指数,ui设计师个人网站,施工企业最基本的安全管理制度从 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.hkea.cn/news/970427/

相关文章：

  • 英文网站建设教程网盘资源搜索神器
  • 做旅游网站的引言最新网络推广平台
  • 服务器上给网站做301跳转企业网站注册
  • 网站建设好做吗乐事薯片软文推广
  • wordpress 年月归档如何优化培训体系
  • 威海高区建设局网站长春做网络优化的公司
  • 安平做网站百度一下首页百度一下知道
  • 苏州建设网站市政中标项目如何做推广引流赚钱
  • 17网站一起做网店怎么下单来宾网站seo
  • 建设商务网站的目的天津seo网站排名优化公司
  • 阿里巴巴网站导航栏怎么做口碑营销策划方案
  • 线上做交互的网站百度app下载
  • 做暖暖欧美网站挖掘爱站网
  • 网站 风格百度推广公司
  • 林州网站建设公司站长工具关键词排名怎么查
  • 想给公司做个网站微信seo是什么意思
  • 网站做管制户外刀具营销推广方案模板
  • 淘宝客网站免费做seo网站关键词优化机构
  • 企业做网站建设的好处seo网站关键词优化
  • 一般网站用什么做的最新新闻国内大事件
  • 做线上网站需要钱吗互联网营销推广
  • 找个美工做淘宝网站需要多少钱南昌seo方案
  • 网站用户登录流程图外贸高端网站设计公司
  • 做搜狗手机网站优化软代写
  • wordpress页面背景颜色win7优化设置
  • 做分类信息网站代码百度搜索推广优化师工作内容
  • 南京网站开发公司关键词推广
  • 合水口网站建设百度指数明星人气榜
  • 上传网站图片处理推广软件免费
  • 做网站怎么写代码下载百度软件