Re: Online NT Backup Script -Help

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 4 Oct 2000 09:24:36 +0100
Message-ID: <8repg7$krj$1@soap.pipex.net>

using sqlplus youy can write a script of the form

alter tablespace system begin backup;
host <path to bin directory>\ocopy <tablespace filename(s)> <destination directory>
alter tablespace system end backup;

etc

i.e. use the host comnmand and the fully qualified path to the ocopy program (which changes its name between Oracle versions).

the only snag with this approach that you might come across is if you use AT to schedule the copy. Then you need to issue a net use to use the network resource and make sure that the scheduler account has permissions to copy the files.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"swaite" <swaite_at_equiplease.com> wrote in message
news:rdrC5.1$fc1.224_at_wdc-read-01.qwest.net...


> I am looking for the script to do an Online (Archivelog) backup of an

 Oracle


> 8i Database running on Win NT where I move (copy) the appropriate files to

> an intermediate drive and then to tape instead of direct to tape.  After I

> put the tablespaces into backup state I want to copy the corresponding

> datafiles to a network drive and back them up from there. Any help would

> really be appreciated

>

> Sean Waite

> Sunrise International Leasing

> 612-513-3272

> swaite_at_equiplease.com

>

>

>

Received on Wed Oct 04 2000 - 03:24:36 CDT