Chapter 3    Administering the JADE Database

This chapter covers the following topics.

• What Is a Backup?

  • Why Are Backups Important?

  • When to Take Backups

  • Types of Failure

• Physical Database Structures

  • Database Files

  • Journal Files

  • Database Control File

• Database Identities

• Transaction Journal Files

  • Journal Switches and Journal Numbers

  • Quietpoints and Long Transactions

  • Checkpoints

  • Archived Transaction Journals

  • Database Archiving Modes

  • Automated Journal Close Actions

  • Unaudited Database File and Partition Operations

• Backups

  • Offline Full Backup

  • Online Quiesced Backup

  • Online Full Backup

  • Verification during Backup

  • Choosing a Backup Strategy

  • The Danger in Backing Up the Online Transaction Journal

  • Backing Up Your JADE Development Environment

  • Custom Backup Support

• Recovery Concepts and Strategies

  • Automatic Restart Recovery

  • Restoring and Recovering the Database

  • Roll-Forward Recovery Restrictions

  • Roll-Forward Recovery of a Standby Database

• Data Corruption

  • What Causes Data Corruption?

  • Detecting Data Corruption Problems

  • Performance Considerations

• Checking the Integrity of the Database Control File

• Database Certification

• Reindexing Database Files

• Evaluating Free-Space

• Compacting Files

• Resetting Timestamps

• Transient Database File Analysis

See also Chapter 1, "Administering a JADE Synchronized Database Service (SDS) Environment", in the JADE Synchronized Database Service (SDS) Administration Guide.

VERSION 2018.0.01  |  Copyright © 2018  Jade Software Corporation Limited.  All rights reserved.