Re: Can I pass a parameter into an RMAN Script?

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: sbootsma@xxxxxxxxxxxxxx
  • Date: Mon, 25 Feb 2008 10:50:43 -0800

On Mon, Feb 25, 2008 at 9:45 AM, Sam Bootsma <sbootsma@xxxxxxxxxxxxxx>
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

Other related posts: