热备份脚本（从一个服务器到另一个服务器）

/**** HOT Backup Script *******/
define INT_PWD =
define HOT_BACK_DIR =

/* Create Temporary Table with Tablespace Data */
drop table system.dsc_hot_stage;
create table system.dsc_hot_stage
(
tablespace_name varchar2(50),
file_name varchar2(250)
);

insert into system.dsc_hot_stage
select rtrim(tablespace_name),rtrim(file_name) from sys.dba_data_files;
commit;

/**** Set up the parameters for the spool file */
set feedback off
set heading off
set pagesize 0
set linesize 256
set verify off
set termout oN
set echo off

spool /hottobox.sql

select 'connect sys/&INT_PWD as sysdba' from dual;

select 'spool /hottobox.og' from dual;


-- Create Script to backup actual files to a directory


-- select 'host copy '||member|| ' &HOT_BACK_DIR' from v_$logfile;


select 'alter tablespace '|| tablespace_name||' begin backup;' c1,
'!scp '||file_name||' @ :' ||file_name c2,
'alter tablespace '|| tablespace_name||' end backup;' c1 from system.dsc_hot_stage;


-- Create Script to backup Control File to Trace
-- select 'alter database backup controlfile to trace;'
-- from dual;


-- select 'alter database backup controlfile to '||''''||
--                        '&CTRL_BACK_DIR'||'/ctrlDOCS'||
--                        to_char(sysdate,'MMDD')||''''||';' from dual;


select 'select distinct a.tablespace_name,b.status,b.time from dba_data_files a, v$backup b where a.file_id=b.file#;'
from dual;

select 'spool off' from dual;

select 'exit' from dual;

spool off