生成冷備份指令碼

husthxd發表於2004-09-30

主要是複製相關資料檔案.


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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章