记录下,以免忘记:
备份:
su - oracle -c "expdp system/oracle schemas=udb directory=d_backup parallel=2 exclude=TABLE:\"in(\'T_ATTACHMENT\')\" dumpfile=udb.dmp"
su - oracle -c "expdp system/oracle schemas=sdb directory=d_backup parallel=2 dumpfile=sdb.dmp"
还原:
su - oracle -c "impdp system/oracle schemas=udb directory=d_backup dumpfile=udb.dmp TABLE_EXISTS_ACTION=TRUNCATE "
已经有备份和还原脚本存在于开发环境。