Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Shutdown Oracle on NT Server
don't you have to alter archive mode for hot backups?
Ed.Stevens_at_nmm.nissan-usa.com wrote in message
<6vafvc$eu2$1_at_nnrp1.dejanews.com>...
>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‰
>>
>> -----------== 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 Sat Oct 24 1998 - 13:32:03 CDT