Ronnie has asked for the wisdom of the Perl Monks concerning the following question:
Thanks to everyone who helped with my initial Perl/Oracle cloning script problem but I'm afraid I've got one more. I'm at the final stage of the clone and need to run the following command via the DBI -
RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL
Unfortunately this command requires a response (cancel). It's not something I am able to test at the moment due to system constraints (shortage of disc space and the database owners don't want any of their systems cloned just yet) Is it just a case of supplying "cancel" to the DBI prepare/execute phases of a DBI connection? I'm guessing that it's not that simple!
Thanks