批量热备脚本
批量热备脚本:
select 'alter tablespace '||tablespace_name||' begin backup;'||chr(10)||
'host cp'||file_name||'/backup'||chr(10)||'alter tablespace'||' ' || tablespace_name||' '
||'end backup;' from dba_data_files order by tablespace_name;