RE: Unix Shell Script Help
From: Matthew Zito <mzito_at_gridapp.com>
Date: Thu, 12 Feb 2009 23:51:57 -0500
Message-ID: <C0A5E31718FC064A91E9FD7BE2F081B101D4B66A_at_exchange.gridapp.com>
Do you mean the string "cancel", or a control-c terminator? If it's the string "cancel", I would do that in perl, since you can open a program as a bi-directional process. If you just want to send control-c, you can have a forked process that watches the sqlplus command and sends a SIGINT when the right moment comes (check your OS, but on my box that's a kill -2).
Date: Thu, 12 Feb 2009 23:51:57 -0500
Message-ID: <C0A5E31718FC064A91E9FD7BE2F081B101D4B66A_at_exchange.gridapp.com>
Do you mean the string "cancel", or a control-c terminator? If it's the string "cancel", I would do that in perl, since you can open a program as a bi-directional process. If you just want to send control-c, you can have a forked process that watches the sqlplus command and sends a SIGINT when the right moment comes (check your OS, but on my box that's a kill -2).
Matt
--
Matthew Zito
Chief Scientist
GridApp Systems
P: 646-452-4090
mzito_at_gridapp.com
http://www.gridapp.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org on behalf of Bala
Sent: Thu 2/12/2009 11:17 PM
To: oracle-l
Subject: Unix Shell Script Help
How do i supply "Cancel" in a Unix Shell script after the SQLPLUS command
RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL; any tips/ suggestions highly appreciated.
Thanks in Advance
( Hot backup, HP unix, Oracle 10.2.0.4)
--
Bala Rao
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 12 2009 - 22:51:57 CST