Home | Previous Page | Next Page

Contents

In This Introduction

About This Manual

Software Dependencies

Assumptions About Your Locale

Demonstration Database

New Features in Dynamic Server

Features from Dynamic Server 10.0

Features from Dynamic Server 9.4

Features from Dynamic Server 9.3

Features from Dynamic Server 9.21

New Features in Extended Parallel Server

Documentation Conventions

Typographical Conventions

Feature, Product, and Platform

Syntax Diagrams

Example Code Conventions

Additional Documentation

Installation Guides

Informix Error Messages

IBM Informix Dynamic Server Version 10.0 and CSDK Version 2.90 Documentation Set

Compliance with Industry Standards

IBM Welcomes Your Comments

Introducing Backup and Restore

Introducing Backup and Restore

In This Chapter

What Is a Recovery System?

What Is a Backup?

What Is a Logical-Log Backup?

What Is a Restore?

Comparing ON-Bar and ontape

Planning a Recovery Strategy

What Types of Data Loss Can Occur?

How Severe is the Failure?

How Do You Use Your Data?

Scheduling Backups

Planning a Backup System for a Production Database Server

Evaluating Hardware and Memory Resources

Evaluating Backup and Restore Time

Evaluating Logging and Transaction Activity

Overview of the ON-Bar Backup and Restore System

The ON-Bar Backup and Restore System

In This Chapter

Where to Find Information on ON-Bar, ISM, and TSM

ON-Bar for Dynamic Server

ON-Bar for Extended Parallel Server

Database Server and Storage-Manager Communication

Backup Scheduler

ON-Bar Utilities

IBM Informix Storage Manager

IBM Tivoli Storage Manager (UNIX)

Third-Party Storage Managers

The XBSA Interface

The ON-Bar Tables

The Emergency Boot Files

The ON-Bar Activity Log

Configuring the Storage Manager and ON-Bar

In This Chapter

Configuring a Storage Manager

Installing and Configuring a Storage Manager

Configuring ISM

Configuring TSM

Updating the sm_versions File

Configuring Multiple Storage Managers on Coserver Nodes (XPS)

Validating Your Storage Manager

Configuring ON-Bar

Creating the bargroup Group (UNIX)

Updating the onbar Script

Setting ISM Environment Variables and ONCONFIG Parameters

Setting the Informix Interface for TSM Environment Variables

Specifying the Location of the XBSA Library

Using ON-Bar Configuration Parameters

Using ON-Bar Configuration Parameters on Dynamic Server

Using ON-Bar Configuration Parameters on Extended Parallel Server

Steps to Take Before Making a Test Backup

Choosing Storage Managers and Storage Devices

Features That ISM Supports

Features That ISM Does Not Support

Features That TSM Supports

Feature that TSM Does Not Support

Storage Device Requirements

Considerations for Extended Parallel Server

Backing Up with ON-Bar

In This Chapter

Syntax of ON-Bar Commands

Preparing for a Backup

What Data Does ON-Bar Back Up?

Which Administrative Files to Back Up?

Installing and Configuring a Storage Manager

What Is a Whole-System Backup? (IDS)

What Is a Standard Backup?

What is an Incremental Backup?

What Is a Physical Backup? (XPS)

Choosing a Backup Level

Collecting Information About Your System Before a Backup

Backing Up Storage Spaces and Logical Logs

Backing Up After Changing the Physical Schema

Using ISM During a Backup

Using IBM Informix Server Administrator to Back Up and Verify

ON-Bar Backup Examples

Backing Up Table Types

Viewing Recent ON-Bar Activity (IDS)

Backing Up Logical Logs

Backing Up Logical Logs on Dynamic Server

Backing Up Logical Logs on Extended Parallel Server

Monitoring Logical-Log Backups

Salvaging Logical-Log Files

Understanding ON-Bar Backup Processes

Backup Sequence on Dynamic Server

Backup Sequence on Extended Parallel Server

Verifying Backups

In This Chapter

Verifying Backups with archecker

Using archecker to Verify Backups

Preparing to Verify Backups

Estimating the Amount of Temporary Space for archecker

Verification Examples

Interpreting Verification Messages

