Can I pass a parameter into an RMAN Script?
Date: Mon, 25 Feb 2008 12:45:10 -0500
Message-ID: <CC7ECEDD58772D41A44D87EBED4A77A103255711@TCCEML02.gbrownc.on.ca>
Hello all,
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:
format '/san2/orabackup/AAA/CTRL_%d_%T_%p_%s%t';
The same lines for our BBB database looks like:
format '/san2/orabackup/BBB/CTRL_%d_%T_%p_%s%t';
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.
Thanks,
Sam Bootsma
Oracle Database Administrator
Information Technology Services
George Brown College
Phone: 416-415-5000 x4933
Fax: 416-415-4836
E-mail: sbootsma_at_georgebrown.ca <mailto:sbootsma_at_georgebrown.ca>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 25 2008 - 11:45:10 CST