Re: RMAN Syntax

From: Vitalis Jerome <vitalisman_at_gmail.com>
Date: Fri, 22 Jul 2005 11:42:03 +0200
Message-ID: <68b128550507220242380c87f6@mail.gmail.com>

Hi,

You did not redirect the last line: echo "}"

You should use this kind of syntax which is less error-prone:

cat > ${PAR_FILE} <<EOD ;
backup database plus archivelog delete input

       format '${DMP_DIR}/%d_t%t_s%s_p%p.bak'
       tag = '${ORACLE_SID}_${TIMESTAMP}'
       setsize=  2097160192;

delete noprompt force obsolete;
EOD Regards,
Jerome

On 7/20/05, Smith, Ron L. <rlsmith_at_kmg.com> wrote:
> I am trying to build a parameter file for RMAN. I can't get the format
> of the syntax correct.
>
> Can anyone tell me what is wrong with this?
>
> echo "backup database plus archivelog delete input " >>
> ${PAR_FILE}
> echo " format '${DMP_DIR}/%d_t%t_s%s_p%p.bak' " >>
> ${PAR_FILE}
> echo " tag = '${ORACLE_SID}_${TIMESTAMP}' " >>
> ${PAR_FILE}
> echo " setsize= 2097160192; " >>
> ${PAR_FILE}
> echo "delete noprompt force obsolete; " >>
> ${PAR_FILE}
> echo "} "
>
>
> Thanks!
> Ron
>
>
> Important Notice!!
> If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited.
> Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message.
> Thank you.
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jul 22 2005 - 04:44:03 CDT