What To Do If Backup Verification Fails

Procedures for Fixing Backup Verification Problems

Restoring Data with ON-Bar

In This Chapter

What Types of Restores Does ON-Bar Perform

What Is a Warm Restore?

What Is a Cold Restore?

What Is a Mixed Restore?

What Is a Parallel Restore?

What Is a Whole-System Restore? (IDS)

What Is a Point-in-Time Restore?

What Is an Imported Restore?

What Is a Rename Chunks Restore? (IDS)

What Is a Restartable Restore? (IDS)

Using the Pre-Recovery Checklist

Monitoring Restores

Ensuring That Storage Devices Are Available

Restoring Save Sets with ISM

Performing a Complete Restore

Performing a Physical-Only or Logical-Only Restore

Using IBM Informix Server Administrator to Restore Data

Examples of ON-Bar Restore Commands

Renaming Chunks During a Restore (IDS)

Key Considerations

New-Chunk Requirements

Examples of Renaming Chunks During a Restore

Transferring Data with the Imported Restore

Importing a Restore

Initializing High-Availability Data Replication with ON-Bar (IDS)

Restoring Nonlogging Databases and Tables

Restoring Table Types

Using Restartable Restore to Recover Data (IDS)

Restartable Restore Example

Restarting a Restore

Resolving a Failed Restore

Understanding ON-Bar Restore Processes

Warm-Restore Sequence on Dynamic Server

Cold-Restore Sequence on Dynamic Server

Warm-Restore Sequence on Extended Parallel Server

Cold-Restore Sequence on Extended Parallel Server

Performing an External Backup and Restore

In This Chapter

Recovering Data Using an External Backup and Restore

What Is Backed Up in an External Backup?

Rules for an External Backup

Performing an External Backup

Preparing for an External Backup

Blocking and Unblocking Dynamic Server

Blocking and Unblocking Extended Parallel Server

Monitoring an External Backup

Tracking an External Backup

What Is Restored in an External Restore?

Using External Restore Commands

Rules for an External Restore

Performing an External Restore

Initializing HDR with an External Backup and Restore (IDS)

Using ON-Bar Utilities

In This Chapter

Customizing ON-Bar and Storage-Manager Commands

Printing the Backup Boot Files

Migrating Backed-Up Logical Logs to Tape

Using start_worker.sh to Start onbar_worker Processes Manually (XPS)

Expiring and Synchronizing the Backup Catalogs

Choosing an Expiration Policy

Using the onsmsync Utility

Starting and Stopping ON-Bar Sessions (XPS)

Using the onbar_w Utility

Monitoring the Backup Scheduler Status (XPS)

Using the onstat -g bus Option

Using the onstat -g bus_sm Option

Setting ON-Bar Configuration Parameters

In This Chapter

Setting archecker Configuration Parameters in AC_CONFIG

Setting ON-Bar Parameters in ONCONFIG

ALRM_ALL_EVENTS (IDS)

BAR_BOOT_DIR (XPS)

BAR_BSALIB_PATH

BAR_DBS_COSVR (XPS)

BAR_IDLE_TIMEOUT (XPS)

BAR_LOG_COSVR (XPS)

BAR_MAX_BACKUP (IDS)

BAR_NB_XPORT_COUNT (IDS)

BAR_PROGRESS_FREQ

BAR_SM_NAME (XPS)

BAR_WORKER_COSVR (XPS)

BAR_WORKER_MAX (XPS)

BAR_XFER_BUF_SIZE (IDS)

BAR_XFER_BUFSIZE (XPS)

BAR_XPORT_COUNT (XPS)

LOG_BACKUP_MODE (XPS)

RESTARTABLE_RESTORE (IDS)

Files That ON-Bar, ISM, and TSM Use

ON-Bar Catalog Tables

In This Chapter

The bar_action Table

The bar_instance Table

The bar_ixbar Table

The bar_object Table

The bar_server Table

The bar_syncdeltab Table

ON-Bar Catalog Map

Backup Scheduler SMI Tables (XPS)

ON-Bar Messages and Return Codes

In This Chapter

About ON-Bar Messages

Message Numbers

