Oracle Standby database [20 mn de lecture - paru le 5/10/2004 6:03:31 PM - Public : Débutant]

Auteur

Romain JAUFFRET Elève-Ingénieur Supinfo Paris Promotion SUPINFO 2005    Lui écrire    Tous les projets de cet auteur    Le mini-CV de cet auteur

Summary

Along this article, we will see how to setup a standby database. Several points used in this article were seen in a previous project (in French), such as datafiles plan, redo log files, control files, and its general topology. It is not necessary to read the previous project in order to understand this one.

Synopsis

Introduction
1. Definition and environment
1.1. Definition
1.2. What's new in Oracle9i R2: logical-standby / physical-standby
1.3. Environment
2. Basic preparation
2.1. Requirements and constraints
2.2. Backup primary database
3. Control files and archive log
3.1. Setting up primary database
3.2. Setting up standby database
4. Restore data
4.1. Verify setup
4.2. Restore database
Conclusion