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 > hot backup using Onbar

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-11-09, 14:58
lajmiov lajmiov is offline
Registered User
 
Join Date: Mar 2009
Posts: 10
hot backup using Onbar

Hello,
I want to make a hot backup of my informix data to post on the local networks of the company.
example, the IP address of my server is 192.168.2.10 and I want to make a hot backup to another server that each IP address 192.168.2.12

its possible? what I can do ? i want using the command ONBAR (can you give me the syntax and a small script that allows me to do this operation?)

thank you very much
Reply With Quote
  #2 (permalink)  
Old 05-12-09, 14:06
ceinma ceinma is offline
Registered User
 
Join Date: Apr 2007
Location: Jundiai / SP - Brasil
Posts: 311
Using the resources appropriately (samba or nfs) , yes , is possible...
scripts? well, onbar is a little annoying to configure... read the manual...sorry...

if you want to use the ontape, is more easily to say how to do.
__________________
________________________________________
César Inacio Martins
Jundiai / SP - Brasil
http://www.imartins.com.br/informix - em Português
http://www.imartins.com.br/informix - English (translated by Google).
________________________________________
Reply With Quote
  #3 (permalink)  
Old 05-12-09, 19:31
lajmiov lajmiov is offline
Registered User
 
Join Date: Mar 2009
Posts: 10
ok! can you help me to do a backup with ontape command? the command syntax, with daily backup and weekly
thank you very much
Reply With Quote
  #4 (permalink)  
Old 05-13-09, 07:27
ceinma ceinma is offline
Registered User
 
Join Date: Apr 2007
Location: Jundiai / SP - Brasil
Posts: 311
What version of IDS and OS?
__________________
________________________________________
César Inacio Martins
Jundiai / SP - Brasil
http://www.imartins.com.br/informix - em Português
http://www.imartins.com.br/informix - English (translated by Google).
________________________________________
Reply With Quote
  #5 (permalink)  
Old 05-13-09, 08:44
lajmiov lajmiov is offline
Registered User
 
Join Date: Mar 2009
Posts: 10
OS: RHEL : REDHAT ENTERPRISE LINUX Release 4
IDS: 10
Reply With Quote
  #6 (permalink)  
Old 05-13-09, 09:25
ceinma ceinma is offline
Registered User
 
Join Date: Apr 2007
Location: Jundiai / SP - Brasil
Posts: 311
Considering :
ServerA = Informix running
ServerB = Target to save backup

Basic steps.
1) Share the disk on ServerB (with samba or nfs)
2) Mount the ServerB directory on ServerA
Let's suppose you mount in the directory: /RemoteBackup
(all this is OS knowledge, if you don't know how to do, please , search on internet , isn't hard to do)

3)Configure your ONCONFIG , the parameters TAPEDEV and LTAPEDEV :
Code:
TAPEDEV /RemoteBackup/ids_backup
LTAPEDEV /dev/null
WARNING: this way you don't have backup of any logical log, if you want to backup the logical log , you have some options what I explain at the end of this post.

4) create the backup file with informix user and set the right permission :
Code:
touch /RemoteBackup/ids_backup
chmod 660  /RemoteBackup/ids_backup
5) Execute the backup
Code:
ontape -s -L 0
Where the "-L 0" means Level 0 (full backup), if you want a incremental backup, you still have 1 and 2 levels :
Code:
ontape -s -L 1
ontape -s -L 2
But , remember, if use increment backup, to restore the level 2 , you will need the level 1 and 0 previous backuped.

The ontape always ask if the tape are mounted. If you want to automatize this process in a shell script use:
Code:
ontape -s -L 0 <<EOC

EOC
So, to create a full or incremental backup, that is all...

To create the logical logs backup you can use 2 commands;
Code:
ontape -a
ontape -c
The "-c" means "continuous" backup , where the ontape command not stop running still the user/operator press CTRL+C or the space where the backup are written become full..
The "-a" means "automatic" backup, where the ontape command backup only the not-backuped logical logs (you can check this with "onstat -l" ).

So, remember , the parameter on the ONCONFIG aren't dynamic , so every time you execute the ontape, the old file will be overwritten . This way , is high recommend you rename the fille after execute the ontape.


I don't detail to much, because this is the basic guideline and depend how your enviroment are configured and how you want your backup work...

If need more information about ontape command , please read the manual:
IBM Informix Dynamic Server v10 Information Center
IBM Informix Dynamic Server v10 Information Center
IBM Informix Dynamic Server v10 Information Center
IBM Informix Dynamic Server v10 Information Center
__________________
________________________________________
César Inacio Martins
Jundiai / SP - Brasil
http://www.imartins.com.br/informix - em Português
http://www.imartins.com.br/informix - English (translated by Google).
________________________________________
Reply With Quote
  #7 (permalink)  
Old 05-13-09, 10:38
lajmiov lajmiov is offline
Registered User
 
Join Date: Mar 2009
Posts: 10
thank you very much
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