生成冷备份脚本

主要是拷贝相关数据文件.

prompt -- created by husthxd

spool G:Backupsqlcold-backup.bat

set heading off
set feedback off
set pagesize 0

select 'copy '||
trim(name)||' G:BackupORCLcold'||
chr(10)
from v$datafile
order by name
/

select 'copy '||
trim(name)||
' G:BackupORCLcold'||
chr(10)
from v$controlfile
/

select 'copy '||
trim(member)||
' G:BackupORCLcold'||
chr(10)
from v$logfile
/

spool off