《oracle-单实例-迁移到-rac-实例----使用导出导入方法.doc》由会员分享，可在线阅读，更多相关《oracle-单实例-迁移到-rac-实例----使用导出导入方法.doc（9页珍藏版）》请在金锄头文库上搜索。
1、Oracle 单实例 迁移到 RAC 实例 - 使用导出导入方法Oracle 单实例 迁移到 RAC 实例 - 使用导出导入方法将Oracle 单实例迁移到 RAC 实例上有两种方法：1. 使用RMAN 复制2. 使用逻辑导出导入（exp/imp） 或者 数据泵（expdp/impdp）这篇演示用数据泵（expdp/impdp）将单实例迁移到RAC 环境。 导出导入schema方式来进行。逻辑导出导入相对数据泵而言，更简单一点。 这里假设RAC 环境已经搭建好了。 如果没有搭建好，可以参考我的Blog： Redhat 5.4 + ASM + RAW+ Oracle 10g RAC 安装文档ht
2、tp:/ Oracle 10g EXPDP和IMPDP使用说明http:/ 数据库逻辑备份 简单 EXP/IMP http:/ 现在本地库上创建用户Dave, 与值对应的表空间。2. 用Dave 登陆，创建相关的表。3. 将Dave用户的表空间导出4. 将dump文件导入到RAC 实例一 在本地库上创建表空间，用户SQL> select file_name from dba_data_files;FILE_NAME-D:/APP/ADMINISTRATOR/ORADATA/ORCL/USERS01.DBFD:/APP/ADMINISTRATOR/ORADATA/ORCL/UNDOTBS0
3、1.DBFD:/APP/ADMINISTRATOR/ORADATA/ORCL/SYSAUX01.DBFD:/APP/ADMINISTRATOR/ORADATA/ORCL/SYSTEM01.DBFD:/APP/ADMINISTRATOR/ORADATA/ORCL/DAVE0.DBFD:/APP/ADMINISTRATOR/ORADATA/ORCL/DBA1.DBFD:/APP/ADMINISTRATOR/ORADATA/ORCL/CATALOG1.DBFD:/APP/ADMINISTRATOR/ORADATA/ORCL/CATALOG_TS1.DBF已选择8行。SQL> create ta
4、blespace tianlesoftware datafile D:/APP/ADMINISTRATOR/ORADATA/ORCL/tianlesoftware.dbf size 50m;表空间已创建。SQL> create user dave identified by dave default tablespace tianlesoftware temporary tablespace temp;用户已创建。SQL> grant dba to dave;授权成功。SQL> grant connect to dave;授权成功。SQL> grant resource
5、 to dave;授权成功。SQL>二 用dave登陆，创建相关表SQL> create table userinfo(name varchar2(10),hometown varchar2(20);表已创建。SQL> insert into userinfo values(dave,安徽省安庆市怀宁县);已创建 1 行。SQL> commit;提交完成。SQL> insert into userinfo values(Tianle,安徽省安庆市怀宁县);已创建 1 行。SQL> commit;提交完成。SQL> select * from useri
6、nfo;NAME HOMETOWN- -dave 安徽省安庆市怀宁县Tianle 安徽省安庆市怀宁县SQL>三 用数据泵导出Dave 用户的表空间3.1 创建directory 并赋权SQL> conn / as sysdba;已连接。SQL> create directory backup as e:/tmp;目录已创建。SQL> grant read,write on directory backup to dave;授权成功。SQL> select * from dba_directories;OWNER DIRECTORY_NAME DIRECTORY_P
7、ATH- - -SYS BACKUP e:/tmp3.2 导出Dave schema - - - SCHEMA 与用户对应oraclelocalhost $ expdp dave/dave DIRECTORY=backup DUMPFILE=tianlesoftware.dmp SCHEMAS=Dave logfile=exp.log;Export: Release 10.2.0.1.0 - Production on Tuesday, 28 September, 2010 15:12:36Copyright (c) 2003, 2005, Oracle. All rights reserve
8、d.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsStarting DAVE.SYS_EXPORT_SCHEMA_01: dave/* DIRECTORY=backup DUMPFILE=tianlesoftware.dmp SCHEMAS=Dave logfile=exp.logEstimate in progress using BLOCKS method.Proces
9、sing object type SCHEMA_EXPORT/TABLE/TABLE_DATATotal estimation using BLOCKS method: 64 KBProcessing object type SCHEMA_EXPORT/USERProcessing object type SCHEMA_EXPORT/SYSTEM_GRANTProcessing object type SCHEMA_EXPORT/ROLE_GRANTProcessing object type SCHEMA_EXPORT/DEFAULT_ROLEProcessing object type S
10、CHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMAProcessing object type SCHEMA_EXPORT/TABLE/TABLEProcessing object type SCHEMA_EXPORT/TABLE/INDEX/INDEXProcessing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINTProcessing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICSProcessing object ty
11、pe SCHEMA_EXPORT/TABLE/COMMENT. . exported DAVE.USERINFO 5.25 KB 2 rowsMaster table DAVE.SYS_EXPORT_SCHEMA_01 successfully loaded/unloaded*Dump file set for DAVE.SYS_EXPORT_SCHEMA_01 is: /u01/tianlesoftware.dmpJob DAVE.SYS_EXPORT_SCHEMA_01 successfully completed at 15:13:32四 将dump 文件导入RACRAC 状态：orac
12、lerac2 bin$ crs_stat -tName Type Target State Host-ora.orcl.db application ONLINE ONLINE rac1ora.oltp.cs application ONLINE ONLINE rac2ora.cl1.srv application ONLINE ONLINE rac1ora.cl2.srv application ONLINE ONLINE rac2ora.l1.inst application ONLINE ONLINE rac1ora.l2.inst application ONLINE ONLINE r
13、ac2ora.SM1.asm application ONLINE ONLINE rac1ora.C1.lsnr application ONLINE ONLINE rac1ora.rac1.gsd application ONLINE ONLINE rac1ora.rac1.ons application ONLINE ONLINE rac1ora.rac1.vip application ONLINE ONLINE rac1ora.SM2.asm application ONLINE ONLINE rac2ora.C2.lsnr application ONLINE ONLINE rac2ora.rac2.gsd application ONLINE ONLINE rac2ora.rac2.ons application ONLINE ONLINE rac2ora.rac2.vip application ONLINE ONLINE rac24.1 创建相关用户和表空间SQL> select file_na
