Re: Oracle hot backup on NT

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 30 Jan 1999 08:44:22 -0000
Message-ID: <917685873.6292.0.nnrp-12.9e984b29@news.demon.co.uk>

Write a little procedure to dump out the contents of dba_tablespaces sorted by tablespace_name and file_name.

Use a cursor loop that does:

end backup of last tablespace
begin backup of new tablespace at change of tablespace and

host ocopy80 filename newfilename on every line

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Janice Nightingale wrote in message
<204285895F88D1118FAC00A0C933CDDF1AEE7D_at_PTOWN>...
>Does anyone have any suggestions as to how to dynamically generate hot
>backup scripts on NT as one would do on VMS or UNIX ?
>
>So far the only docs I can find related to this suggest creating a script
>where all the tablespace names and datafile names are hard coded into the
>script, and there is also no error handling.
>
>Thanks in advance.
>
>
Received on Sat Jan 30 1999 - 02:44:22 CST