Welcome to the dBforums forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact support.

If you prefer not to see double-underlined words and corresponding ads, place your cursor
here for ContentLink opt out.

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, 21: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, 16: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, 18: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

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