echo.
echo ----------------------------------------------------------
echo Create the ARCDIR.sql script to create the archive
echo directories to backup into.
echo ----------------------------------------------------------
echo.
echo set heading off; >>%1\backupscript\ArcDir.sql
echo set feedback off; >>%1\backupscript\ArcDir.sql
echo set linesize 300; >>%1\backupscript\ArcDir.sql
echo spool "%1\backupscript\ArcDir.BAT"; >>%1\backupscript\ArcDir.sql
echo select 'mkdir "%1\archive\' ||dest_name|| '\" ' from v$archive_dest where status = 'VALID' order by dest_name; >>%1\backupscript\ArcDir.sql
echo spool off; >>%1\backupscript\ArcDir.sql
echo exit; >>%1\backupscript\ArcDir.sql
echo.
echo ----------------------------------------------------------
echo Create the ARC.sql script to copy the Archive_Dest1-10
echo directories used.
echo ----------------------------------------------------------
echo.
echo set heading off; >>%1\backupscript\Arc.sql
echo set feedback off; >>%1\backupscript\Arc.sql
echo set linesize 300; >>%1\backupscript\Arc.sql
echo spool "%1\backupscript\copy_Arc.BAT"; >>%1\backupscript\Arc.sql
echo select 'move "' || destination || '\*.*" "%1\archive\' ||dest_name || '" ' from v$archive_dest where status='VALID' order by dest_name; >>%1\backupscript\Arc.sql
echo spool off; >>%1\backupscript\Arc.sql
echo exit; >>%1\backupscript\Arc.sql
Partager