Transcript DB-Access Training Course

IBM Informix
Backup & Recovery Using
OnBar
Doug Brown 407-566-5074
[email protected]
Objectives
• Discuss OnTape vs. OnBar
• What is OnBar?
• OnBar Backup & Restore Options
• What’s Backed Up (And Not)
• OnBar Configuration Parameters
• Tuning OnBar Backups
• External OnBar Restores
• Storage Manager Integration
OnTape vs. OnBar
OnTape




Reliable Backup
Simple Operation
Easy Configuration
Simple Tape Rotation
OnBar




Parallel Backup/Restore
Reduced Backup Window
Faster Recovery
Storage Manager Integration
What is OnBar?
IDS
Archive
API
OnBar
XBSA
API
Storage
Manager
DB Spaces
Media Devices
Sysutils DB
OnBar Backup Options
 Whole System
 DB Space Backup
 Full/Incremental (Level 1,2)
 Fake Backup
OnBar Restore Options
 Cold Restore
 Warm Restore
 Physical Restore
 Logical Restore
 Point-in-Time Restore
What’s Backed Up
(And Not)
 OnBar Backup includes:
 DB Space
 Logical Log
 Blobspace
 Additional Files Required to Restore
 ONCONFIG
 ixbar.servernum
 oncfg_servername.servernum
 sm_versions
 sqlhosts file
 services file
OnBar Configuration
Parameters
BAR_BSALIB_PATH
XBSA library path
BAR_ACT_LOG
OnBar activity log
BAR_MAX_BACKUP
Max # of process / onbar command
BAR_RETRY
Number of retries on failed attempt
BAR_NB_XPORT_COUNT # of shared-memory data buffers
BAR_XFER_BUF_SIZE
Buffer size uses to exchange
data with onbar_d process
LTAPEDEV
Logical log tape device
LBU_PRESERVE
Logical log block for onbar process
ALARMPROGRAM
Script execute when logical log fills
RESTARTABLE_RESTORE Option to allow restore restart
Tuning OnBar Backups
 Physical Database Configuration
 Backup Parallelism
 Thread Manipulation
 Tape Drive Utilization
 Transfer Data Buffers
External OnBar Restores
1. Configure Informix Environment
1. Copy ONCONFIG File
2. Add SQLHOSTS Entry
3. Services Entry (etc/services)
2. Copy ONBar Backup Files
1. ixbar.servernum
2. oncfg_servername.servernum
3. Point to Storage Manager
4. Execute Restore Command
Storage Manager
Integration
 Informix Storage Manager (ISM)
 Veritas Net Backup
 HP OmniBack
 Other Third Party Vendors
Questions & Answers
?
?
?
?
?