RE: Rman user response

  • From: "Sweetser, Joe" <JSweetser@xxxxxxxx>
  • To: <joe_dba@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 24 Mar 2010 13:11:42 -0600

Isn't prompting for an answer the default?  I must be missing something.
Should be relatively easy to handle a question/answer "up front" if you
can wrap it in a shell script.  

 

-joe

 

10.2.0.2

 

RMAN> delete obsolete;

 

RMAN retention policy will be applied to the command

RMAN retention policy is set to redundancy 1

using channel ORA_DISK_1

 

<snip>

 

Backup Set           3078673 24-MAR-10

  Backup Piece       3078723 24-MAR-10
/u04/oradata/backup/iad1/rman/daily/data/iad1_fgl9b60m_1_1

Backup Set           3078674 24-MAR-10

  Backup Piece       3078724 24-MAR-10
/u04/oradata/backup/iad1/rman/daily/data/iad1_fhl9b61h_1_1

 

Do you really want to delete the above objects (enter YES or NO)?

 

 

 

 

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Joe Smith
Sent: Wednesday, March 24, 2010 12:58 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Rman user response

 

Is it possible in RMAN 10g session to ask a question and get the user
response?
 
I want to run the command:
 
Rman>delete obsolete;
 
Then have the user be asked a question like:
 
Do you want to delete the obsolete backupsets?
 
Have the user supply Yes or No and the script continue.
 
I see in 11g you can use substitution variables, but not 10g?

________________________________

Hotmail is redefining busy with tools for the New Busy. Get more from
your inbox. Sign up now.
<http://www.windowslive.com/campaign/thenewbusy?ocid=PID27925::T:WLMTAGL
:ON:WL:en-US:WM_HMP:032010_2> 

Other related posts: