ibm informix backup recovery using onbar l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
IBM Informix Backup & Recovery Using OnBar PowerPoint Presentation
Download Presentation
IBM Informix Backup & Recovery Using OnBar

Loading in 2 Seconds...

play fullscreen
1 / 12

IBM Informix Backup & Recovery Using OnBar - PowerPoint PPT Presentation


  • 617 Views
  • Uploaded on

IBM Informix Backup & Recovery Using OnBar. Doug Brown 407-566-5074 Doug.A.Brown@disney.com. 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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'IBM Informix Backup & Recovery Using OnBar' - benjamin


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
ibm informix backup recovery using onbar
IBM InformixBackup & Recovery Using OnBar

Doug Brown 407-566-5074

Doug.A.Brown@disney.com

objectives
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 vs. OnBar

OnBar

  • Parallel Backup/Restore
  • Reduced Backup Window
  • Faster Recovery
  • Storage Manager Integration

OnTape

  • Reliable Backup
  • Simple Operation
  • Easy Configuration
  • Simple Tape Rotation
what is onbar
What is OnBar?

IDS

OnBar

Storage Manager

Archive

XBSA

API

API

DB Spaces

Media Devices

Sysutils DB

onbar backup options
OnBar Backup Options
  • Whole System
  • DB Space Backup
  • Full/Incremental (Level 1,2)
  • Fake Backup
onbar restore options
OnBar Restore Options
  • Cold Restore
  • Warm Restore
  • Physical Restore
  • Logical Restore
  • Point-in-Time Restore
what s backed up and not
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
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
Tuning OnBar Backups
  • Physical Database Configuration
  • Backup Parallelism
    • Thread Manipulation
    • Tape Drive Utilization
  • Transfer Data Buffers
external onbar restores
External OnBar Restores
  • Configure Informix Environment
    • Copy ONCONFIG File
    • Add SQLHOSTS Entry
    • Services Entry (etc/services)
  • Copy ONBar Backup Files
    • ixbar.servernum
    • oncfg_servername.servernum
  • Point to Storage Manager
  • Execute Restore Command
storage manager integration
Storage Manager Integration
  • Informix Storage Manager (ISM)
  • Veritas Net Backup
  • HP OmniBack
  • Other Third Party Vendors