主要是拷贝相关数据文件.
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/，如需转载，请注明出处，否则将追究法律责任。
下一篇：
生成热备份脚本
请登录后发表评论
登录
全部评论
