Oracle数据备份与还原笔记

一、备份shr数据库

1.创建directory目录用于数据库备份还原，也可以不创建使用已有的directory目录

create or replace directory DMPDIR as  '/home/easbak'; 

select * from dba_directories;

2.赋权 directory目录

grant read,write on directory DMPDIR to eas86;

3.导出数据库备份

expdp eas86/eas86@orcl directory=DMPDIR schemas=eas86 dumpfile=eas_zs_20230320.dmp EXCLUDE=STATISTICS 

二、还原shr数据库

1.创建新数据库表空间

create tablespace EAS_D_SHR0320_STANDARD datafile '/home/oracle/easdata/EAS_D_SHR0320_STANDARD.dbf' size 2000m autoextend on next 200m maxsize unlimited;

create tablespace EAS_D_SHR0320_INDEX datafile '/home/oracle/easdata/EAS_D_SHR0320_INDEX.dbf' size 200m autoextend on next 50m maxsize unlimited;

create tablespace EAS_D_SHR0320_TEMP  datafile '/home/oracle/easdata/EAS_D_SHR0320_TEMP.dbf' size 200m autoextend on next 50m maxsize unlimited;

create temporary tablespace EAS_T_SHR0320_STANDARD tempfile '/home/oracle/easdata/EAS_T_SHR0320_STANDARD.dbf' size 100m autoextend on next 50m maxsize unlimited;

2.创建新的用户并指定默认表空间

create user SHR0320 identified by SHR0320 default tablespace EAS_D_SHR0320_STANDARD temporary tablespace EAS_T_SHR0320_STANDARD profile default account unlock;

3.授权新用户

Grant create session, create table, create procedure, create v