Re: Automaticly

Kochis wrote:
>
> I am looking for information on running an unmaned backup. I am running
> Oracle WGS version 7.1 on NT 3.51. I want to use the NT schedular to start
> operation. Does anyone know how to accomplish this? I have tried using a
> bat file to start SQLDBA, but I am unable to login using the file.

  If you want to carry out the online backup, you can use SQL*Plus which runs a script. The script may be :

CONNECT SYSTEM/MANAGER
ALTER TABLESPACE tbs BEGIN BACKUP
HOST COPY dbf1.dbf \backup\dbf1.dbf
ALTER TABLESPACE tbs END BACKUP

.
.
.

  These scripts can be run on the scheduled time.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.