当前位置: 首页> 教育> 大学 > 网页设计入门书_项目管理软件project_找关键词_网站建设优化推广系统

网页设计入门书_项目管理软件project_找关键词_网站建设优化推广系统

时间:2025/7/10 1:27:48来源:https://blog.csdn.net/m0_37625564/article/details/143286480 浏览次数:0次
网页设计入门书_项目管理软件project_找关键词_网站建设优化推广系统

1、环境描述

在这里插入图片描述

2、DTS概述

1.支持视图、存储过程/函数、包、类、同义词、触发器等对象迁移;
2.支持数据类型的自动映射,编码转换;
3.支持根据条件自定义迁移部分数据;
4.向导式迁移步骤,上手简单;
5.支持 web 端操作、监控;
6.支持迁移评估。

3、DTS典型应用场景

1.支持全量静态数据迁移,无法实现数据增量迁移方式;
2.为保障迁移全量数据的一致性,需要充足的业务系统停机窗口;
3.迁移过程中,源端数据库不能有数据变更以及对象变更。

4、数据库调研

4.1源端Oracle数据库调研

4.1.1迁移对象统计

select a.username, (select count(1) from dba_tables b where b.owner = a.username) table_num,( SELECT COUNT(1) FROM DBA_INDEXES I WHERE UNIQUENESS = 'UNIQUE' AND OWNER =A.USERNAME OR INDEX_NAME NOT LIKE 'SYS_%' AND OWNER =A.USERNAME) index_num,(select count(distinct c.table_name)from dba_tab_partitions cwhere c.table_owner = a.username) part_num,(select count(1)from dba_tab_cols dwhere d.OWNER = a.usernameand d.DATA_TYPE like '%LOB%')  lob_num,(select sum(e.bytes) / 1024 / 1024 / 1024from dba_extents ewhere exists (select 1from dba_lobs fwhere f.owner = a.usernameand f.segment_name = e.segment_name)) lob_space,(select count(1) from dba_views g where g.OWNER = a.username) view_num,(select count(1) from dba_triggers h where h.owner = a.username) trig_num,(select count(DISTINCT I.NAME)from DBA_SOURCE IWHERE I.OWNER = A.usernameAND I.TYPE = 'FUNCTION') fun_num,(select COUNT(1)FROM DBA_SEQUENCES jWHERE j.sequence_owner = A.username) seq_num,(select count(1) from dba_synonyms where owner= A.username) syn,(select COUNT(1) FROM DBA_MVIEWS K WHERE K.owner = A.username) mv_num,(select count(DISTINCT l.NAME)from DBA_SOURCE LWHERE L.OWNER = A.usernameAND L.TYPE = 'PROCEDURE') stor_num,(select COUNT(1) FROM DBA_DB_LINKS M WHERE M.owner = A.username) dblink_num,(select max(n.DATA_LENGTH)from dba_tab_cols nwhere n.OWNER = a.username) max_length,(select SUM(O.DATA_LENGTH)from dba_tab_cols owhere o.OWNER = a.usernameand o.DATA_TYPE not like '%LOB%') max_row_widefrom dba_users a where username in ('HR');

在这里插入图片描述

4.1.2迁移数据量统计

select distinct segment_type,sum(BYTES)/1024 /1024 /1024 , COUNT(*) 
FROM DBA_SEGMENTS 
where owner = 'HR' group by segment_type order by 2 desc;

在这里插入图片描述

4.1.3字符集信息统计

SQL> SELECT value FROM NLS_Database_Parameters WHERE PARAMETER='NLS_NCHAR_CHARACTERSET';VALUE
-------------------------
AL16UTF16SQL> select userenv('language') from dual;USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.AL32UTF8

4.1.4是否已字节为单位

SQL> Show parameter NLS_LENGTH_SEMANTICS;NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_length_semantics                 string      BYTE
SQL> select PRIVILEGE from dba_sys_privs WHERE GRANTEE='HR';PRIVILEGE
----------------------------------------
CREATE DATABASE LINK
ALTER SESSION
CREATE VIEW
UNLIMITED TABLESPACE
CREATE SESSION
CREATE SEQUENCE
CREATE SYNONYM7 rows selected.

4.1.5对象权限调研

SQL> select * from dba_tab_privs WHERE GRANTEE='HR';GRANTEE         OWNER           TABLE_NAME      GRANTOR         PRIVILEGE       GRA HIE COM TYPE            INH
--------------- --------------- --------------- --------------- --------------- --- --- --- --------------- ---
HR              SYS             DBMS_STATS      SYS             EXECUTE         NO  NO  NO  PACKAGE         NO

4.1.6表空间信息调研

