Ingeniero

Oracle 10g Data Guard
(Summary Sheets) v. 2.0 Draft Edited By: Ahmed Baraka

1. INTRODUCTION TO ORACLE DATA GUARD 4 1.1 DATA GUARD CONFIGURATIONS AND ARCHITECTURE 1.2 DATA GUARD SERVICES ........................................ 4 1.3 DATA GUARD BROKER .......................................... 4 1.4 DATA GUARD PROTECTION MODES ...................... 4 1.5 DATA GUARD AND COMPLEMENTARYTECHNOLOGIES 1.6 SUMMARY OF DATA GUARD BENEFITS ................. 4 2. GETTING STARTED WITH DATA GUARD ...... 5 2.1 STANDBY DATABASE TYPES ................................. 5 2.3 DATA GUARD OPERATIONAL PREREQUISITES ....... 5 2.4 STANDBY DATABASE DIRECTORY STRUCTURE CONSIDERATIONS 5 2.5 ONLINE REDO LOGS, ARCHIVED REDO LOGS, AND STANDBY REDO LOGS 6 3. CREATING A PHYSICAL STANDBY DATABASE 7 4 4

3.1PREPARING THE PRIMARY DATABASE FOR STANDBY DATABASE CREATION 7 3.2 CREATING A PHYSICAL STANDBY DATABASE ....... 8 3.3 FURTHER PREPARATIONS .................................... 10 4. CREATING A LOGICAL STANDBY DATABASE 11 11

4.1 PREPARING FOR LOGICAL STANDBY DATABASE CREATION 4.2 CREATING A LOGICAL STANDBY DATABASE....... 12 4.3 FURTHER PREPARATIONS .................................... 14 5 REDOTRANSPORT SERVICES .......................... 15

5.1 USING THE LOG WRITER PROCESS (LGWR) TO ARCHIVE REDO DATA

15 15

5.2 SPECIFYING ROLE-BASED DESTINATIONS WITH THE VALID_FOR ATTRIBUTE 5.3 WHAT TO DO IF ERRORS OCCUR ......................... 15 5.4 SETTING UP A DATA PROTECTION MODE ............ 16 5.4.1 DATA PROTECTION MODE REQUIREMENTS ...... 16 5.4.2 STEPS TO SETUP THE DATA PROTECTION MODE165.5 PLANNING FOR GROWTH AND REUSE OF THE CONTROL FILES 16 16

5.5.1 SIZING THE DISK VOLUMES THAT CONTAIN THE CONTROL FILES 5.5.2 SPECIFYING THE REUSE OF RECORDS IN THE CONTROL FILE 5.6 MANAGING ARCHIVE GAPS................................. 17 5.6.1 MANUALLY DETERMINING AND RESOLVING ARCHIVE GAPS 5.7 VERIFICATION ..................................................... 17 5.7.1 MONITORING LOG FILEARCHIVAL INFORMATION
1

17

17

17
Oracle 10g Data Guard Summary Sheets

6 LOG APPLY SERVICES........................................ 19 6.1 LOG APPLY SERVICES CONFIGURATION OPTIONS19 SETTING ARCHIVE TRACING ..................................... 20

2

Oracle 10g Data Guard Summary Sheets

Usage Terms • Anyone is authorized to copy this document to any means of storage and presentit in any format to any individual or organization for non-commercial purpose free. • No individual or organization may use this document for commercial purpose without a written permission from the editor. • There is no warranty of any type for the code or information presented in this document. The editor is not responsible for any loses or damage resulted from using the information orexecuting the code in this document. • If any one wishes to correct a statement or a typing error or add a new piece of information, please send the request to info@ahmedbaraka.com . If the modification is acceptable, it will be added to the document, the version of the document will be incremented and the modifier name will be listed in the version history list.

Version History
Version Date Updates1.0 2.0 B

Sept, 2006 June, 2010

Initial document. Updating and correcting the information. Draft copy.

Document Purpose This document is edited to be a quick hand book reference on using Oracle Data Guard in Oracle 10g Database. It is simply a summary of the Oracle documentation. However, many other resources were used a supporting materials.

3

Oracle 10g Data Guard Summary Sheets1. Introduction to Oracle Data Guard
1.1 Data Guard Configurations and Architecture
• Primary Database • Standby Databases o Physical standby database o Logical standby database

1.2 Data Guard Services
• Log Transport Services • Log Apply Services: Redo Apply or SQL Apply • Role Management Services

1.3 Data Guard Broker
The Data Guard broker is a distributed management framework...