Starting RMAN backup from PL/SQL

ciphersol
ciphersol used Ask the Experts™
on
I would like to be able to start an RMAN backup from within PL/SQL.  My understanding is the DBMS_PIPE package can be used to do this.  I have not found a clear example to do this on the internet.

I'm interested in any DBMS_PIPE examples or other methods to accomplish an RMAN backup from within PL/SQL.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
Thank you tangchunfeng.

I've looked through the package which will require more research on my part to understand how to do the backup I require.  

Have you actually used the package and do you know if it can do the equivalent of the following RMAN command?

         backup tablespace MY_TABLESPACE tag='BACKUP1';
http://docs.oracle.com/cd/E11882_01/appdev.112/e25788/toc.htm

it's a hidden package , not included in official document

I find some example of restore
http://www.diybl.com/course/7_databases/foxpro/20100710/406529.html
Hi

Try this package, its exactly doing this.

http://itunified.de/dbms-backup-eng/
here a short description about the package

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial