Re: Looking for a online backup procedure(pl/sql) on unix

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Thu, 26 Aug 1999 11:18:36 -0400
Message-ID: <7q3ltv$m21$2@autumn.news.rcn.net>

Hi Terry,

    Build a script that generates a hot backup command for each tablespace in your database. This will guarantee that you are getting every tablespace in the system automatically

The following is guaranteed NOT to work. It is intended to provide guidance and is not a production script. Use it as a starting point and you should be able to develop what you want.

SET FEEDBACK OFF
SET PAGES 0

.
.
.

SPOOL <filename>.sql
SELECT 'alter ts '||tablespace_name||' begin backup;' ' HOST cp datafile /data/backup '
' alter ts '||tablespace_name||' end backup;' FROM dba_tablespaces
WHERE tablespace_name .......
SPOOL OFF
START <filename>

Regards
Jerry Gitomer

banicki wrote in message
<00091c0e.485d27e5_at_usw-ex0108-058.remarq.com>...
>Yes, Hot backups...
>The instance is up and running while my procedure is copy-
>ing the datafiles. The whole alter ts tsname begin backup/
>end backup thing...
>or
>How does you script know when a new tablespaces/datafile
>has been created? Where is a good set of shell scripts...
>I'm a reasonable person...(smirk)
>I'll follow the path of least resistance...
>Any help will be greatly appreciated...
>Terry
>
>
>* Sent from RemarQ http://www.remarq.com The Internet's
Discussion Network *
>The fastest and easiest way to search and participate in
Usenet - Free!
>
Received on Thu Aug 26 1999 - 10:18:36 CDT