逻辑备份
expdp 备份
查看当前容器并切换到正确的数据库
SQL> show con_name;
CON_NAME
------------------------------
CDB$ROOT
SQL> alter session set container=pdb01;
创建directory目录并对数据库用户该目录的赋权
SQL> create or replace directory dumpdir as '/home/oracle/dump';
SQL> grant read,write on directory dumpdir to v8xuser;
切换到oracle用户linux命令行
[oracle@node01 ~]$ expdp v8xuser/ceshi123456@172.10.10.12/pdb01 directory=dumpdir schemas=v8xuser dumpfile=v8xgroupceshi.dmp logfile=ceshi.log
impdp 还原
第一种数据库存在表的情况下还原
impdp v8xuser/ceshi123456@172.10.10.12/pdb01 remap_schema=v8xuser:v8xuser remap_tablespace=v8:v8 directory=dumpdir dumpfile=v8xgroupceshi.dmp content=all logfile=ceshi.log TABLE_EXISTS_ACTION=replace
第二种就是还原到干净的数据库环境当中
删除表空间以及数据文件
SQL> DROP TABLESPACE v8 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
删除用户并清空数据
SQL> DROP user V8XUSER CASCADE;
impdp v8xuser/ceshi123456@172.10.10.12/pdb02 remap_schema=v8xuser:v8xuser remap_tablespace=v8:v8 directory=dumpdir dumpfile=v8xgroupceshi.dmp content=all logfile=ceshi.log