Back up and introduce ORA database (ERP clone) RedHat 5.5 + Oracle 11g (64bit)

SetWholeKingdeeEAS DatabaseMove to another environment for development and testing:

BackupOracle Database: (you can also PL-SQL through external tools)

[Oracle @ rcno8 ~] $Sqlplus

SQL * Plus: Release 11.2.0.1.0 Production on Tue Nov 23 10:58:56 2010

Copyright (c) 1982,200 9, Oracle. All rights reserved.

Enter user-name:Conn/as sysdba

Enter password:

Connected:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

Run the following command in the database:

Create directory kdbak as '/EASData/easbak'

InReadhatRun:(BackupRc0819Database)

Expdp system/kingdee @ // 127.0.0.1: 1521/orcl schemas = rc0819 directory = kdbak dumpfile = rc0819_20100928.dmp logfile = rc0819_20100928.log job_name = Login

++

Introduce backup in another environmentOracle Database (Clone the ERP system ):

Run the following command in the database:

SQL>

Create tablespace "EAS_D_RCTEST20101123_STANDARD" datafile '/oradata/EAS_D_RCTEST20101123_STANDARD.ORA 'size 2000 M;

Alter database datafile '/oradata/EAS_D_RCTEST20101123_STANDARD.ORA' autoextend on;

Create temporary tablespace "EAS_T_RCTEST20101123_STANDARD" tempfile '/oradata/EAS_T_RCTEST20101123_STANDARD.ORA 'size 500 M;

Alter database tempfile '/oradata/EAS_T_RCTEST20101123_STANDARD.ORA' autoextend on;

Create user RCTEST20101123 identified by kingdee default tablespace EAS_D_RCTEST20101123_STANDARD temporary tablespace EAS_T_RCTEST20101123_STANDARD;

Grant dba to RCTEST20101123;

InReadhatRun the following command: (introduce database files)

Impdp system/kingdee @ // 127.0.0.1: 1521/orcl directory = kdbak dumpfile = export logfile = export remap_schema = rc0819: RCTEST20101123 remap_tablespace = partition: partition, partition: Export job_name = partition;