Arslan Bahar wrote:
>
> i wanna to take online backup on w2000 and i will write a batch
> file to perform
> ALTER TABLE SPACE ... BEGIN BACKUP and END BACKUP commands.
> but i dont know how can i sent files to tape on command prompt.
>
you don't need to execute it in a batch file - run it from sqlplus:
alter tablespace SYSTEM begin backup;
host ocopy D:\ORACLE\ORADATA\TEST\SYSTEM01.DBF G:\backup\TEST\hot\
host dbv FILE=G:\backup\TEST\hot\SYSTEM01.DBF BLOCKSIZE=8192
LOGFILE=G:\backup\TEST\HOT\SYSTEM01.LOG
host pacomp -a -c1 E:\zipfiles\TEST\hot\SYSTEM01.zip
G:\backup\TEST\HOT\SYSTEM01.*;
host del /Q G:\backup\TEST\hot\SYSTEM01.*;
alter tablespace SYSTEM end backup;
The bonus lines in this backup job run the DBVerify utility and then
compress the datafile.
You will need a batch file to call this file with sqlplus (which will be
executed as a scheduled job in the OS).
as far as NT Backup - here's the man page
ntbackup backup [systemstate] "bks file name" /J {"job name"} [/P {"pool
name"}] [/G {"guid name"}] [/T { "tape name"}] [/N {"media name"}] [/F
{"file name"}] [/D {"set description"}] [/DS {"server name"}] [/IS
{"server name"}] [/A] [/V:{yes|no}] [/R:{yes|no}] [/L:{f|s|n}] [/M
{backup type}] [/RS:{yes|no}] [/HC:{on|off}] [/UM]
and here is an example job - use the GUI to schedule it at a future
time, and examine the properties of the scheduled job in he control
panel - scheduled tasks (the job won't show in an AT command - Windows
2000 only).
C:\WINNT\system32\ntbackup.exe backup "@C:\Documents and
Settings\pldrake\Local Settings\Application Data\Microsoft\Windows
NT\NTBackup\data\test_system.bks" /n "Media created 6/2/2001 at 6:58 PM"
/d "test_system" /v:yes /r:no /rs:no /hc:on /m copy /j "test_system"
/l:f /p "Travan"
hth,
Paul
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Drake
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
