主要是拷贝相关数据文件.
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/