系统和数据迁移方案.pdf

系统和数据迁移方案
TCIS 数据库生产环境
➢ expdp 时排除 package,function,procedure 。否则在换环境部
署时，会因为过程或函数中存在 dblGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE
MANAGEMENT AUTO;
 加数据文件
alter tablespace TBS_CRM_DUSR3 add datafile
'/dev/vx/rdsk/dgjf12/data_16g_0705' size 16382M autoextend
off;
用户
 建 database linkcreate database link DBL_TO_crm630
connect to XXXXX identified by XXXXXX
using '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT =
1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = crm630) ) )';
 建目录
create directory EXPDP_MAOL as '/databak/maolong';
 建用户
crm sta
生产库 crmdb
生产目 EXPDP_MAOL
录
生产路 /databak/maol
径 ong
测试库 crm630 sta630
测试目 D0630_CRM D0630_STA
录测试路 /oradata_test /oradata_test
径 /0630/crm /0630/sta
export ORACLE_SID=crm630
expdp system/manager DIRECTORY=D0630_CRM
DUMPFILE= EXCLUDE=statistics SCHEMAS=UBAK
parallel=8 CONTENT=METADATA_ONLY LOGFILE=;
impdp linshi/lc_12345 DIRECTORY=EXPDP_MAOL
DUMPFILE= SCHEMAS=UBAK parallel=8
CONTENT=METADATA_ONLY LOGFILE=;
CREATE USER UBAK IDENTIFIED BY "123456" DEFAULT TABLESPACE
"TBS_