If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Logical logs to disk

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-07-03, 20:57
alex1668 alex1668 is offline
Registered User
 
Join Date: Oct 2003
Location: Canada, Quebec
Posts: 11
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.
Reply With Quote
  #2 (permalink)  
Old 12-09-03, 15:30
noober noober is offline
Registered User
 
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"
Reply With Quote
  #3 (permalink)  
Old 12-09-03, 17:26
alex1668 alex1668 is offline
Registered User
 
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?
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On