RE: Rman user response

  • From: Mayen.Shah@xxxxxxxxxx
  • To: JSweetser@xxxxxxxx
  • Date: Wed, 24 Mar 2010 15:22:05 -0400

If you do not want to be prompted, you can use noprompt.

RMAN> delete noprompt obsolete;

I am not sure I answered the question.

HTH

- Mayen







"Sweetser, Joe" <JSweetser@xxxxxxxx> 
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
Mar 24 2010 03:11 PM
Please respond to
JSweetser@xxxxxxxx


To
joe_dba@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
cc

Subject
RE: Rman user response


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.

Other related posts: