生成冷备份脚本

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

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/6906/viewspace-21557/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/6906/viewspace-21557/