Re: Can I pass a parameter into an RMAN Script?
From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 25 Feb 2008 10:50:43 -0800
Message-ID: <bf46380802251050v531e7efudce75c7f6050ad33@mail.gmail.com>
MY_FORMAT='BBB' $ORACLE_HOME/bin/rman checksyntax << EOF run {
'/backup/oracle/$MY_FORMAT/DBF_%d_%T_%p_%s%t'; }
EOF
Date: Mon, 25 Feb 2008 10:50:43 -0800
Message-ID: <bf46380802251050v531e7efudce75c7f6050ad33@mail.gmail.com>
On Mon, Feb 25, 2008 at 9:45 AM, Sam Bootsma <sbootsma_at_georgebrown.ca>
wrote:
> 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';
>
>
>
Try using 'here' documents:
MY_FORMAT='BBB' $ORACLE_HOME/bin/rman checksyntax << EOF run {
allocate channel ch1 type disk;
backup database format
'/backup/oracle/$MY_FORMAT/DBF_%d_%T_%p_%s%t'; }
EOF
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 25 2008 - 12:50:43 CST