–oracle传统方式备份exp/imp
1. deferred_segment_creation 参数设置true 默认空表无法导出。需要设置false。
exp ecard/ecard@orcl file=d:\2023106.dmp log=d:\20231206.txt direct=y recordlength=65535
imp ecard/ecard@orcl file=d:\2023106.dmp log=d:\20231206imp.txt buffer=102400000
–管理员方式登录,新建表空间和用户,并建立文件夹映射路径并授权
``
CREATE DIRECTORY directory_name AS ‘path_to_directory’;
grant read,write on directory directory to backup
**
—数据泵EXPDP多线程备份数据库脚本–dblink–可以修改为命令行
@echo off
set curdate=%date:~0,4%%date:~5,2%%dat