select ee.username,dd.* from (select aa.*, bb.file_name, cc.NEXT_EXTENTfrom (select tbs_used_info.tablespace_name,tbs_used_info.alloc_mb,tbs_used_info.used_mb,tbs_used_info.max_mb,tbs_used_info.free_of_max_mb,tbs_used_info.used_of_max || '%' used_of_max_pctfrom (select a.tablespace_name,round(a.bytes_alloc / 1024 / 1024) alloc_mb,round((a.bytes_alloc - nvl(b.bytes_free, 0)) / 1024 / 1024) used_mb,round((a.bytes_alloc - nvl(b.bytes_free, 0)) * 100 /a.maxbytes) used_of_max,round((a.maxbytes - a.bytes_alloc +nvl(b.bytes_free, 0)) / 1048576) free_of_max_mb,round(a.maxbytes / 1048576) max_mbfrom (select f.tablespace_name,sum(f.bytes) bytes_alloc,sum(decode(f.autoextensible,'YES',f.maxbytes,'NO',f.bytes)) maxbytesfrom dba_data_files fgroup by tablespace_name) a,(select f.tablespace_name, sum(f.bytes) bytes_freefrom dba_free_space fgroup by tablespace_name) bwhere a.tablespace_name = b.tablespace_name(+)) tbs_used_infoorder by tbs_used_info.used_of_max desc) aa,dba_data_files bb,dba_tablespaces ccwhere aa.tablespace_name = bb.tablespace_nameand aa.tablespace_name = cc.tablespace_name) ddright join dba_users ee on dd.tablespace_name=ee.default_tablespacewhere ee.username in ('HR');

在这里插入图片描述

select *from (select owner, tablespace_name, sum(b) KBfrom (select owner,t.segment_name,t.partition_name,round(bytes / 1024   , 2) b,tablespace_namefrom dba_segments t)where owner in ('HR')group by owner,tablespace_name);

在这里插入图片描述

4.2目标端DM数据库调研

根据实际需求安装部署相应的DM数据库版本。

5、迁移评估

[dmdba@lei2 ~]$ cd /dmdba/dmdbms/tool/
[dmdba@lei2 tool]$ export DISPLAY=192.168.0.200:0.0
[dmdba@lei2 tool]$ ./dts
Xlib:  extension "RANDR" missing on display "192.168.0.200:0.0".

在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述

6、制定迁移计划

根据待移植的 Oracle 系统信息分析的情况,制定迁移计划:先对整库进行一次性迁移,再对迁移失败的或不兼容的对象进行手动迁移。
先在目标端DM数据库创建相应的表空间、用户并赋权。

SQL> create user hr identified by hrhrhrhrhr default tablespace dmhr;
操作已执行
已用时间: 4.317(毫秒). 执行号:604.
SQL> grant resource,VTI to hr;
操作已执行
已用时间: 1.490(毫秒). 执行号:605.

7、迁移数据库

将ORACLE中的HR用户迁移至DM数据库中的HR用户。
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述

8、数据验证

8.1源端对象及数据统计

