Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Canada, Quebec
    Posts
    11

    Unanswered: Logical logs to disk

    DB Engine: Online 7.3
    SERVER: HP10.20

    I'm using onbar to do my backups with Veritas Netbackups.

    Is there a way to backup the logical logs to Disk instead of having them
    go directly to tape with "onbar -l"?

    The reason is, From time to time the backup server is having issues
    and it takes a while for the backup team to repond to my panic because
    all the logicals are getting full.

  2. #2
    Join Date
    Oct 2003
    Posts
    20

    Script i use on an AIX machine...

    ## script to backup logs on an AIX box
    # Backup Informix Logical Logs to disk file
    export INFORMIXDIR=/u/informix
    export PATH=.:$INFORMIXDIR:$INFORMIXDIR/bin:/usr/bin:/usr/sbin:/etc
    export TERMCAP=/u/informix/etc/termcap
    export INFORMIXTERM=/u/informix/etc/termcap
    export TERM=tm220
    export INFORMIXSERVER=dbserver1
    export ONCONFIG=onconfig.server1
    export DBSPACETEMP=oldserver
    CONS="/dev/console"
    BACKDIR="/backup"
    LOGFILE="$BACKDIR/LOG/`date +%b%d%H%M`.log"
    cat /dev/null > $LOGFILE
    SleepTime=60

    dsply_msg()
    {
    echo $1 | tee -a $LOGFILE >$CONS 2>&1
    }

    #
    # Execute the Logical Logs Backup
    #
    su - informix -c "ontape -a <<+
    \012
    y
    \012
    +" | tee -a $LOGFILE >$CONS 2>&1

    mv informix_backup/ll.`date +%m%d%H%M`
    >/dbwork/informix_backup/ll # Create empty ll file
    chmod 666 informix_backup/ll
    chown informix:informix informix_backup/ll

    dsply_msg "\tFinished Logical Log Backups at `date +"%H:%M:%S"`\n"

  3. #3
    Join Date
    Oct 2003
    Location
    Canada, Quebec
    Posts
    11
    Can I mixe ontape and onbar?

    I'm still using onbar for my whole backup.

    If doing a restore I would I procede recovering with the logical that were back up whit ontape?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •