Re: backup from within a Java application

On 2 Sep 2005 06:26:44 -0700, "maryrancora_at_hotmail.com" <maryrancora_at_hotmail.com> wrote:

>I have a user requirement to do Oracle on-line (hot) schema backups and
>restores from within my Java application. What is the best strategy to
>use and what are the pros and cons?
>
>Thanks.

There is no such thing as 'hot schema backups'. There is hot database backup, hot tablespace backup and hot datafile backup.
Other than that, there is a perfect tool for this in Oracle, called RMAN, so you are trying to reinvent the wheel. RMAN needless to say stores backups either on disk on the server or on a tape drive or tape program connected to the server. Restores can't be automated, as the code will need to be different everytime the database crashes.
Finally, if someone is going to run backups through a webbrowser, and no one can exercise control over the backups, and the DBA can't exercise control over these backups, I would fire the person developing such crap on the spot.

--
Sybrand Bakker, Senior Oracle DBA