Re: 30454.1- Unix script that automates warm backup of all available tablespaces ??

Hi there,
I am on solaris. As mentioned by you i fixed the line which read cat <<EOF > /tmp/backup_${ORACLE_SID}.awk
> BEGIN
> {

to
cat <<EOF > /tmp/backup_${ORACLE_SID}.awk
> BEGIN {
This made the following errors go away
awk: syntax error near line 2
awk: bailing out near line 2

But now i get the following errors in warm.backup.<sid>.log file Preparing command script .....

awk: syntax error near line 42
awk: illegal statement near line 42
awk: syntax error near line 50
awk: illegal statement near line 50

and the line 42 in my /tmp/backup_${ORACLE_SID}.awk file is this

print "ALTER DATABASE BACKUP CONTROLFILE TO " "'" target \

        "/ctrl" sid ".ctl." num "';"

I would appreciate if somebody already used this script successfully, can they cut and paste the awk portion of the script which i can cross test against mine.

-Sincerely, (admit that i am starnger to awk/sed..and am beginning to learn via this...)
avsrk

"Tanel Poder" <change_to_my_first_name_at_integrid.info> wrote in message news:<3f4d1b5c$1_1_at_news.estpak.ee>...
> Hi!
>
> Which platform are you on, Linux?
>
> Try to search and replace:
>
> cat <<EOF > /tmp/backup_${ORACLE_SID}.awk
> BEGIN
> {
>
> with
>
> cat <<EOF > /tmp/backup_${ORACLE_SID}.awk
> BEGIN {
>
> These are the nasty small differences in various Unix'es and Linux'es
> shells...
>
> Tanel.
>
> "Subrahmanyam Arya" <avsrk_at_mailcity.com> wrote in message
> news:25c1993e.0308271156.3360d350_at_posting.google.com...
> > Dear Oracle gurus,
> >
> > I am looking at a unix script that automates warm backup of all
> > available tablespaces and found in metalink a doc-id (30454.1)which
> > has this script documented. Unfortunately i have problems running this
> > script as it is.. It is resulting in some awk errors.
> >
> > Can anybody give me this script in working form if they have tried it.
> >
> > -thanks,
> > avsrk
Received on Thu Aug 28 2003 - 09:10:46 CDT