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

Home -> Community -> Usenet -> c.d.o.server -> Re: Looking for a online backup procedure(pl/sql) on unix

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

From: Mladen Gogala <mgogala_at_earthlink.net>
Date: Wed, 25 Aug 1999 21:36:43 -0400
Message-ID: <37C49A2B.AF1894F@earthlink.net>


banicki wrote:
>
> Are there any online backup procedures written in pl/sql for
> a UNIX platform? I could use a piece of sample code. I
> believe I had a piece code from metalink, that was several
> years old, but I can no longer find it...
>
> Actually would like to make this a scheduled stored
> procedure verses using cron...
>
> Terry Banicki, Illinois Power
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!

As PL/SQL is an RDBMS language, it's not very well fit for performing OS tasks, such as backup. My advice is to use shell scripts based on cpio or dd,
combined with the manual alter tablespace begin/end backup or buy Legato or
Alexandria software and combine it with RMAN.

--
Mladen Gogala Received on Wed Aug 25 1999 - 20:36:43 CDT

Original text of this message

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