Oracle Data Migration

Oracle Database Migration

########################################################################################

########################################################################################

Exporting data in the Source Library (backup)

Exp Oms_lvnain01/oms_lvnain01 Owner=oms_lvnain01 File=/home/oracle/gaotest/oms_lvnain01.dmp

Exp OMS_LVNAIN02/OMS_LVNAIN02 OWNER=OMS_LVNAIN02 File=/home/oracle/gaotest/oms_lvnain02.dmp

Exp OMS_LVNAIN03/OMS_LVNAIN03 owner=oms_lvnain03 File=/home/oracle/gaotest/oms_lvnain03.dmp

Exp Portal_lvnain01/portal_lvnain01 Owner=portal_lvnain01 File=/home/oracle/gaotest/portal_lvnain01.dmp

Exp PORTAL_LVNAIN02/PORTAL_LVNAIN02 OWNER=PORTAL_LVNAIN02 File=/home/oracle/gaotest/portal_lvnain02.dmp

Exp PORTAL_LVNAIN03/PORTAL_LVNAIN03 owner=portal_lvnain03 File=/home/oracle/gaotest/portal_lvnain03.dmp

########################################################################################

########################################################################################

Transfer the exported backup data to the migrated new server

cd/home/oracle/gaotest/

Scp-p 6022./* [Email protected]:/data/oracle/gaotest/oms

CD cd/home/oracle/gaotest/

Scp-p 6022./* [Email Protected]:/data/oracle/gaotest/portal

########################################################################################

########################################################################################

Create a database table space on a new server, a user's

1.oms_lvnain01 (data file size 2G)

Create tablespace oms_lvnain01 logging datafile '/data/oracle/app/oracle/oms_lvnain01.dbf ' size 2000m autoextend on next                                          2000m MaxSize Unlimited; # #这个表结构的OMS_lvnain01. DBF is deleted by me, but memory is not changed

Create User C # #OMS_lvnain01 identified by oms_lvnain01 default Tablespace oms_lvnain01;

Grant CONNECT,RESOURCE,DBA to C # #OMS_lvnain01;

==========

#drop tablespace Oms_lvnain01;

2. OMS_LVNAIN02 (data file size 5G)

Create tablespace oms_lvnain02 logging datafile '/data/oracle/app/oradata/oms_lvnain02.dbf ' size 5000m autoextend on NEX T 5000m MaxSize Unlimited;

Create User C # #OMS_lvnain02 identified by oms_lvnain02 default Tablespace oms_lvnain02;

Grant CONNECT,RESOURCE,DBA to C # #OMS_lvnain02;

==========

3.OMS_LVNAIN03 (data file size 6G)

Create tablespace oms_lvnain03 logging datafile '/data/oracle/app/oradata/oms_lvnain03.dbf ' size 6000m autoextend on NEX T 6000m MaxSize Unlimited;

Create User C # #OMS_lvnain03 identified by oms_lvnain03 default Tablespace oms_lvnain03;

Grant CONNECT,RESOURCE,DBA to C # #OMS_lvnain03;

#drop tablespace C # #OMS_lvnain03;

==========

4.portal_lvnain01 (data file size 4G)

Create tablespace portal_lvnain01 logging datafile '/data/oracle/app/oradata/portal_lvnain01.dbf ' size 4000m Autoextend on next 4000m MaxSize Unlimited;

Create user Portal_lvnain01 identified by portal_lvnain01 default Tablespace portal_lvnain01;

Grant CONNECT,RESOURCE,DBA to Portal_lvnain01;

==========

5.PORTAL_LVNAIN02 (data file size 2G)

Create tablespace portal_lvnain02 logging datafile '/data/oracle/app/oradata/portal_lvnain02.dbf ' size 5000m Autoextend on next 5000m MaxSize Unlimited;

Create User C # #PORTAL_lvnain02 identified by portal_lvnain02 default Tablespace portal_lvnain02;

Grant CONNECT,RESOURCE,DBA to C # #PORTAL_lvnain02;

==========

6.PORTAL_LVNAIN03 (data file size 2G)

Create tablespace portal_lvnain03 logging datafile '/data/oracle/app/oradata/portal_lvnain03.dbf ' size 5000m Autoextend on next 5000m MaxSize Unlimited;

Create User C # #PORTAL_lvnain03 identified by portal_lvnain03 default Tablespace portal_lvnain03;

Grant CONNECT,RESOURCE,DBA to C # #PORTAL_lvnain03;

########################################################################################

########################################################################################

########################################################################################

########################################################################################

Import data to the new server

Imp C # #OMS_lvnain01/oms_lvnain01 fromuser=c# #OMS_lvnain01 touser=c# #OMS_lvnain01 buffer=150009081 commit=y file=/ Data/oracle/gaotest/oms/oms_lvnain01.dmp Ignore=y

Imp C # #OMS_lvnain02/oms_lvnain02 fromuser=c# #OMS_lvnain02 touser=c# #OMS_lvnain02 buffer=150009081 commit=y file=/ Data/oracle/gaotest/oms/oms_lvnain02.dmp Ignore=y

Imp C # #OMS_lvnain03/oms_lvnain03 fromuser=c# #OMS_lvnain03 touser=c# #OMS_lvnain03 buffer=150009081 commit=y file=/ Data/oracle/gaotest/oms/oms_lvnain03.dmp Ignore=y

==============================

Imp C # #PORTAL_lvnain01/portal_lvnain01 fromuser=c# #PORTAL_lvnain01 touser=c# #PORTAL_lvnain01 buffer=150009081 Commit=y file=/data/oracle/gaotest/portal/portal_lvnain01.dmp Ignore=y

Imp C # #PORTAL_lvnain02/portal_lvnain02 fromuser=c# #PORTAL_lvnain02 touser=c# #PORTAL_lvnain02 buffer=150009081 Commit=y file=/data/oracle/gaotest/portal/portal_lvnain02.dbf Ignore=y

Imp C # #PORTAL_lvnain03/portal_lvnain03 fromuser=c# #PORTAL_lvnain03 touser=c# #PORTAL_lvnain03 buffer=150009081 Commit=y file=/data/oracle/gaotest/portal/portal_lvnain03.dmp Ignore=y

This article is from the "Struggle Bar" blog, please be sure to keep this source http://lvnian.blog.51cto.com/7155281/1705276

Oracle Data Migration