WindowsϵÄOracleÀ䱸·Ý½Å±¾£¬ÒѾ­²âÊÔͨ¹ý

¹²ÐèÒª´´½¨Á½¸öÎļþÔÚͬһ¸öĿ¼Ï£º
Ò»£º
Îļþoracle_cool_backup.bat£¬ÄÚÈÝÈçÏ£º
Remark ¶¨Òåʱ¼äÈÕÆÚ±äÁ¿
set date=%date:~0,10%
set h=%time:~0,2%
set m=%time:~3,2%
set s=%time:~6,2%
set tempvar=%date%-%h%-%m%-%s%
md "c:/temp/%tempvar%/"
echo %tempvar%
sqlplus /nolog @oracle_cool_backup.sql %tempvar%
call oracle_cool_backup_spool.bat
pause
¶þ£ºÎļþoracle_cool_backup.sql£¬ÄÚÈÝÈçÏ£º
Remark oracle_cool_backup.sql
Remark À䱸·Ý½Å±¾
Remark ÉèÖÃSQL*Plus»·¾³±äÁ¿
conn sys/sunny as sysdba;
set feedback off heading off verify off trimspool off
set pagesize 0 linesize 200
Remark ÉèÖÃÓû§±äÁ¿
define spoolfile = 'oracle_cool_backup_spool.bat'
prompt *** spooling to &spoolfile
Remark ´´½¨°üº¬±¸·ÝÃüÁîµÄ½Å±¾Îļþ
spool &spoolfile
Remark ÏÂÃæµÄe:\temp\&1ºó±ØÐë¼Ó"\" ²»È»Ìáʾ»¹ÊÇĿ¼Ãû(F = Îļþ£¬D = Ŀ¼)?
select 'copy ' || name || ' c:\temp\&1\' from v$datafile;
select 'copy ' || name || ' c:\temp\&1\' from v$controlfile;
select 'copy ' || member || ' c:\temp\&1\' from v$logfile;
select 'copy ' || name || ' c:\temp\&1\' from v$tempfile;
spool off;
Remark ¹Ø±ÕÊý¾Ý¿â
shutdown immediate;
exit;