Re: Shutdown Oracle on NT Server

You're looking at this through the wrong end of the telescope. Oracle has its  own methods of backup, both hot (without stopping the database) and cold (with the database stopped.) This is done with PL/SQL commands through server manager. The following sequence will do a hot backup of one tablespace:

ALTER TABLESPACE data_tablespace BEGIN BACKUP;

HOST OCOPY73 D:\ORANT\DATABASE\data_tablespace *.DBF E:\BACKUP\backup_area\

ALTER TABLESPACE data_tablespace END BACKUP;

In article <6v9j9q$g2c$1_at_nnrp1.dejanews.com>,   stuart.crawford_at_usa.net wrote:
> I would like to shutdown my Oracle 7 Server on NT, so I can back up my
> database at night using NT backup, what I am doing right now is during the
> day, stopping the oracle services and backing up the dbase, I am looking for
> the commands so I can write a file that shuts down these services or if there
> is a switch that NTBackup has to back up live databases
>
> Thanks
>
> Stu&#137;
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

--
Ed Stevens
Nissan Motor Mfg. Corp., USA

--
Ed Stevens
Nissan Motor Mfg. Corp., USA

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Oct 05 1998 - 08:01:32 CDT