Ronnie has asked for the wisdom of the Perl Monks concerning the following question:

Hi there inmates, I'm trying to automate a hot backup on one of our Oracle databases using the RMAN product. I've not found an RMAN Perl module that I can use so I was wondering if anyone out there knows how to code calls to RMAN in Perl or if indeed it's possible?

The initial command that is used is rman target / catalog rman/rman@rman-live and then there is a RUN command which is supplied with various channel commands etc.
Cheers

Replies are listed 'Best First'.
Re: Hot Oracle backup/RMAN
by moritz (Cardinal) on Dec 06, 2007 at 11:15 UTC
    Am I right in assuming that rman is a command line program?

    If yes, you can just try to supply its input to STDIN, or you might find expect helpful.

Re: Hot Oracle backup/RMAN
by andreas1234567 (Vicar) on Dec 06, 2007 at 12:48 UTC
    Ronnie,

    oracle.com has an article that describes use of Oracle Recovery Manager rman from the (bash) shell in Linux. You can easily wrap that into a Perl system call, provided you use a Unix-like operating system.

    --
    Andreas