1 / 12

IBM Informix Backup & Recovery Using OnBar

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

benjamin
Download Presentation

IBM Informix Backup & Recovery Using OnBar

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. IBM InformixBackup & Recovery Using OnBar Doug Brown 407-566-5074 Doug.A.Brown@disney.com

  2. 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

  3. 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

  4. What is OnBar? IDS OnBar Storage Manager Archive XBSA API API DB Spaces Media Devices Sysutils DB

  5. OnBar Backup Options • Whole System • DB Space Backup • Full/Incremental (Level 1,2) • Fake Backup

  6. OnBar Restore Options • Cold Restore • Warm Restore • Physical Restore • Logical Restore • Point-in-Time Restore

  7. 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

  8. 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

  9. Tuning OnBar Backups • Physical Database Configuration • Backup Parallelism • Thread Manipulation • Tape Drive Utilization • Transfer Data Buffers

  10. 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

  11. Storage Manager Integration • Informix Storage Manager (ISM) • Veritas Net Backup • HP OmniBack • Other Third Party Vendors

  12. Questions & Answers ? ? ? ? ?

More Related