Oracle EXPDP logical export and machine recovery

First, Environment

Platform	Version
a linux RHEL 5.8 X64	Oracle 11.2.0.3 X64	Single Instance Oral
b win2003 X32	Oracle 11.2.0.1 X32	Single Instance Oral	Only with system-brought data files, no custom tablespace and user

Second, AMachine performs a full library export

[Email protected] ~]$ Sqlplus/nolog

Sql> Conn/as sysdba;

Sql> Create directory Dump_dir as '/u01/oracle/dmp ';

Sql> Grant Read,write on the directory Dump_dir to system;

[Email protected] ~]$ EXPDP system/oracle directory=dump_dir dumpfile=full.dmp log=full.log full=y

650) this.width=650; "title=" clip_image002 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image002 "src=" http://s3.51cto.com/wyfs02/M02/92/AB/wKioL1kBtAfTPVtmAAEEzhWtLpY763.jpg "border=" 0 "height=" 386 "/ >

[Email protected] dmp]$ pwd

/u01/oracle/dmp

[[email protected] dmp]$ ls

Export.log full.dmp

Third, Copy DMP file to B Machine

E:\app\Administrator\admin\oral\dpdump directory under

Four, Bmachine to create the same instance

Use DBCA Default Creation

Five, B machine to create the same custom Table Space

Creating the same tablespace is a prerequisite, no need to create a custom user, the user object is created automatically when importing

Create tablespace xxx datafile ' E:\app\Administrator\oradata\oral\xxx.dbf ' size 2000m autoextend on next 10m maxsize Unlim ited;

Six, B Machine Import dmp file

IMPDP system/oracle dumpfile=full.dmp full=y log=fullback.log

650) this.width=650; "title=" clip_image004 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "alt=" clip_image004 "src=" Http://s3.51cto.com/wyfs02/M00/92/AB/wKioL1kBtAuyVqUyAADex7sP0BE544.jpg "border=" 0 "height=" 260 "/>

Query Result:

Data OK

Oracle EXPDP logical export and machine recovery