1.PURPOSE AND SCOPE
With 11gR2 rman duplication its really easy to create standby database.
2.PRACTICE
Information Primary Database SID: PRIM Primary Database Domain/IP: ABSO Standby Database SID: PRIM_SBY Standby Database Domain/IP: CROO
Data Guard Broker installation, configuration, monitoring and deactiving
1.PURPOSE AND SCOPE
Oracle Data Guard broker software install with oracle database software and program bin file could find at $ORACLE_HOME/bin/dgmgrl location. Benefit of dgmgrl is most of the actions on primary/standby database can be done easyly through this tool, especilly switchover and managing primary/standby database.
2. IMPORTANT
When you are using the Broker to maintain your Data Guard configuration you must use either the Broker command line interface ‘DGMGRL’ or Grid Control to make any changes to your Data Guard configuration. If you desire to use SQL*Plus then you should remove the the Data Guard Broker configuration using the ‘REMOVE CONFIGURATION PRESERVE DESTINATIONS’ command in DGMGRL. Then you must set the DG_BROKER_START parameter to ‘FALSE’ on all database in the configuration.
Installation of Logical Standby
1.PURPOSE AND SCOPE
At another article of mine ,I explained installation of Physical standby and this article we are going to convert physical standby database to logical standby.
2.PRACTICE
2.1. At primary database we need to execute a query to see which tables are not supported by logical standby
Duplicate komutuyla primary asm database’inden non-asm standby database kurulumu
1.AMAÇ VE KAPSAM
ASM kurulu bir veritabanına duplicate komutuyla non-ASM standby yaratmak.
2.UYGULAMA
Database Özellikleri
Database Name :- bugra
Primary db_unique_name : bugra // ASM
Standby db_unique_name : stdby // non-ASM
Primary Hostname :- bugra.localdomain // 192.168.2.101
Standby Hostname :- stdby.localdomain // 192.168.2.102
2.1 Oluşturacağımız dosyalar için primaryde ve standbyda lokasyonları yaratıyoruz.
[Read more…]