使用TTS实现Oracle跨版本迁移

时间:2021-08-26 22:41:51
TTS实现数据库迁移,具有速度快、支持跨平台和跨版本等优点。本文记录了用TTS从10g single迁移到11g RAC的过程。
Source数据库版本和字符集设置:
SQL> select * from v$version; BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production SQL> select * from nls_database_parameters where parameter in ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET'); PARAMETER VALUE
------------------------------ ------------------------------
NLS_CHARACTERSET UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16 Target数据库版本和字符集设置:
SQL> select * from v$version; BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production SQL> select * from nls_database_parameters where parameter in ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET'); PARAMETER VALUE
------------------------------ --------------------
NLS_CHARACTERSET AL32UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16 1、检测平台差异
source:
SQL> SELECT d.PLATFORM_NAME, ENDIAN_FORMAT
2 FROM V$TRANSPORTABLE_PLATFORM tp, V$DATABASE d
3 WHERE tp.PLATFORM_NAME = d.PLATFORM_NAME; PLATFORM_NAME ENDIAN_FORMAT
---------------------------------------- --------------
Linux x86 64-bit Little target:
SQL> SELECT d.PLATFORM_NAME, ENDIAN_FORMAT
2 FROM V$TRANSPORTABLE_PLATFORM tp, V$DATABASE d
3 WHERE tp.PLATFORM_NAME = d.PLATFORM_NAME; PLATFORM_NAME ENDIAN_FORMAT
---------------------------------------- ------------------------------------------
Linux x86 64-bit Little 两者并无差异,无需进行平台格式转换。 2、Tablespace Self-Contained 检测
进行TTS的表空间必须满足自包含条件,如果不满足,则需要进行调整直至满足才可以进行TTS。
source:
SQL> EXECUTE DBMS_TTS.TRANSPORT_SET_CHECK('tbs_postmall_data,tbs_postmall_idx', TRUE); PL/SQL procedure successfully completed. SQL> SELECT * FROM TRANSPORT_SET_VIOLATIONS; no rows selected 出现0行,说明满足自包含条件。 3、Generate a Transportable Tablespace Set
生成TTS set之前,需要设置相关的表空间为read only模式。
SQL> alter tablespace tbs_postmall_data read only; Tablespace altered. SQL> alter tablespace tbs_postmall_idx read only; Tablespace altered. 生成相关表空间的metadata dumpfile
oracle@wls112:/data/oracle/dump> expdp system dumpfile=postmall_metadata.dmp directory=dump transport_tablespaces=tbs_postmall_data,tbs_postmall_idx logfile=tts_export.log; Export: Release 10.2.0.4.0 - 64bit Production on Thursday, 14 March, 2013 10:57:34 Copyright (c) 2003, 2007, Oracle. All rights reserved.
Password: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01": system/******** dumpfile=postmall_metadata.dmp directory=dump transport_tablespaces=tbs_postmall_data,tbs_postmall_idx logfile=tts_export.log
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TRANSPORTABLE_EXPORT/INDEX
Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT
Processing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/COMMENT
Processing object type TRANSPORTABLE_EXPORT/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type TRANSPORTABLE_EXPORT/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Master table "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TRANSPORTABLE_01 is:
/data/oracle/dump/postmall_metadata.dmp
Job "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" successfully completed at 10:57:51 4、Transport the Tablespace Set
把第三步生成的metadata dumpfile和相关表空间的datafile传输到target端。其中dumpfile传输到目标端的一个directory中,datafile则传送到一个临时目录(target为ASM存储)或者目标数据库的datafile目录(target为文件系统存储)。
oracle@wls112:/data/oracle/dump> scp postmall_metadata.dmp 172.24.138.101:/data/oracle/dump/
Password:
postmall_metadata.dmp 100% 260KB 260.0KB/s 00:00
oracle@wls112:/data/oracle/dump> cd ../oradata/postmall/
oracle@wls112:/data/oracle/oradata/postmall> scp tbs_postmall_* 172.24.138.101:/data/oracle/dump/ Password:
tbs_postmall_data01.dbf 100% 5120MB 33.0MB/s 02:35
tbs_postmall_data02.dbf 100% 5120MB 28.1MB/s 03:02
tbs_postmall_idx01.dbf 100% 5120MB 25.9MB/s 03:18 5、在目标端将datafile从文件系统传输至ASM中
不能直接用asm的cp命令来进行简单的复制,而需要用RMAN中的convert datafile功能来传输datafile
oracle@postmallrac1:/data/oracle/dump> ls -l
total 15744801
-rw-r--r-- 1 oracle asmadmin 1216 2013-03-14 09:53 import.log
-rw-r----- 1 oracle oinstall 266240 2013-03-14 11:11 postmall_metadata.dmp
-rw-r----- 1 oracle oinstall 520192 2013-03-13 12:06 postmall_user.dmp
-rw-r----- 1 oracle oinstall 5368717312 2013-03-14 11:14 tbs_postmall_data01.dbf
-rw-r----- 1 oracle oinstall 5368717312 2013-03-14 11:17 tbs_postmall_data02.dbf
-rw-r----- 1 oracle oinstall 5368717312 2013-03-14 11:21 tbs_postmall_idx01.dbf
-rw-r--r-- 1 oracle asmadmin 1582 2013-03-14 09:51 tts_import.log 用RMAN进行convert datafile oracle@postmallrac1:/data/oracle/dump> rman target / Recovery Manager: Release 11.2.0.3.0 - Production on Thu Mar 14 11:26:51 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: POSTMALL (DBID=3816065011) RMAN> convert DATAFILE '/data/oracle/dump/tbs_postmall_data01.dbf'
2> db_file_name_convert="/data/oracle/dump/tbs_postmall_data01.dbf","+DATA"; Starting conversion at target at 2013-03-14 11:27:22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1155 instance=postmall1 device type=DISK
channel ORA_DISK_1: starting datafile conversion
input file name=/data/oracle/dump/tbs_postmall_data01.dbf
converted datafile=+DATA/postmall/datafile/tbs_postmall_data.274.810041245
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:02:25
Finished conversion at target at 2013-03-14 11:29:50 RMAN> convert DATAFILE '/data/oracle/dump/tbs_postmall_data02.dbf'
2> db_file_name_convert="/data/oracle/dump/tbs_postmall_data02.dbf","+DATA"; Starting conversion at target at 2013-03-14 11:30:21
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile conversion
input file name=/data/oracle/dump/tbs_postmall_data02.dbf
converted datafile=+DATA/postmall/datafile/tbs_postmall_data.275.810041421
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:02:45
Finished conversion at target at 2013-03-14 11:33:06 RMAN> convert DATAFILE '/data/oracle/dump/tbs_postmall_idx01.dbf'
2> db_file_name_convert="/data/oracle/dump/tbs_postmall_idx01.dbf","+DATA"; Starting conversion at target at 2013-03-14 12:19:58
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile conversion
input file name=/data/oracle/dump/tbs_postmall_idx01.dbf
converted datafile=+DATA/postmall/datafile/tbs_postmall_idx.273.810044399
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:02:35
Finished conversion at target at 2013-03-14 12:22:33 在asmcmd里可以看到添加进去的datafile
ASMCMD> ls -l
Type Redund Striped Time Sys Name
DATAFILE UNPROT COARSE FEB 25 15:00:00 Y EXAMPLE.264.807814653
DATAFILE UNPROT COARSE MAR 13 21:00:00 Y SYSAUX.257.807814555
DATAFILE UNPROT COARSE FEB 25 15:00:00 Y SYSTEM.256.807814555
DATAFILE UNPROT COARSE FEB 25 15:00:00 Y TBS_OGG.272.808070095
DATAFILE UNPROT COARSE MAR 14 11:00:00 Y TBS_POSTMALL_DATA.274.810041245
DATAFILE UNPROT COARSE MAR 14 11:00:00 Y TBS_POSTMALL_DATA.275.810041421
DATAFILE UNPROT COARSE MAR 14 12:00:00 Y TBS_POSTMALL_IDX.273.810044399
DATAFILE UNPROT COARSE FEB 25 15:00:00 Y TBS_ULECARD_DATA.270.807903909
DATAFILE UNPROT COARSE FEB 25 15:00:00 Y TBS_ULECARD_IDX.271.807903973
DATAFILE UNPROT COARSE FEB 25 15:00:00 Y UNDOTBS1.258.807814557
DATAFILE UNPROT COARSE MAR 13 22:00:00 Y UNDOTBS2.265.807814821
DATAFILE UNPROT COARSE FEB 25 15:00:00 Y USERS.259.807814557 6、Import the Tablespace Set
导入表空间之前,先把用户创建好。
SQL> create user postmall_user identified by postmall_pwd account unlock;
SQL> grant connect,resource,dba to postmall_user;
SQL> exit
oracle@postmallrac1:/data/oracle/dump> impdp system dumpfile=postmall_metadata.dmp directory=dump logfile=tts_import.log; Import: Release 11.2.0.3.0 - Production on Thu Mar 14 13:23:07 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01": system/******** dumpfile=postmall_metadata.dmp directory=dump transport_datafiles=+data/postmall/datafile/TBS_POSTMALL_DATA.274.810041245,+data/postmall/datafile/TBS_POSTMALL_DATA.275.810041421,+data/postmall/datafile/TBS_POSTMALL_IDX.273.810044399 logfile=tts_import.log
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TRANSPORTABLE_EXPORT/INDEX
Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT
Processing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/COMMENT
Processing object type TRANSPORTABLE_EXPORT/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type TRANSPORTABLE_EXPORT/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully completed at 13:23:43 7、导入用户的其他object
因为system表空无法进行TTS,所以postmall_user在system表空间的object,比如sequences、PL/SQL packages等就没法通过TTS来迁移。所以到了最后,还需要用Data Pump把其他object给迁移过来。
source端:
oracle@wls112:/data/oracle/dump> expdp system directory=dump schemas=postmall_user dumpfile=postmall_user.dmp; Export: Release 10.2.0.4.0 - 64bit Production on Thursday, 14 March, 2013 13:34:16 Copyright (c) 2003, 2007, Oracle. All rights reserved.
Password: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** directory=dump schemas=postmall_user exclude=table,index dumpfile=postmall_user.dmp
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
/data/oracle/dump/postmall_user.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at 13:34:35
传送到target端,在target端导入:
oracle@postmallrac1:/data/oracle/dump> impdp system dumpfile=postmall_user.dmp directory=dump logfile=user_import.log Import: Release 11.2.0.3.0 - Production on Thu Mar 14 13:36:46 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/******** dumpfile=postmall_user.dmp directory=dump logfile=user_import.log
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"POSTMALL_USER" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
ORA-39082: Object type ALTER_PROCEDURE:"POSTMALL_USER"."UPDATE_0124" created with compilation warnings
Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 2 error(s) at 13:36:57 导入的时候,出现了两个错误,第一个"ORA-31684"是因为用户已经存在了,无需再导入。第二个错误"ORA-39082"是因为有个procedure编译告警,这个procedure已经废弃,无需理会。
用户postmall_user虽然已经创建,但是还需要手动修改该用户的default tablespace为新导入的TBS_POSTMALL_DATA
SQL> alter user postmall_user default tablespace tbs_postmall_data;
User altered. 8、检验数据
source端
SQL> show user
USER is "POSTMALL_USER"
SQL> select object_name,object_type,status from user_objects; OBJECT_NAME OBJECT_TYPE STATUS
---------------------------------------- -------------------- -------
ORDER_LOTTERY TABLE VALID
PRIZE_RECORD TABLE VALID
IDX_OL_LOTTERY_TERM_END INDEX VALID
IDX_ORDER_LOTTERY_STATUS INDEX VALID
IDX_OL_LOTTERY_ONLYID_END INDEX VALID
IDX_LOTTERY_NO INDEX VALID
IDX_OL_ESCORDERID INDEX VALID
IDX_OL_USR_PHONE_TYPE INDEX VALID
PK_PRIZE_RECORD INDEX VALID
IDX_PR_MOBILE INDEX VALID
IDX_PR_UCNO INDEX VALID
IDX_PR_CREATE_DESC INDEX VALID
PK_T1 INDEX VALID
T1 TABLE VALID
UPDATE_0124 PROCEDURE INVALID
PK_ORDER_LOTTERY INDEX VALID
EMPLOYEES TABLE VALID
PK_EMPLOYEES INDEX VALID
IDX_EMPLOYEES_EMAIL INDEX VALID
CREATE_INDEX_CCLR PROCEDURE VALID 20 rows selected. SQL> select count(*) from ORDER_LOTTERY; COUNT(*)
----------
33330240 SQL> select count(*) from PRIZE_RECORD; COUNT(*)
----------
111660 SQL> select count(*) from T1; COUNT(*)
----------
2549760 SQL> select count(*) from employees; COUNT(*)
----------
123 SQL> select EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL FROM EMPLOYEES WHERE EMPLOYEE_ID<=10; EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL
----------- -------------------- ------------------------- -------------------------
1 杰森 伯恩 124@gmail.com
2 勒布朗 詹姆斯 124@gmail.com
3 科比 布莱恩特 124@gmail.com
4 沙克 奥尼尔 124@gmail.com
5 蒂姆 邓肯 124@gmail.com
6 迈克尔 乔丹 124@gmail.com
7 摩西 马龙 124@gmail.com
8 乔治 布什 124@gmail.com
9 hello baby 124@gmail.com
10 jay 刘杰 124@gmail.com 10 rows selected.
target端:
SQL> show user
USER is "POSTMALL_USER"
SQL> select object_name,object_type,status from user_objects; OBJECT_NAME OBJECT_TYPE STATUS
---------------------------------------- -------------------- ---------------------
UPDATE_0124 PROCEDURE INVALID
CREATE_INDEX_CCLR PROCEDURE VALID
IDX_PR_CREATE_DESC INDEX VALID
PK_T1 INDEX VALID
IDX_EMPLOYEES_EMAIL INDEX VALID
PK_EMPLOYEES INDEX VALID
IDX_PR_UCNO INDEX VALID
IDX_PR_MOBILE INDEX VALID
PK_PRIZE_RECORD INDEX VALID
IDX_OL_USR_PHONE_TYPE INDEX VALID
IDX_OL_ESCORDERID INDEX VALID
IDX_LOTTERY_NO INDEX VALID
IDX_OL_LOTTERY_ONLYID_END INDEX VALID
IDX_ORDER_LOTTERY_STATUS INDEX VALID
IDX_OL_LOTTERY_TERM_END INDEX VALID
PK_ORDER_LOTTERY INDEX VALID
T1 TABLE VALID
EMPLOYEES TABLE VALID
PRIZE_RECORD TABLE VALID
ORDER_LOTTERY TABLE VALID 20 rows selected. SQL> select count(*) from ORDER_LOTTERY; COUNT(*)
----------
33330240 SQL> select count(*) from PRIZE_RECORD; COUNT(*)
----------
111660 SQL> select count(*) from T1; COUNT(*)
----------
2549760 SQL> select count(*) from employees; COUNT(*)
----------
123 SQL> select EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL FROM EMPLOYEES WHERE EMPLOYEE_ID<=10; EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL
----------- ---------- ---------- ---------------
1 杰森 伯恩 124@gmail.com
2 勒布朗 詹姆斯 124@gmail.com
3 科比 布莱恩特 124@gmail.com
4 沙克 奥尼尔 124@gmail.com
5 蒂姆 邓肯 124@gmail.com
6 迈克尔 乔丹 124@gmail.com
7 摩西 马龙 124@gmail.com
8 乔治 布什 124@gmail.com
9 hello baby 124@gmail.com
10 jay 刘杰 124@gmail.com 10 rows selected. 数据均一致,中文也没有出现乱码。数据库迁移成功。 小结:
一、两边数据库的字符集(包括NLS_CHARACTERSET和NLS_NCHAR_CHARACTERSET)最好完全一样,如果不一样,也要保证source端的字符集是target端的字符集的真子集,还要加上一些限制,具体可以参考官方文档的说明。
二、在source端生成和传送TTS Set之前必须要设置相关表空间为read only模式。
三、如果从filesystem→filesystem,直接把datafile传输到目标数据库的datafile路径即可。如果从filesystem→asm,则需要多一RMAN的convert datafile操作。如果是asm→asm则还没进行测试。
---------------------
作者:jasonliu_2012
来源:CSDN
原文:https://blog.csdn.net/jasonliu_2012/article/details/8688209
版权声明:本文为博主原创文章,转载请附上博文链接!

使用TTS实现Oracle跨版本迁移的更多相关文章

  1. 跨平台版本迁移之 XTTS 方案操作指南

    本文转自 https://blog.csdn.net/Enmotech/article/details/80045576 作者 | 罗贵林: 云和恩墨技术工程师,具有8年以上的 Oracle 数据库工 ...

  2. 数据库周刊31丨openGauss 正式开源;7月数据库排行榜发布;浙江移动国产数据库AntDB迁移;oracle ADG跨版本搭建;PG解决社保问题;mysqlbinlog解析……

    摘要:墨天轮数据库周刊第31期发布啦,每周1次推送本周数据库相关热门资讯.精选文章.干货文档. 热门资讯 1.openGauss 正式开源,华为公开发布源代码[摘要]6月1日,华为正式宣布开源数据库能 ...

  3. 【RMAN】RMAN跨版本恢复&lpar;下&rpar;--大版本异机恢复

    [RMAN]RMAN跨版本恢复(下)--大版本异机恢复 BLOG文档结构图 ORACLE_SID=ORA1024G 关于10g的跨小版本恢复参考:http://blog.chinaunix.net/u ...

  4. Oracle数据逻辑迁移综合实战篇

    本文适合迁移大量表和数据的复杂需求. 如果你的需求只是简单的迁移少量表,可直接参考这两篇文章即可完成需求: Oracle简单常用的数据泵导出导入(expdp/impdp)命令举例(上) Oracle简 ...

  5. 高版本-&gt&semi;低版本迁移,低版本客户端连接高版本数据库EXP导出报错EXP-00008&comma;ORA-01455&comma;EXP-00000

    生产环境: 源数据库:RHEL + Oracle 11.2.0.3 目标数据库:HP-UX + Oracle 10.2.0.4   需求:迁移部分表  11.2.0.3-->10.2.0.4,若 ...

  6. 使用ADMT和PES实现window AD账户跨域迁移-介绍篇

    使用 ADMT 和 pwdmig 实现 window AD 账户跨域迁移系列: 介绍篇 ADMT 安装 PES 的安装 ADMT:迁移组 ADMT:迁移用户 ADMT:计算机迁移 ADMT:报告生成 ...

  7. Oracle冷备迁移脚本&lpar;文件系统&rpar;

    Oracle冷备迁移脚本(文件系统) 两个脚本: 配置文件生成脚本dbinfo.sh 网络拷贝到目标服务器的脚本cpdb16.sh 1. 配置文件生成脚本 #!/bin/bash #Usage: cr ...

  8. 如何查看Oracle客户端版本

    在实际工作中,总会遇到一些需要查看.验证ORACLE客户端版本的问题,因为一台服务器可能装了多个Oracle客户端版本:也有可能你需要知道安装的版本是32位还是64位的.如何查看Oracle客户端(O ...

  9. FMDB 版本迁移

    FMDB 版本迁移 安装 1. 通过CocoaPods 在项目根目录创建并编辑 Podfile 内容如下 $ cd /path/to/MyProject $ touch Podfile $ edit ...

随机推荐

  1. 两种JavaScript的AES加密方式(可与Java相互加解密)

    由于JavaScript属于弱类型脚本语言,因此当其与强类型的后台语言进行数据交互时会产生各种问题,特别是加解密的操作.本人由于工作中遇到用js与Java进行相互加解密的问题,在网上查了很多资料及代码 ...

  2. 第15章 &period;NET中的反射

    using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.R ...

  3. java String部分源码解析

    String类型的成员变量 /** String的属性值 */ private final char value[]; /** The offset is the first index of the ...

  4. 小议 js 下字符串比较大小

    原文:小议 js 下字符串比较大小 之前群里有人问如何比较两个时间大小,他的时间格式是 2014-08-08 而不是 2014-8-8.所以我给的方法是 直接比较,如: var a = "2 ...

  5. Android 执行 adb shell 命令

    Android 执行Adb shell 命令大多需要root权限,Android自带的Runtime. getRuntime().exec()容易出错,在网上找到了一个执行adb shell命令的类 ...

  6. oracle相同SID对外提供多个service&lowbar;names

    为数据库设置多个服务名(通过SCOPE=both设置,同时修改参数文件) SQL> show parameter service_names; NAME TYPE VALUE --------- ...

  7. kettel的stream lookup报错

    kettel的stream lookup报错: you can't use the 'integer-pair' algorithm when you have more than one key o ...

  8. char&ast; 与 string 互转

    因为c#强调安全性,每次意图将string的地址赋给指针时,系统都要报错,原因是系统无法计算字符串的空间和地址,这里不多bb,使用IntPtr类(using Runtime.InteropServic ...

  9. ResultHandler的用法

    ResultHandler,顾名思义,对返回的结果进行处理,最终得到自己想要的数据格式或类型.也就是说,可以自定义返回类型.下面通过一个例子讲解它的使用方法: 创建Goods实体类: public c ...

  10. tp3&period;2sql改变时间格式

    tp3.2sql改变时间格式2018-05-10取05-10 $listIn=D('api_article as a')->field('date_format( fabutime,\'%m-% ...