ON-Bar Usage Messages

ON-Bar Return Codes

The ontape Backup and Restore System (IDS)

Configuring ontape

In This Chapter

Setting the ontape Configuration Parameters

Setting the Tape-Device Parameters

Specifying the Tape-Block-Size Parameters

Specifying the Tape-Size Parameters

Checking and Changing ontape Configuration Parameters

Who Can Change ontape Parameters?

When Can You Change ontape Parameters?

Changing ontape Parameters

Backing Up with ontape

In This Chapter

Syntax of ontape

Starting ontape

Using ontape Exit Codes

Changing Database Logging Status

Creating a Backup

Choosing a Backup Level

Backing Up After Changing the Physical Schema

Preparing for a Backup

Performing a Backup

When the Logical-Log Files Fill During a Backup

When a Backup Terminates Prematurely

Monitoring Backup History Using oncheck

Backing Up Logical-Log Files with ontape

Before You Back Up the Logical-Log Files

When Must You Back Up Logical-Log Files?

Starting an Automatic Logical-Log Backup

Starting a Continuous Logical-Log File Backup

Ending a Continuous Logical-Log Backup

What Device Must Logical-Log Backups Use?

Restoring with ontape

In This Chapter

Choosing the Type of Physical Restore

A Full-System Restore

Restoring Selected Dbspaces, Blobspaces, and Sbspaces

Choosing a Cold, Warm, or Mixed Restore

A Mixed Restore

Performing a Restore

Restoring the Whole System

Gathering the Appropriate Tapes

Deciding on a Complete Cold or a Mixed Restore

Verifying Your Database Server Configuration

Performing a Cold Restore

Restoring Selected Storage Spaces

Gathering the Appropriate Tapes

Ensuring That Needed Device Are Available

Backing Up Logical-Log Files

Performing a Warm Restore

Restoring Raw Tables

Renaming Chunks During a Restore

Key Considerations

New Chunk Requirements

Examples of Renaming Chunks During a Restore

Restoring from Standard Input

Simultaneous Backup and Restore Using Standard I/O

Performing an External Backup and Restore Using ontape

In This Chapter

Recovering Data Using an External Backup and Restore

What Is Backed Up in an External Backup?

Rules for an External Backup

Performing an External Backup

Preparing for an External Backup

Blocking and Unblocking Dynamic Server

Tracking an External Backup

What Is Restored in an External Restore?

Using External Restore Commands

Rules for an External Restore

Performing an External Restore

Initializing HDR with an External Backup and Restore

Other Data Restore Utilities

Restoring Table-level Data

In This Chapter

Overview of archecker

The archecker Configuration File

The archecker Schema Command File

Physical Restore

Logical Restore

Using the archecker Utility to Restore Data

The archecker Schema Reference

The CREATE TABLE Statement

The CREATE EXTERNAL TABLE Statement

The DATABASE Statement

The INSERT Statement

The RESTORE Statement

The SET Statement

Schema Command File Examples

The archecker Configuration Parameter Reference

AC_LTAPEDEV (IDS)

AC_PAGESIZE (XPS)

AC_TAPEDEV (IDS)

Appendix A. Troubleshooting

Corrupt Page During an Archive

Log Backup Already Running

No Server Connection During a Restore

Dropping a Database Before a Restore

No dbspaces or blobspaces During a Backup or Restore

Appendix B. onstat Command Reference

onstat -g bus (XPS)

onstat -g bus_sm (XPS)

Appendix C. Migration

Using Data-Migration Tools for Recovery

Preparing for a Database Server or Storage-Manager Upgrade

Upgrading Your Storage Manager

Changing Storage-Manager Vendors

Migrating from ontape to ON-Bar (IDS)

Migrating Private ON-Bar Scripts

Appendix D. GLS Support

Using GLS with ON-Bar

Identifiers That Support Non-ASCII Characters

Identifiers That Require 7-Bit ASCII Characters

Locale of ON-Bar Messages

Using the GL_DATETIME Environment Variable with ON-Bar

Point-in-Time Restore Example

Using GLS with ontape

Appendix E. Accessibility

Dotted Decimal Syntax Diagrams

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]