Project

General

Profile

Actions

Database Mirroring (DB2) on remote site » History » Revision 5

« Previous | Revision 5/23 (diff) | Next »
chin-yeh, 03/21/2012 05:58 PM


Database Mirroring on remote site

Introduction

To mirror production database(s) to remote site, there are a number of approaches:
  1. Use (full) database backup
  2. Use (full + incremental) database backup
  3. Use (full + delta) database backup
  4. Use (full + incremental + delta) database backup - not recommended because it is too complex
  5. Use (full database backup + transaction logs)

the approach 1-4 are described in Using DB2 incremental backup

The following sections will describe how the last approach actually works. Before that, let's do a compare:

Full Database Backup + Transaction Logs

Below diagram describes how this approach works:

Updated by chin-yeh almost 13 years ago · 5 revisions