bck_minimize_load

### This script will be sourced into the rman_bck.sh script and is responsible for creating the rman backup command string
###
### Created to allow backups with the "backup duration ... minimize load" clause

debugmsg 1 "Start of external script ${EXTERNAL_SCRIPT}"
CMD_STR="
  ORACLE_HOME=$ORACLE_HOME ; export ORACLE_HOME
  ORACLE_SID=$ORACLE_SID ; export ORACLE_SID
  LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH ; export LD_LIBRARY_PATH
  NLS_DATE_FORMAT='DD/MM/YYYY HH24:MI:SS' ; export NLS_DATE_FORMAT
  $RMAN msglog $RMAN_LOG_FILE append << EOF
    $TARGET_CONNECT_STR
    $CATALOG_CONNECT_STR

    set echo on

    ### Enable the controlfile autobackup
    ### This is not realy necessary as we are using an rman database catalog

    configure controlfile autobackup format for device type 'SBT_TAPE' to '%F';
    configure controlfile autobackup on;

    ### Set the channel configuration
    configure device type sbt parallelism $PARALLELISM;
    configure default device type to sbt;
    configure channel device type sbt format '%U' PARMS='ENV=(NB_ORA_CLIENT=$NB_ORA_CLIENT, NB_ORA_POLICY=$NB_ORA_POLICY, NB_ORA_SCHED=$APPLICATION_SCHEDULE)';

    ### Output the configuration
    show all;

    ### Remove the expired backups from the recovery catalog
    ### Do this before taking the backup as this may influence the incremental level actually used
    allocate channel for maintenance device type 'SBT_TAPE';
    send 'NB_ORA_CLIENT=$NB_ORA_CLIENT';
    crosscheck backup;
    delete force noprompt expired backup;
    release channel;

    ### Backup the database plus archivelogs
    ### Remove the archivelogs after the backup
    run
    { backup
        $BACKUP_OPTIONS
        tag $BACKUP_TAG
        archivelog all delete all input;
    
      backup
        $BACKUP_OPTIONS
        tag $BACKUP_TAG
        duration 6:00
        minimize load
        database
          include current controlfile
      ;
       
      sql \"alter system archive log current\";
       
      backup
        $BACKUP_OPTIONS
        tag $BACKUP_TAG
        archivelog all delete all input;
        
    }

    ### Clear the channel configuration
    configure device type sbt clear;
    configure default device type clear;
    configure channel device type sbt clear;

EOF
"
debugmsg 2 "  CMD_STR: $CMD_STR"
debugmsg 1 "End of external script ${EXTERNAL_SCRIPT}"