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

上海网络公司网站注册公司怎么注册

news 2026/4/20 19:50:39

上海网络公司网站,注册公司怎么注册,湖南邵阳调整多个风险区,百度网页大全从 Oracle 集群到单节点环境#xff08;详细记录一次数据迁移过程#xff09;之一#xff1a;生产环境与目标服务器详情目录从 Oracle 集群到单节点环境#xff08;详细记录一次数据迁移过程#xff09;之一#xff1a;生产环境与目标服务器详情一、操作系统环境二、Or…从 Oracle 集群到单节点环境详细记录一次数据迁移过程之一生产环境与目标服务器详情目录从 Oracle 集群到单节点环境详细记录一次数据迁移过程之一生产环境与目标服务器详情一、操作系统环境二、Oracle 数据库基本信息节点1三、数据文件信息四、日志文件信息五、Oracle 数据库总数据量六、数据文件总大小用户有一个双节点 Oracle 集群由于工作需要需要对生产库中的数据进行测试。基于数据安全考虑测试方提出把生产库中的数据导出然后导入一个单机测试环境进行数据测试。生产数据环境为 Oracle11g 双节点集群服务器操作系统为 Centos7.3目标服务器为单节点服务器服务器操作系统为 Centos7.5详细情况如下一、操作系统环境 # 1、生产服务器操作系统环境节点1[roothis01 bak0921]# cat /etc/redhat-release CentOS Linux release 7.3.1611 (Core)# 2、目标服务器操作系统环境 [rootnode1 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 TABLE13 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/14345241/