Re: Off-line backup in Windows NT/2K

Dear all,

In addition, if I want to keep the last n (say 3) copies of backup files, it is also difficult in Windows NT/2K.

Dino

On 2 Aug 2001 06:29:49 -0700, ordabber_at_my-deja.com (Bart) wrote:

>Dino,
>
>As far as I know - one can correct me if I am wrong - it is not
>possibile in NT to read input (with ENTERS etc.) like you can do in
>UNIX. The script you made with calling SQLPLUS @filename.sql is the
>only alternative.
>
>If you prefer Unix tools, you can always try to use their ports to NT
>as you can find them for instance at the following link :
>http://www.weihenstephan.de/~syring/win32/UnxUtils.html.
>There is also a link to ZSH-shell for Win32.
>
>I Hope this will help you.
>
>Kind regards,
>
>Bart.
>
>Dino Hsu <dino1_nospam_at_ms1.hinet.net> wrote in message news:<cs8hmtk62kkbqkh7d6cva033ltfk7v211r_at_4ax.com>...
>> Dear all,
>>
>> I have written scripts to do off-line backup of a database as follows:
>>
>> <backup_twdm.bat begin>
>> @ECHO OFF
>> IF "%1"=="" GOTO ERROR
>> SET ORACLE_SID=TWDM
>> svrmgrl @shutdown_twdm.sql
>> "c:\program files\winzip\wzzip" -rP d:\twdm.bak\twdm_%1 d:\twdm
>> svrmgrl @startup_twdm.sql
>> GOTO END
>> :ERROR
>> ECHO Usage backup_twdm.bat yyyymmdd
>> GOTO END
>> :END
>> <backup_twdm.bat end>
>>
>> <startup_twdm.sql begin>
>> connect internal;
>> startup pfile=d:\twdm\ctlfile\inittwdm.ora;
>> <startup_twdm.sql end>
>>
>> <shutdown_twdm.sql begin>
>> connect internal;
>> shutdown immediate;
>> <shutdown_twdm.sql end>
>>
>> Among which wzzip.exe is the command-line add-on of WINZIP 8.0. With
>> the help from a compression program such as WINZIP, the size of the
>> backup can be dramatically decreased to about only 1/20 and makes
>> backup process much easier.
>>
>> There are some issues here, however, to be discussed about:
>> 1.I used to see a script in AIX like this:
>> svrmgrl <<EOF
>> cmd-1...
>> cmd-2...
>> cmd-3...
>> EOF
>> which embeds SQL or SQL*Plus commands in the shell program. If I can
>> do this in a DOS/Windows batch program, the startup_twdm.sql and
>> shutdwon_twdm.sql can be suppressed; but I don't know how.
>> 2.This batch program (backup_twdm.bat) has one parameter, date with
>> format yyyymmdd, to be used as part of the archive file name. I wish
>> this batch program can get the current date automatically, but I don't
>> know how. Maybe some outside programming is necessary.
>> 3.WINZIP 8.0 cannot compress files bigger than 8G, so make sure the
>> datafiles are not too big. (but I don't know the exact limitation, I
>> cannot find it)
>> 4.WINZIP 8.0 doesn't seem to generate a log, either.
>>
>> I don't think this problem exists in any Unix platforms because the
>> shell program is so powerful. It is a problem, however, in Windows
>> NT/2K environments. Any comments are highly appreciated.
>>
>> Dino
Received on Fri Aug 03 2001 - 02:10:49 CDT