In this course, you will learn about the various Informix tools that can be used to extract the contents of database objects for safekeeping or for migration, and restoring the objects at a later time. You will learn to use the ontape and ON-Bar utilities to perform backup and restore operations on dbspaces and logical logs in the database server. As a part of learning about the ON-Bar utility, you will learn how to manage backup media using Informix Storage Manager.
The course is updated for version 11.50 of Informix, but is suitable for those still running previous versions of IDS. This course is the classroom-delivered version of Instructor Led OnLine course Informix Backup and Restore - Instructor Led Online (3X440).
Kurz je určen pro:
This advanced course is for Informix System Administrators. It is appropriate for students using Informix Growth Edition, Informix Ultimate Edition, Informix Innovator-C Edition, or Informix Ultimate-C Edition.
Předpokládané znalosti:
You should have completed:
- Informix Dynamic Server System Administration course (IX811)
- or have experience in managing an Informix Dynamic Server installation
Co se u nás naučíte:
- Describe the terms and processes used in performing backup and restore operations
- Compare different backup strategies and determine which one meets recovery objectives
- Choose the most appropriate tool for you to use to perform backup and restore operations
- Perform backup and restore operations using ontape
- Manage devices and media using Informix Storage Manager
- Perform backup operations using ON-Bar
- Use the Archecker facility to validate backups
- Back up logical logs using ON-Bar
- Determine additional files that need to be backed up
- Perform restore operations using ON-Bar
- Analyze, test, and modify backup and recovery plans
- Describe how a strategy can be tuned for optimal restore time
Obsah:
Unit 1. Introduction to Informix Backup and Restore
- What is a Backup?
- What are Logical Logs?
- Restoring From Backup
- Group exercise: multiple choice
- Unit 2. Planning Recovery Goals
Unit 2. Recovery Planning Cycle (a slide to introduce the cycle)
- Developing a Recovery Strategy
- What Is Successful Recovery?
- Determine Acceptable Data Loss
- Determine Acceptable Recovery Time
- What Is Your Comfort Level?
- Exercise 1 (non-lab): Setting Recovery Goals
- Right, Fast, or Cheap?
- Identity Constraints Affecting Recovery
- Complete a Pre-Recovery Checklist
- Summary of Planning Items
Unit 3. Select the Proper Tools
- Select Tools for Recovery Plan
- Backup and Restore Tools
- Other Tools
- Replication Options
- Exercise 2 (lab): Initializing a Database Server
Unit 4. Backup and Restore Using Ontape
- Implementing an Backup and Restore Strategy Using Ontape
- Configuring Ontape
- Performing a Backup With Ontape
- Performing a Restore
- External Backup and Restore With Ontape
- Exercise 3 (lab): Backup and Restore Using Ontape
Unit 5. Introduction to ON-Bar and Informix Storage Manager
- Backup and Restore Using ON-Bar
- The ON-Bar Utility
- The Storage Manager (ISM, TSM, other SM)
- Informix Storage Manager (ISM)
- Using Tivoli Storage Manager
- Using Other Storage Managers
- Exercise 4 (lab): Configure/Prepare Storage Manager
Unit 6. Performing Backups Using ON-Bar
- Implementing an Backup and Restore Strategy Using ON-Bar
- Types of Database Server Backups
- Dbspace and Whole System Backups
- Whole System Backups
- Performing Backups
- Message File
- Emergency Boot File
- What Is Not Backed Up by ON-Bar
- Before Using ON-Bar
- Configuration Parameters
- Encryption Parameters
- ON-Bar Configuration Parameters
- Exercise 5 (lab): Backing Up Using ON-Bar
Unit 7. Validating Backups With Archecker
- Why Perform Backup Validation?
- Validating Backups With Archecker
- Two Phases of Archecker
- How Do I Use Archecker?
- Archecker Integration
- Archecker Syntax
- Archecker Configuration
- Gather Information for Recovery Testing
- Exercise 6 (lab): Using Archecker to Validate
Unit 8. Logical Log Backup With ON-Bar
- Why Back Up Logical Logs
- Are Logical-Logs Backups Necessary?
- Logical-Logs and No-Logging Databases
- When Are Logical Logs Backed Up?
- On-Demand Backups of Logical Logs
- Special Log Considerations
- LTAPEDEV Warning
- Salvaging Logical Logs
- Log Backups Required by ER
- Logical Logs and Simple Large Objects
- Exercise 7 (lab): Backing Up Logs With ON-Bar
Unit 9. Backing Up Additional Files
- Why Is Additional Backup Needed?
- Server Configuration Files
- Operating System Files
- How to Back Up Additional Files
- Other Information to Save
- Items for Recovery Testing
Unit 10. Performing Restores Using ON-Bar
- What Is a Restore?
- Types of Restore
- Temporary Log Space Requirement
- ON-Bar Restore
- Dbspace and Whole-System Restore
- Performing a Restore
- Other Types of Restore
- Validating the Restore Process
- Exercise 8 (lab): Restoring With ON-Bar
Unit 11. Analyzing the Strategy
- How Does the Strategy Work?
- Analyze Related Components
- Document the Recovery Procedures
- Test the Restore Strategy
- Decide What and How to Practice
- Document the Practice Results
- Make Changes to the Recovery Plan
Unit 12. Tuning Restore Time
- Tune the Strategy
- Why Must the Restore Be Fast?
- Plan Table and Disk Layout
- Schedule the Backup to Facilitate the Restore
- Tune Recovery Components
- Additional Courses Available
