生成熱備份指令碼

推薦使用rman做熱備份.安全方便快捷.

-- created by husthxd

spool G:Backupsqlhot-backup.sql

set heading off
set feedback off
set pagesize 0

prompt -- produce a hot-backup script
prompt -- backup data files
select 'alter tablespace '||
trim(t1.name)||
' begin backup;'||
chr(10)||
'host copy '||
t2.name||' G:BackupORCLHot'||
chr(10)||
'alter tablespace '||
trim(t1.name)||
' end backup;'||
chr(10)
from v$tablespace t1,v$datafile t2
where t1.ts# = t2.ts#
order by t1.name
/

prompt -- backup control file
select 'alter database backup controlfile to trace;'||chr(10)
from dual;
/

spool off