Implement Oracle Data Guard using EM Grid Control.

If you want to use the Grid Control to create and manage Data Guard, you need the following components: Oracle Management Server (OMS), repository database installed, and Grid Control Agent installed on the servers in your Data Guard Configuration - both primary and standby database systems

The remaining steps are just navigating along and answering the questions.  Once you finish answering questions, just click Finish. 

Below are the example of configurations that the answers I made to all the questions.

Primary Database              
Target Name                      CHICAGO               
Database Name                  chicago   
Instance Name                   CHICAGO               
Database Version               11.2.0.2.0               
Oracle Home                      /oracle/product/11.2.0/RDBMS   
Host                                 si01.an.com          
Operating System               Red Hat Enterprise Linux Server release 5.6 (Tikanga) 2.6.18          
Host Username                   oracle   

Standby Database             
Target Name                      NEWYORK             
Database Name                  CHICAGO               
Instance Name                   CHICAGO               
Oracle Server Version          11.2.0.2.0               
Oracle Home                      /oracle/product/11.2.0/RDBMS   
Host                                 pi01.an.com         
Operating System:              Red Hat Enterprise Linux Server release 5.6 (Tikanga) 2.6.18          
Host Username                   oracle      
Backup Type                      New backup         
File Transfer Method            RMAN duplicate                 
Database Unique Name        NEWYORK             
Database Storage                Automatic Storage Management                
ASM Instance                    +ASM_pi01.an.com  
Standby Type                      Physical Standby                
Database Area                    DG_DATA01         
Flash Recovery Area            DG_FLASH01        
Flash Recovery Area Size (MB)   10061M                  
Automatically Delete Archived Redo Log Files     Yes           
Configure Standby Database with Oracle Restart               No
                 
Standby Database Storage             
Database Area                                           DG_DATA01  
Flash Recovery Area                                    DG_FLASH01  
Multiplex Redo Log Files and Control Files      No  


Tablespaces         
Name Size (MB)                   Status           Type      Standby Location               
SYSAUX                781         ONLINE         PERMANENT      DG_DATA01         
SYSTEM                731         ONLINE         PERMANENT      DG_DATA01         
TEMP2                  1025       ONLINE         TEMPORARY      DG_DATA01         
TOOLS                  101         ONLINE        PERMANENT      DG_DATA01         
UNDOTBS1            71          ONLINE         UNDO              DG_DATA01         
USERS                  54           ONLINE        PERMANENT      DG_DATA01      
  

Directory Objects               

Directory             NamePrimary Directory Path      Standby Directory Path   
MY_EXP                        /tmp/dba/CHICAGO           /tmp/dba/CHICAGO         
DATA_PUMP_DIR           /admin/CHICAGO/dpdump/ /admin/CHICAGO/dpdump/  

No comments:

Post a Comment