RE: Can I pass a parameter into an RMAN Script?
Date: Mon, 25 Feb 2008 11:24:48 -0700
I didn't think you could pass parameters. I have used shell scripts to parameterize instead of calling stored scripts. I would think you could use global scripts, instead, and the flash recovery area to achieve your ends (or for that matter stored configuration). I haven't used rman stored scripts in many years and not sure what the behaviour is if you changed catalogs.
President/Executive Architect, Quasar Database Technologies, LLC
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Sam Bootsma
Sent: Monday, February 25, 2008 10:45 AM To: oracle-l_at_freelists.org
Subject: Can I pass a parameter into an RMAN Script?
Oracle 10.2.0.3, Enterprise Edition, on AIX 5.3.
In our RMAN backup scripts for our AAA database we have several format lines that look like:
The same lines for our BBB database looks like:
Because of this difference in the format lines I need to create and maintain separate RMAN scripts for each database. If I could pass a parameter into the RMAN script, then I could have just one RMAN script and call it with a parameter specifying the database name.
Can anybody tell me if this is possible? Or must I continue to create separate RMAN scripts for each database I wish to backup? I checked the Oracle docs, but could not find anything that spoke to what I want to do.
Oracle Database Administrator
Information Technology Services
George Brown College
Phone: 416-415-5000 x4933
E-mail: <mailto:sbootsma_at_georgebrown.ca> sbootsma_at_georgebrown.ca