Linux oracle 数据库整体迁移或备份

expdp: sql的命令只执行一次，以后不用再执行

mkdir /home/oracle/backup

chmod 777 /home/oracle/backup

SQL> create directory EXPDIR as '/home/oracle/backup';

SQL> grant read,write on directory EXPDIR to DEEPRADAR;

SQL> execute dbms_metadata_util.load_stylesheets;

expdp system/system密码@SID schemas=xxx DUMPFILE=xxx.dmp DIRECTORY=EXPDIR logfile=expdp.log JOB_NAME=full

 

impdp: sql的命令只执行一次，以后不用再执行

如果用户名存在：drop user username cascade

 

SQL> CREATE ROLE ROLE_ORACLE;

SQL> create directory IMPDIR as '/home/oracle/backup';

SQL> grant read,write on directory IMPDIR to sys;

impdp system/system密码 directory=IMPDIR dumpfile=xxx.dmp logfile=impdp.log