1，备份脚本

#!/bin/bash
export ORACLE_BASE=/home/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=orcl
export PATH=$PATH:$ORACLE_HOME/bin

export EAS_DATA_DIR=/home/oraclebak
export EAS_LOGS_DIR=/home/oraclebak
export EASBAKUPTIME=EAS_`date +%Y%m%d%H%M%S`

#find /home/oraclebak -name EAS_”*.dmp” -type f -mtime +10 -exec rm -rf {} \; > /dev/null 2>&1

echo “Starting bakup…”
echo “Bakup file path $EASBAKUPTIME.dmp”
expdp eas/kingdee2020 schemas=eas directory=easbackupdir dumpfile=$EASBAKUPTIME.dmp logfile=$EASBAKUPTIME.log

#删除10天之前的备份.log .dmp

find /home/oraclebak -name EAS_”*.dmp” -type f -mtime +10 -exec rm -rf {} \; > /dev/null 2>&1

find /home/oraclebak -name EAS_”*.log” -type f -mtime +10 -exec rm -rf {} \; > /dev/null 2>&1

echo “Bakup completed.”

2、还原

create tablespace EAS_D_KINGDEE_STANDARD
logging
datafile ‘/home/oracle/EAS_D_KINGDEE_STANDARD.dbf’
size 2000m
autoextend on
next 50m maxsize unlimited
extent management local;

create tablespace EAS_D_KINGDEE_TEMP2
logging
datafile ‘/home/oracle/EAS_D_KINGDEE_TEMP2.dbf’
size 2000m
autoextend on
next 50m maxsize unlimited
extent management local;

Create temporary tablespace EAS_T_KINGDEE_STANDARD
tempfile ‘/home/oracle/EAS_T_KINGDEE_STANDARD.dbf’
size 500m
autoextend on
next 50m maxsize unlimited
extent management local;

Create tablespace EAS_D_KINGDEE_INDEX
logging
datafile ‘/home/oracle/EAS_D_KINGDEE_INDEX.dbf’
size 500M
autoextend on
next 50m maxsize unlimited
extent management local;

CREATE USER kingdee IDENTIFIED BY kingdee DEFAULT TABLESPACE EAS_D_KINGDEE_STANDARD TEMPORARY TABLESPACE EAS_T_KINGDEE_STANDARD ACCOUNT UNLOCK;

create or replace directory dir as ‘/home/oraclebackup’;

grant dba to kingdee;

grant READ,WRITE ON DIRECTORY DIR TO kingdee;

impdp kingdee/kingdee@orcl directory=dir dumpfile=EAS_20210826020001.dmp logfile=EAS_20210826020001.log remap_schema=EAS:kingdee remap_tablespace=EAS_D_EAS_INDEX:EAS_D_KINGDEE_INDEX,EAS_D_EAS_STANDARD:EAS_D_KINGDEE_STANDARD,EAS_D_EAS_TEMP2:EAS_D_KINGDEE_TEMP2,EAS_T_EAS_STANDARD:EAS_T_KINGDEE_STANDARD