推荐使用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
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/6906/viewspace-21558/ ，如需转载，请注明出处，否则将追究法律责任。
