数据库的备份与还原

备份：

打开cmd输入：

1. sqlplus / as sysdba，回车

2. 输入：create directory  erpbak  as 'D:/erpbak';

3.输入grant read,write on directory erpbak to eadb; 回车

4.接着输入： quit;

5. 输入：expdp eadb/eadb@orcl directory=erpbak dumpfile=2017-06-01_001.dmp logfile= 2017-06-01_001.log

还原：

1. sqlplus / as sysdba，回车

2. select username,default_tablespace from dba_users where username='用户名';查询表空间

3. drop user eadb cascade;

4. drop tablespace EADBD INCLUDING CONTENTS AND DATAFILES;

5. create tablespace EADBD logging         datafile'D:\app\Administrator\oradata\orcl\EADBD01.dbf' size      1024m  autoextend on  next 100m maxsize 20480m  extent management local; 

6. create user eadb identified by eadb default tablespace EADBD;

7. grant connect,resource,dba to eadb;

8. quit; 

9.cmd控制台输入：impdp eadb/eadb@orcl schemas=eadb directory=erpbak dumpfile= erp_2017-06-01_002.dmp logfile= erp_2017-06-01_imp_001.log

无错误提示，如下：