I wrote our current backup script to use PL/SQL to generate the SQL backup script which is then run to put each tablespace into backup mode so that its datafiles can be backed up and gzipped. So yes PL/SQL might make sense.
Originally Posted by PAVB
Although, we are in the process of converting to RMAN. The feature set in 10g and especially 11g is just too good. I have a script that either clones or sets up a standby database all using RMAN, on the same or a different server as the source db.
this space intentionally left blank