create table table_count (owner varchar(100),table_name varchar(100),cnt int);
declare
v_owner VARCHAR2(100);
v_tabname VARCHAR2(100);
stmt  VARCHAR2(200);
num_rows number;
begin
for rec in (select owner,table_name from dba_tables where owner='HR' order by 1, 2)loopselect rec.owner,rec.table_name into v_owner,v_tabname from dual;stmt := 'select count(*) from "' || v_owner || '"."' || v_tabname || '"';EXECUTE IMMEDIATE stmt INTO num_rows;  
EXECUTE IMMEDIATE 'insert into table_count values('''||v_owner||''','''||v_tabname||''','''||to_number(num_rows)||''')';end loop;
end;
/
SQL> select * from table_count;OWNER           TABLE_NAME             CNT
--------------- --------------- ----------
HR              COUNTRIES               25
HR              DEPARTMENTS             27
HR              EMPLOYEES              107
HR              JOBS                    19
HR              JOB_HISTORY             10
HR              LOCATIONS               23
HR              REGIONS                  47 rows selected.

8.2源端各对象的数量统计

SELECTA.USERNAME ,(SELECT COUNT(1) FROM DBA_TABLES B WHERE B.OWNER = A.USERNAME) table_num,( SELECT COUNT(1) FROM DBA_VIEWS G WHERE G.OWNER = A.USERNAME ) view_num,(SELECT COUNT(1) FROM DBA_MVIEWS K WHERE K.OWNER = A.USERNAME) mv_num,( SELECT COUNT(1) FROM DBA_TRIGGERS H WHERE H.OWNER = A.USERNAME ) tri_num,( SELECT COUNT(DISTINCT I.NAME) FROM DBA_SOURCE I WHERE I.OWNER = A.USERNAME AND I.TYPE = 'FUNCTION' ) fun_num,( SELECT COUNT(1) FROM DBA_SEQUENCES J WHERE J.SEQUENCE_OWNER = A.USERNAME ) seq_num,( SELECT COUNT(DISTINCT L.NAME) FROM DBA_SOURCE L WHERE L.OWNER = A.USERNAME AND L.TYPE = 'PROCEDURE' ) stor_num,( SELECT COUNT(1) FROM DBA_DB_LINKS M WHERE M.OWNER = A.USERNAME ) link_num,( SELECT COUNT(1) FROM DBA_INDEXES I WHERE UNIQUENESS = 'UNIQUE' AND OWNER =A.USERNAME OR INDEX_NAME NOT LIKE 'SYS_%' AND OWNER =A.USERNAME) idx_num,( SELECT COUNT(1) FROM DBA_OBJECTS WHERE OBJECT_TYPE='TYPE' AND OWNER =A.USERNAME ) other,( SELECT COUNT(1) FROM DBA_OBJECTS WHERE OBJECT_TYPE='PACKAGE' AND OWNER =A.USERNAME) pkg_num
FROMDBA_USERS A WHERE A.USERNAME IN ('HR');

在这里插入图片描述

8.3目标端对象及数据统计

create table table_count (owner varchar(100),table_name varchar(100),cnt int);
declare
v_owner VARCHAR2(100);
v_tabname VARCHAR2(100);
stmt  VARCHAR2(200);
num_rows number;
begin
for rec in (select owner,table_name from dba_tables where owner='HR' order by 1, 2)loopselect rec.owner,rec.table_name into v_owner,v_tabname from dual;stmt := 'select count(*) from "' || v_owner || '"."' || v_tabname || '"';EXECUTE IMMEDIATE stmt INTO num_rows;  
EXECUTE IMMEDIATE 'insert into table_count values('''||v_owner||''','''||v_tabname||''','''||to_number(num_rows)||''')';end loop;
end;
/
SQL> select * from table_count;行号     OWNER TABLE_NAME  CNT        
---------- ----- ----------- -----------
1          HR    COUNTRIES   25
2          HR    DEPARTMENTS 27
3          HR    EMPLOYEES   107
4          HR    JOBS        19
5          HR    JOB_HISTORY 10
6          HR    LOCATIONS   23
7          HR    REGIONS     47 rows got已用时间: 0.372(毫秒). 执行号:610.SQL> select * from table_count;行号     OWNER TABLE_NAME  CNT        
---------- ----- ----------- -----------
1          HR    COUNTRIES   25
2          HR    DEPARTMENTS 27
3          HR    EMPLOYEES   107
4          HR    JOBS        19
5          HR    JOB_HISTORY 10
6          HR    LOCATIONS   23
7          HR    REGIONS     47 rows got已用时间: 0.372(毫秒). 执行号:610.

8.4目标端各对象的数量统计

SELECTA.USERNAME  "用户名",(SELECT COUNT(1) FROM DBA_TABLES B WHERE B.OWNER = A.USERNAME)  "表数量",( SELECT COUNT(1) FROM DBA_VIEWS G WHERE G.OWNER = A.USERNAME )  "视图数量",( SELECT COUNT(1) FROM DBA_TRIGGERS H WHERE H.OWNER = A.USERNAME )  "触发器数量",( SELECT COUNT(DISTINCT I.NAME) FROM DBA_SOURCE I WHERE I.OWNER = A.USERNAME AND I.TYPE = 'FUNCTION' )  "函数数量",( SELECT COUNT(1) FROM DBA_SEQUENCES J WHERE J.SEQUENCE_OWNER = A.USERNAME )  "序列数量",( SELECT COUNT(DISTINCT L.NAME) FROM DBA_SOURCE L WHERE L.OWNER = A.USERNAME AND L.TYPE = 'PROCEDURE' )  "存储过程数量",( SELECT COUNT(1) FROM DBA_DB_LINKS M WHERE M.OWNER = A.USERNAME )  "DBLINK数量",( SELECT COUNT(1) FROM DBA_INDEXES I WHERE UNIQUENESS = 'UNIQUE' AND OWNER =A.USERNAME OR INDEX_NAME NOT LIKE 'INDEX335%' AND OWNER =A.USERNAME)  "索引数量",( SELECT COUNT(1) FROM DBA_OBJECTS WHERE OBJECT_TYPE='TYPE' AND OWNER =A.USERNAME OR OBJECT_TYPE='CLASS' AND OWNER =A.USERNAME )  "自定义类型",( SELECT COUNT(1) FROM DBA_OBJECTS WHERE OBJECT_TYPE='PACKAGE' AND OWNER =A.USERNAME)  "PKG数量"
FROMDBA_USERS A WHERE A.USERNAME IN ('HR');

在这里插入图片描述

9、迁移完成后续工作

9.1统计信息收集

SQL> DBMS_STATS.GATHER_SCHEMA_STATS( 'HR',100,TRUE,'FOR ALL COLUMNS SIZE AUTO');
DMSQL 过程已成功完成
已用时间: 164.834(毫秒). 执行号:612.

9.2数据库备份

迁移完成后,建议对数据库做一次全量备份。

9.3应用迁移

应用迁移、连接串修改、驱动修改等。

更多内容请参考:https://eco.dameng.com

关键字:网页设计入门书_项目管理软件project_找关键词_网站建设优化推广系统

版权声明:

本网仅为发布的内容提供存储空间,不对发表、转载的内容提供任何形式的保证。凡本网注明“来源:XXX网络”的作品,均转载自其它媒体,著作权归作者所有,商业转载请联系作者获得授权,非商业转载请注明出处。

我们尊重并感谢每一位作者,均已注明文章来源和作者。如因作品内容、版权或其它问题,请及时与我们联系,联系邮箱:809451989@qq.com,投稿邮箱:809451989@qq.com

责任编辑: