Oracle备份

Oracle备份bat脚本

echo off
expdp V6_HDS_20200604/V6_HDS_20200604@ORCL schemas=V6_HDS_20200604 directory=dir_dp3 dumpfile=VADP%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%%TIME:~0,2%%TIME:~3,2%.dmp logfile=V6%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%%TIME:~0,2%%TIME:~3,2%.log
echo on

 

Oracle数据库还原脚本

1. 还原数据库Oracle 数据库
2. 打开cmd，输入 sqlplus /nolog
3.  
4. 进入控制台，输入 conn /as sysdba;以DBA角色进入
5. -- 同时删除表空间及文件
6. drop tablespace V6_HDS_20200604 including contents;
7. drop user V6_HDS_20200604 cascade ;
8. 创建用户
9. create user V6_HDS_20200614 identified by V6_HDS_20200614;
10. 创建表空间
11. create tablespace V6_HDS_20200604 datafile 'D:\oracleDataBackUP\V6_HDS_20200604.dbf' size 1500M autoextend on next 10M maxsize unlimited;-- 数据库文件地址
12. alter user V6_HDS_20200604 default tablespace V6_HDS_20200604;
13. -- 备份文件地址
14. -- create directory dir_dp3 as 'D:/oracle_bak'; 
15. Grant read,write on directory dir_dp3 to V6_HDS_20200604;
16. grant all PRIVILEGES to V6_HDS_20200604;
17.  
18. -- 在将备份文件放在'D:/oracle_bak'; 点击cmd 执行这一句
19. impdp V6_HDS_20200604/V6_HDS_20200604 DIRECTORY=dir_dp3 DUMPFILE=VADP20200530.DMP logfile=V6_HDS_20200604.log REMAP_SCHEMA=V6:V6_HDS_20200604 REMAP_TABLESPACE=V6_DATA:V6_HDS_20200604 transform=OID:N