1. expdp导出
set line 150
col owner formata10
coldirectory_name format a30
coldirectory_path format a60
select owner,directory_name,directory_path fromsys.dba_directories;
create directorydpdir as '/backup/dpdir';
grant read,write on directory dpdir to public;
#expdp_schemas.sh
exportEXPDPPATH=/backup/dpdir
exportORACLE_SID=prdspjz
exportEXPDPFILE=expdp_"$ORACLE_SID"_schemas
datafile="$EXPDPFILE"_`date'+%Y%m%d'_%H%M%S`_%U.dmp
logfile="$EXPDPFILE"_`date'+%Y%m%d'_%H%M%S`.log
# For RACDB
timeexpdp system/oracle@"$INSTANCE_NAME" cluster=n directory=dpdirExclude=Statistics Compression=All dumpfile=$datafile logfile=$logfilefilesize=10G parallel=5 full=y
# ForSingle DB
timeexpdp \'/ as sysdba\' directory=dpdir Exclude=Statistics Compression=Alldumpfile=$datafile logfile=$logfile filesize=10G parallel=5schemas=HTFA,HTFA_HIS
2. impdp
set line 150
col owner formata10
coldirectory_name format a30
coldirectory_path format a60
select owner,directory_name,directory_path fromsys.dba_directories;
create directorydpdir as '/backup/dpdir';
grant read,write on directory dpdir to public;
#expdp_schemas.sh
exportEXPDPPATH=/backup/dpdir
exportORACLE_SID=prdspjz
exportEXPDPFILE=expdp_"$ORACLE_SID"_schemas
datafile="$EXPDPFILE"_`date'+%Y%m%d'_%H%M%S`_%U.dmp
logfile="$EXPDPFILE"_`date'+%Y%m%d'_%H%M%S`.log
impdpsystem/manager directory=dpdir logfile=$logfile network_link=<linkname>remap_schema=source_schema:destination_schema schema=source_schema EXCLUDE=statisticsinclude=index TABLE_EXISTS_ACTION=truncate content=metadata_only REMAP_TABLESPACE=HKHK:AUAUREMAP_TABLESPACE=HKHKIDX:AUAU dumpfile=$datafile
查看alert日志
impdp \'/ as sysdba\' attach=SUBTA.SYS_IMPORT_SCHEMA_01