Problem with shell script to duplicate a database from active database
From: Sandra Becker <sbecker6925_at_gmail.com>
Date: Thu, 23 Jul 2020 16:16:41 -0600
Message-ID: <CAJzM94ALPY-0_eqBCP-LzH=b9h89iK3mmh+reCQsJ9Q4HHPcww_at_mail.gmail.com>
I need to create standby databases for several of our existing databases. We did this last year for another database and I copied that lshell script, but it's throwing an error and I can't seem to figure out what is wrong with it. This is a RHEL6 OS with Oracle 12.1.0.2. It tells me there is an error on the line "rman target..." It doesn't like the ">>". These are large databases and my session would time out long before the script completed, so I need a shell script I can run with nohup. I would appreciate any help you can provide.
dorecover;
}
EOF
exit
Date: Thu, 23 Jul 2020 16:16:41 -0600
Message-ID: <CAJzM94ALPY-0_eqBCP-LzH=b9h89iK3mmh+reCQsJ9Q4HHPcww_at_mail.gmail.com>
I need to create standby databases for several of our existing databases. We did this last year for another database and I copied that lshell script, but it's throwing an error and I can't seem to figure out what is wrong with it. This is a RHEL6 OS with Oracle 12.1.0.2. It tells me there is an error on the line "rman target..." It doesn't like the ">>". These are large databases and my session would time out long before the script completed, so I need a shell script I can run with nohup. I would appreciate any help you can provide.
Error:
line 11: syntax error near unexpected token `>>'
line 11:`rman target sys/pwd01_at_COMP2 auxiliary sys/pwd01_at_UCOMP_DB1 <EOF> >>
$LOG_FILE'
Script:
#!/bin/bash
#set -x
. /home/orcl/db_stdby_db1.ksh
ts=`date +'%Y%m%d%H%M'`
LOG_FILE='/LOGS/COMP/dumps/build_standby_COMP_DB1.log_'${ts}
HOSTNAME=`hostname`
STARTTIME=`date -u '+%Y_%m_%d.%H%M%S'`
echo $STARTTIME > $LOG_FILE
rman target sys/pwd01_at_COMP2 auxiliary sys/pwd01_at_COMP_DB1 <EOF> >> $LOG_FILE run {
allocate channel t1 type disk; allocate channel t2 type disk; allocate channel t3 type disk; allocate channel t4 type disk; allocate auxiliary channel a1 type disk; allocate auxiliary channel a2 type disk;allocate auxiliary channel a3 type disk; allocate auxiliary channel a4 type disk; duplicate target database for standby from active database nofilenamecheck
dorecover;
release channel t1; release channel t2; release channel t3; release channel t4; release channel a1; release channel a2; release channel a3; release channel a4;
}
EOF
exit
-
Sandy B.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jul 24 2020 - 00:16:41 CEST