Oracle 热备份脚本

只备份了控制文件和数据文件（临时文件除外）

文件hot_backup.sql：

define backup_dest='/oracle/oradata/DG/backup/user_hot'
set serveroutput on

set linesize 200
set head off
set feedback off
set verify off
spool /tmp/hot.sql
begin
      for rec_ts in (select tablespace_name from dba_tablespaces where contents!='TEMPORARY') loop
         dbms_output.put_line('alter tablespace '||rec_ts.tablespace_name||' begin backup;');
                    for rec_df in (select file_name from dba_data_files where tablespace_name=rec_ts.tablespace_name) loop
                            dbms_output.put_line('! cp '||rec_df.file_name ||' &backup_dest');
                    end loop;
         dbms_output.put_line('alter tablespace '||rec_ts.tablespace_name||' end backup;');
      end loop;
      dbms_output.put_line('alter database backup controlfile to &backup_dest/control_backup.ctl');
end;
/


spool off
set verify on
set head on
set feedback on

undefine backup_dest

@/tmp/hot.sql