Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Shutdown Oracle on NT Server

Re: Shutdown Oracle on NT Server

From: Flipper <flipper2000_at_mindspring.com>
Date: Sat, 24 Oct 1998 14:32:03 -0400
Message-ID: <70t672$glg$1@camel25.mindspring.com>


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&#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 Sat Oct 24 1998 - 13:32:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US