oracle 冷备份脚本

set feedback off heading off verify off trimspool off
set pagesize 0 linesize 200
define dir='e:/sftp'
define ws='e:/ws.sql'
spool &ws
select ' host copy  '|| name || '  &dir' from v$datafile order by 1;
select ' host copy  '|| member || '  &dir' from v$logfile order by 1;
select ' host copy  '|| name || '  &dir' from v$controlfile order by 1;
select ' host copy  '|| name || '  &dir' from v$tempfile order by 1;
spool off
--shutdown immediate
@&ws
--startup