oracle备份恢复 expdb/impdb

1.创建实验数据

create tablespace test datafile '/data/u01/app/oracle/oradata/orcl/test01.dbf' size 10M autoextend off;
create user wj identified by test default tablespace test;
grant dba to wj;
conn wj/test
create table test01 (id number(3), name varcher2(10));
insert into test01 valuses(1,'test01');
insert into test01 valuses(2,'test02');
insert into test01 valuses(3,'test03');

2.使用expdb备份整个库

mkdir /opt/oracle/dump 
create directory dump_dir as '/opt/oracle/dump';
grant read,write on directory dump_dir to system;
expdp system/123 directory=dump_dir dumpfile=full_expdb.dmp  full=y  parallel=2

3.模拟破坏

drop user wj cascade;
drop tablespace test including contents and datafiles;

4.恢复

创建数据库，在创建表空间
create tablespace test datafile '/data/u01/app/oracle/oradata/orcl/test01.dbf' size 10M autoextend off;
配置dirctory
create directory dump_dir as '/opt/oracle/dump';
grant read,write on directory dump_dir to system;
impdp system/123 directory=dump_dir dumpfile=full_expdb.dmp  full=y  parallel=2
编译无效对象
@$ORACLE_HOEM/rdbms/admin/utlrp.sql