topic Re: oracle hot backup script in Operating System - HP-UX

oracle hot backup script

steven chang_1 — Tue, 06 Jan 2004 02:14:25 GMT

this script would call tsinfo.sql to generate
other sql statement to complete the backup
I would post the sql statement in another session.

steven

Re: oracle hot backup script

steven chang_1 — Tue, 06 Jan 2004 02:17:13 GMT

here is the tsinfo.sql

Re: oracle hot backup script

Hari Kumar — Tue, 06 Jan 2004 02:17:34 GMT

Once again Good work and extended Help.

addendum:
Think we dont need and cannot backup the TEMPORARY Tablespaces, so we can ommit the temporary tablespace and associated datafiles
in your script to make it better.

Re: oracle hot backup script

steven chang_1 — Tue, 06 Jan 2004 02:45:55 GMT

hello hari:

To avoid backup temp tablespace, I need to writing PL/SQL staement to handle some situation. This could not be achieved by
just sql staement.I would study PL/SQL code
for future need.Thank you for your suggest.

steven