++ id ++ cut '-d(' -f2 ++ cut -d ')' -f1 + CUSER=root ++ basename /usr/openv/scripts/hot_database_backup.sh + MYNAME=hot_database_backup.sh + export MYNAME ++ dirname /usr/openv/scripts/hot_database_backup.sh + MYDIR=/usr/openv/scripts + MYPID=2867 + export MYPID ++ date +%Y%m%d.%H%M%S + MYDATE=20161017.093125 + export MYDATE + ORA_PARAM=/usr/openv/scripts/ora_param + export ORA_PARAM + SID_NAME=/usr/openv/scripts/sid_name + export SID_NAME ++ /usr/openv/scripts/sid_name Oracle-Pharm-PROPASXP-PRD + ORACLE_SID=PROPASXP ++ /usr/openv/scripts/ora_param PROPASXP ORACLE_SID + ORACLE_SID=PROPASXP + export ORACLE_SID ++ /usr/openv/scripts/ora_param PROPASXP ORACLE_USER stty: standard input: Inappropriate ioctl for device + ORACLE_USER=oracle + export ORACLE_USER ++ /usr/openv/scripts/ora_param PROPASXP '~' stty: standard input: Inappropriate ioctl for device + ORACLE_USER_HOMEDIR=/u01/home/oracle + export ORACLE_USER_HOMEDIR ++ /usr/openv/scripts/ora_param PROPASXP ORACLE_HOME stty: standard input: Inappropriate ioctl for device + ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/DB + export ORACLE_HOME ++ /usr/openv/scripts/ora_param PROPASXP TARGET_CONNECT_STR stty: standard input: Inappropriate ioctl for device + TARGET_CONNECT_STR= + '[' -z '' ']' + TARGET_CONNECT_STR=/ + export TARGET_CONNECT_STR ++ /usr/openv/scripts/ora_param PROPASXP CATALOG_CONNECT_STR stty: standard input: Inappropriate ioctl for device + CATALOG_CONNECT_STR=nocatalog + '[' -z CATALOG_CONNECT_STR ']' + export CATALOG_CONNECT_STR ++ /usr/openv/scripts/ora_param PROPASXP NB_ORA_CLIENT stty: standard input: Inappropriate ioctl for device + NB_ORA_CLIENT= + '[' -z '' ']' + RMAN_SEND_STR=NB_ORA_POLICY=Oracle-Pharm-PROPASXP-PRD + LOGDIR=/u01/home/oracle/.rman_log + export LOGDIR + '[' '!' -d /u01/home/oracle/.rman_log ']' + RMAN_LOG_FILE=/u01/home/oracle/.rman_log/hot_database_backup.sh.log.20161017.093125 + export RMAN_LOG_FILE + echo + chown oracle /u01/home/oracle/.rman_log/hot_database_backup.sh.log.20161017.093125 + echo Script /usr/openv/scripts/hot_database_backup.sh ++ date + echo ==== started on Mon Oct 17 09:31:30 CEST 2016 ==== + echo + RMAN=/u01/app/oracle/product/11.2.0.4/DB/bin/rman + export RMAN + SQLPLUS=/u01/app/oracle/product/11.2.0.4/DB/bin/sqlplus + export SQLPLUS + echo + echo 'RMAN: /u01/app/oracle/product/11.2.0.4/DB/bin/rman' + echo 'ORACLE_SID: PROPASXP' + echo 'ORACLE_USER: oracle' + echo 'ORACLE_HOME: /u01/app/oracle/product/11.2.0.4/DB' + echo + echo 'NB_ORA_FULL: 0' + echo 'NB_ORA_INCR: 1' + echo 'NB_ORA_CINC: 0' + echo 'NB_ORA_SERV: chbsux0431.eu.novartis.net' + echo 'NB_ORA_POLICY: Oracle-Pharm-PROPASXP-PRD' + echo + '[' 0 = 1 ']' + '[' 1 = 1 ']' + echo 'Differential incremental backup requested' + BACKUP_TYPE='INCREMENTAL LEVEL=1' + CMD_STR=' ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/DB export ORACLE_HOME ORACLE_SID=PROPASXP export ORACLE_SID /u01/app/oracle/product/11.2.0.4/DB/bin/rman target / nocatalog send "'\''NB_ORA_POLICY=Oracle-Pharm-PROPASXP-PRD'\''" msglog /u01/home/oracle/.rman_log/hot_database_backup.sh.log.20161017.093125 a ppend << EOF RUN { ALLOCATE CHANNEL ch00 TYPE '\''SBT_TAPE'\'' MAXOPENFILES=1; BACKUP INCREMENTAL LEVEL=1 TAG hot_db_bk_level0 FILESPERSET 5 DATABASE; SQL '\''alter system archive log current'\''; RELEASE CHANNEL ch00; # backup all archive logs ALLOCATE CHANNEL ch00 TYPE '\''SBT_TAPE'\'' MAXOPENFILES=1; BACKUP FILESPERSET 20 SKIP INACCESSIBLE ARCHIVELOG ALL DELETE INPUT; RELEASE CHANNEL ch00; # # Note: During the process of backing up the database, RMAN also backs up the # control file. This version of the control file does not contain the # information about the current backup because nocatalog has been specified. # To include the information about the current backup, the control file should # be backed up as the last step of the RMAN section. This step would not be # necessary if we were using a recovery catalog or auto control file backups. # ALLOCATE CHANNEL ch00 TYPE '\''SBT_TAPE'\''; BACKUP CURRENT CONTROLFILE; RELEASE CHANNEL ch00; } EOF ' + '[' root = root ']' + su - oracle -c ' ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/DB export ORACLE_HOME ORACLE_SID=PROPASXP export ORACLE_SID /u01/app/oracle/product/11.2.0.4/DB/bin/rman target / nocatalog send "'\''NB_ORA_POLICY=Oracle-Pharm-PROPASXP-PRD'\''" msglog /u01/home/oracle/.rman_log/hot_database_backup.sh.log.20161017.093125 a ppend << EOF RUN { ALLOCATE CHANNEL ch00 TYPE '\''SBT_TAPE'\'' MAXOPENFILES=1; BACKUP INCREMENTAL LEVEL=1 TAG hot_db_bk_level0 FILESPERSET 5 DATABASE; SQL '\''alter system archive log current'\''; RELEASE CHANNEL ch00; # backup all archive logs ALLOCATE CHANNEL ch00 TYPE '\''SBT_TAPE'\'' MAXOPENFILES=1; BACKUP FILESPERSET 20 SKIP INACCESSIBLE ARCHIVELOG ALL DELETE INPUT; RELEASE CHANNEL ch00; # # Note: During the process of backing up the database, RMAN also backs up the # control file. This version of the control file does not contain the # information about the current backup because nocatalog has been specified. # To include the information about the current backup, the control file should # be backed up as the last step of the RMAN section. This step would not be # necessary if we were using a recovery catalog or auto control file backups. # ALLOCATE CHANNEL ch00 TYPE '\''SBT_TAPE'\''; BACKUP CURRENT CONTROLFILE; RELEASE CHANNEL ch00; } EOF ' stty: standard input: Inappropriate ioctl for device + RSTAT=1 + '[' 1 = 0 ']' + LOGMSG='ended in error' + echo + echo Script /usr/openv/scripts/hot_database_backup.sh ++ date + echo ==== ended in error on Mon Oct 17 10:10:47 CEST 2016 ==== + echo + exit 1