Move database from one server to other server using logical backup utility.(impdp/expdp)

 Move database from one server to other server using logical backup utility.

:- Following are the steps to move database from one to other server.

target database :-  ORCL

source  database :- DB11G


1] on Target database server.
 
:-create extra tablespace and users in target database.

SQL>create tablspace test
    datafile '/u01/app/oracle/oradata/db11g/test01.dbf' size 10G;

SQL> create tablespace test1
     datafiles '/u01/app/oracle/oradata/db11g/test11.dbf' size 10G;

SQL> select name from v$tablespace;

NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
USERS
TEMP
RAVI
TEST
TEST1
FAM
FAM1

10 rows selected.

SQL>create user test
    identified by test
    default tablespace test;

SQ> grant connect,resource to test;

SQ> create user test1
    identfied by test1
    default tablespace test1;

SQL> grant connect,resource to test1;

SQL>connect test/test

SQL>create table test(id number);

SQL>begin
      for i in 1..10 loop
      insert into test values(i);
      end loop;
     end;
/

SQL> commit;

SQL> connect test1/test1

SQL> create table test1(id number);

SQL>begin
       for i in 1..10 loop
       insert into test1 values(i);
       end loop;
       end;
  /

SQL>commit;

SQL>!

[oracle@orcl ~]$ mkdir -p /u01/expdp

[oracle@orcl ~]$exit

SQL> create directory expdp as '/u01/expdp';

SQ> exit

[oracle@orcl ~]$ expdp directory=expdp dumpfile=full1.dmp logfilename=full1.log full=y

LRM-00101: unknown parameter name 'logfilename'

[oracle@orcl ~]$ expdp directory=expdp dumpfile=full1.dmp logfile=full1.log full=y

Export: Release 11.2.0.1.0 - Production on Thu Jun 13 16:56:01 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Username: /as sysdba


2]on source database server.
  [oracle@db11gl expd]$ mkdir -p /u01/expdp

 [oracle@db11g expd]$ sqlplus

  connect sys/admin as sysdba

SQL> create directory expdp as '/u02/expdp';


:- transfer dump file target server to source server(using ftp,hard drive etc...) in perticuler directory (/u01/expdp).

SQL> !

[oracle@db11g expd]$impdp directory=expdp dumpfile=full1.dmp logfilename=full1.log full=y ignore=y

Export: Release 11.2.0.1.0 - Production on Thu Jun 13 16:56:01 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Username: /as sysdba

 NOTE:- In step 1 i created tablespace and users its not mandatory. i did this because only after you import data from dump file so after that you just  check it, both tablespace and users created on source database that means you import database process is successfully completed.