ORACLE备份库方法

Oracle备份dmp文件
一、PLSQL下执行下面语句备份：
注意：
A、 'IN(''CHY'')' 中的CHY为PLSQL登陆的用户名，待备份的用户，注意大小写
B、filename => 'CHYDB.DMP'中的CHYDB是指定的备份出的dmp文件名称，注意用大写。

declare
h1 NUMBER;
l1 varchar2(20);
begin
h1 := dbms_datapump.open (operation => 'EXPORT', job_mode => 'SCHEMA', job_name => 'JOB_EXP1', version => 'COMPATIBLE');
dbms_datapump.set_parallel(handle => h1, degree => 1);
dbms_datapump.add_file(handle => h1, filename => 'EXPDAT.LOG', directory => 'DATA_PUMP_DIR', filetype => 3);
dbms_datapump.set_parameter(handle => h1, name => 'KEEP_MASTER', value => 0);
dbms_datapump.metadata_filter(handle => h1, name => 'SCHEMA_EXPR', value => 'IN(''CHY'')');
dbms_datapump.add_file(handle => h1, filename => 'CHYDB.DMP', directory => 'DATA_PUMP_DIR', filetype => 1);
dbms_datapump.set_parameter(handle => h1, name => 'INCLUDE_METADATA', value => 1);
dbms_datapump.set_parameter(handle => h1, name => 'DATA_ACCESS_METHOD', value => 'AUTOMATIC');
dbms_datapump.set_parameter(handle => h1, name => 'ESTIMATE', value => 'BLOCKS');
dbms_datapump.start_job(handle => h1, skip_current => 0, abort_step => 0);
dbms_datapump.wait_for_job(handle => h1, job_state => l1);
dbms_datapump.detach(handle => h1);
end;

二、待plsql中执行完成，从下面查询获取备份文件的路径，dmp文件就是备份文件，目录下还有日志
SELECT directory_path FROM dba_directories WHERE directory_name='DATA_PUMP_DIR';